Versions Compared

Old Version 35

changes.mady.by.user Billy Wang

Saved on

compared with

New Version 36

changes.mady.by.user Ryan Chen

Saved on

Key

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

Graphing

New Graph Types

...

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.

ORG-27110

Support to import Eastern/Central European characters

Support import ANSI file with Eastern/Central European characters.

If the ASCII file is UTF-8 encoding, just import it directly, if the file is ANSI encoding, then need to set @cps=1250 to import.

Export

JIRA

SUMMARY

DESCRIPTION

DETAILS

ORG-26748

Want export matrix window as image support graph objects

A new system variable @UPM can be used to control this (default = 1 means to include the graph objects and this fix, or 0 to use old behavior)

1.New a project, open attached “Test UPC.opju”

2.With matrix window active, select File menu - Export - Image, and export as *.png file with default settings.

3.Check the exported image file.

==> It does not show the graph object (the colorful one, named with “paths“)

ORG-21563

Plot Highlight Improvements suggested by Thomas Preuer

We support exporting plot selection effect and data highlighter effect.

We can support it in Copy Graph as Picture tool and Export Graph tool.

Export Graphs Advanced will be later.

If there are multiple plots in the graph, we can select one of them and export the selection effect.

We can use data highlighter tool to highlight some data and export the highlighter effect.

...

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.

...