Versions Compared

Old Version 21

changes.mady.by.user Polly Tan

Saved on

compared with

New Version 22

changes.mady.by.user Penny Mok

Saved on

Key

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

...

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

JSON connector support auto detect date time, and import as date time

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-27156

Intermediate book issues on in batch processing

When batch processing with large files, Hide intermediate workbook due to OS resource exhausts

System variable @BIW to control show/hide intermediate workbooks

Code Block
@BIW=0;          //hide all intermediate workbooks
    =-1;         //do not hide any (current behavior)
    =N like 100; //default, Show only the first N books (N=100)

Fitting

JIRA

SUMMARY

DESCRIPTION

DETAILS

ORG-25071

Support different Digits for Value and Error in the result table

Add Custom Display for Error Value edit box in the fitting tools.

  1. Open fitting tools and go to Output: Graph: Result Table section, set Custom Display for Error Value as “.2“ for example.

  2. Check the result table on the fitted plot.

→ Parameter value show 5 decimal digits(default) and error value show 2 decimal digits.

Data Handling

Worksheet

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, Sheet Label can be used as Data Identifier.

...