Page Comparison

1537

ORG-21432

Access to name of embedded notes window

Provide labtalk function to access to name of embedded notes window

With embedded notes sheet active, run the following to pop the notes window open

win -an %@G;

1538

ORG-21409

Connect to Web Support Self-Signed SSL certificate

Accept self-signed or invalid SSL certificates checkbox is added.

Many intranets use self-signed SSL certificates. Connect to Web can accept them via Accept self-signed or invalid SSL certificates checkbox. Otherwise there will be an error if not checked.

1533

ORG-21202

LabTalk command to open Edit Range dialog

Provide Labtalk command to open Edit Range dialog to edit display range of plot

layer -ep to edit display range of plot

1530

ORG-21286

Labtalk function to Join arbitrary ranges as a single dataset

Provide labtalk function to Join arbitrary ranges as a single dataset

Dataset join(range1, range2, ...)

e.g. =mean(join(A1:A2, C5:D8)

1526

ORG-21065

LabTalk functions to categories operations

Provide new labtalks functions for category operations

They are accessible under It’s Function → Lookup & Reference menu in Set Column Values dialog

• category(vd)$ – e.g. category(A) or category(A)$

• catindex(vd) – e.g. catindex(A)

• catrows(vd)$ – e.g. catrows(A) or catrows(A)$

• cattext(vd, vd)$ – reverse of catindex(), e.g. cattext(E, A) or cattext(E, A)$

1534

ORG-21188

LabTalk property to get plot type info

Layer property to get plot type info

layer.plot1.pid

1532

ORG-21236

More LabTalk function to support partial range as input

All LabTalk function is improved to support using partial range as input.Some LabTalk function Improvements

• Set Column Values dialog: Under Function: Lookup & Reference and Function: Logical submenus, adding [$] functions at the end of those functions that return string

• Some lookup() function bug fixes, including system variable to disable numeric lookup @LKN=0

• Now all LabTalk function is improved to support using partial range as input.
  Example,

newbook;
col(A) = {1, 3, 2, 5, 1, 7, 4, 10};
range rr = col(A)[3:6];
col(B) = sort(rr);

1527

ORG-21078

New Column Properties

New Column Properties are added to check whether the column is categorical or to be using sampling interval

• New Property IsCat to set a column to be categorical or check a column is categorical

wks.col1.IsCat

• New Property EvenX to both get and set a column to be using Sample Interval.

wks.col1.EvenX

1539

ORG-20879

Page Control Pane Framework

Support Labtalk for Page Control Pane

Support LT for Page Control Pane.

page.cp.Add();//add a control pane to the left with default

page.cp.Add(2 40 DataConnector 3);

//First parameter: 1=left, 2=top,3=right,4=bottom

//Second parameter: window width(%)

//Third parameter: control pane type

//Four Parameter: APPLY Button = 1, Hide Show Pane Button=2

page.cp.Remove();//Remove control pane

page.cp.Show = 0;//to hide it, and =1 again to show it

1529

ORG-21288

Useful Labtalk functions added

Sem() and Between() Labtalk functions

• Sem(vd) to calculate standard error in cell, column formula and script. Available under Under Function → Statistics menu in Set Column Values dialog.

• Between(str$, str1$, str2$)$ function to extract text between certain strings, E.g. if column A is filled with email addresses, use use between(A, "@", "."). to get text between @ and .

1536

ORG-21671

Set Order for Worksheet column labels quickly

Using wks.Labels(@) to reset current worksheet column label row to default order.

wks.Labels(@);

Reset current worksheet column label row to default order.

1528

ORG-21127

Split Text Cell / Text to Columns tool like Excel

Add X-Function to split Text Cell / Text to Columns tool like Excel

Add xfunction text2cols.OXF and put it under : ..\Origin\X-Functions\Data Manipulation\Worksheet\text2cols.OXF

In Script window, type text2cols -d to open the dialog

1531

ORG-20706

Support returning vector result to LT StringArray

Vector properties are also available to StringArray

Following usage is now supporting.

StringArray sa;
sa = unique(col(A));
sa.getsize() =;

1535

ORG-21674

Unix timestamp conversion function

UnixTime() to convert to and from Unix timestamps.

New function to convert to and from Unix timestamps.

double UnixTime(d1[, d2, n])

Where d1 is a Unix timestamp or Julian date, d2 is a timezone offset (default 0), if n=0 (default) convert from Unix time stamp to Julian date. If n=1 it convert from Julian date to Unix timestamp. Supports vectors for SCV usage.