Versions Compared

Old Version 40

changes.mady.by.user Billy Wang

Saved on

compared with

New Version 41

changes.mady.by.user Polly Tan

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Graphing

New Graph Types

...

JIRA

SUMMARY

DESCRIPTION

DETAILS

ORG-26738

Sort Alluvial Node by Frequency

We can sort Alluvial node by name/ frequency.

In Node tab, add Node Order by option above Gap between Nodes. dropdown could be

  • None: current way, order of data, or categorical order

  • Name: alphabetical order

  • Frequency: frequency of node in column

ORG-27027

XF to Create Multiple VM and Plot Heatmap

A new dialog: plotmultivm to create heatmap with multiple info in one cell.

Command line usage for Existing Virtual Matrices type:

plotmultivm datatype:=vm irng:=VM1|VM2;

ORG-26846

Layer Content and Plot Setup Issues to Create Heatmap

Plot setup and layer content could list virtual matrix

In layer content, we list Virtual Matrices in data type dropdown list.

We also do the same for plot setup, list Virtual Matrices above Loose Datasets.

It should also list “Heatmap“ in Plot Type list box.

ORG-26739

Alluvial Label Improvements

Alluvial Plot Label On Top

Outside Node Position All Left/Right

In Label tab, add Position option in Show Label for plot group, under font, ratio could be Top, Bottom. Move Offset to 3rd line after this option.

For Outside Node Position, add Left, Right option before Top. This change could also apply to Sankey.

ORG-27159

ORG-26325

Fit Page to Layers Include All Graph Objects

supportFit Page to Layers Include All Graph Objects

In Fit Page to Layers dialog, add checkbox variable “go“ Include All Graph Objects in the end, default select it. Select it means all graph objects should be included when fit page, including graph objects that attach to page.

In Button Edit Mode (Ctrl+Alt+B), if a graph object is attached to page: a string “(P)” will be appended to the displayed object name.

ORG-26928

Sankey Map Support Pie Node

show in and out pie chart instead of bubble

In Node tab of Sankey Map, add Show In&Out Pie Chart for Node checkbox under Fill color. Default is unchecked.

ORG-26489

Increment by one or stretch depending on if it's color list or palette

When we set a color list, if increment is None/Binned/Stretch, we should set it to by one. For palette, no need to change current rule.

  1. Enter “s annotation” in Start menu and choose Line and Symbol Graphs - Multi-line-plot with Special Position Annotation Line sample

  2. Highlight all data in book and plot Browser graph: Color Lines

  3. Select all plots on left.

  4. Click on any plot and from mini toolbar Group tab, click Line color to change it to e.g. Bold1

  5. ==> The colors are not red, blue, green purple.

If go to Plot Details → Group tab, the Line Color increment is stretch.

Import

JIRA

SUMMARY

DESCRIPTION

DETAILS

ORG-26952

CSV connector failed to keep Text type column format

Added a system variable @IPKF to control which column format would be kept after import.

The @IPKF system variable is for CSV Connector only.

  • 0(default): keep date/time column format

  • 1: keep date/time/Text column format

  • -1: keep any column format

ORG-26921

CSV Connector supports append rows from script

CSV Connector supports append rows to import more files by scripts.

LT sample scripts:

Code Block
newbook;
string fname, path$=system.path.program$ + "Samples\Batch Processing\"; 
findfiles fname:=fname$ ext:="*.csv";
int num = fname.GetNumTokens(CRLF);
wbook.dc.add("CSV");
loop(ii,1,num)
{
next$ = fname.GetToken(ii, CRLF)$;
if (ii==1)
{
	wks.dc.flags=256;	// turn on append rows mode
}
wks.dc.source$=next$;
Tree tr1=wks.dc.optn$;
tr1.settings.partial.SetAttribute("Use", 1);
tr1.settings.partial.row$="2";
tr1.ToString(wks.dc.optn$);
wks.dc.import();
}

ORG-27074

Connector failed for Date Time More Cases

Improved JSON Connector to support auto detect date time, and import it as date time data.

For example:

the 1996-08-20T00:00:00 value will be imported as 1996-08-20 00:00:00 with column format “yyyy-MM-dd HH:mm:ss”.

ORG-27317

Want to choose variable for BioLogic Connector

Improved BioLogic Connector to support choose variable(s) to import.

When connect to BioLogic file, will show up Data Connector Browser for user to choose variable(s) to import.

...

JIRA

SUMMARY

DESCRIPTION

DETAILS

ORG-27279

Split Worksheet and Append Worksheet Improvements

Put value in output sheets label when split worksheet by value change , and use sheet label when appending sheets

  • When splitting worksheet by reference column’s value change, the info. was lost in result sheets. In Origin2024, the value will be put to sheet label of each output sheet.

  • When appending worksheets and stack worksheets, sheet Label can be used as Data Identifier.

ORG-27245

Smart Paste from Excel --beta2

When paste data from Excel, Origin will do a smart checking to detect heading rows and paste to column label.

See below, copy all data from Excel. In Origin, new a workbook, paste to A1 cell or highlight column A to paste. Origin will detect the 1st row is heading and paste to Long Name label smartly, and the other data will still paste to data area.

...