Page Comparison

Data Handling

...

JIRA

SUMMARY

Description

DETAILS

ORG-20778

Excel like pi product function

Add product Labtalk function which returns the product of a dataset

double product(vector vd)

E.g. column A is filled with 2, 3, 4, 5

In B1 cell, enter = product(A) will get 120, which is 2*3*4*5.

ORG-21992

Excel like LET function

Add LET Labtalk function which pairs values and names and calculates the expression using the names

Easier to write complex formulas, by making it possible to declare and assign values to variables inside a formula

LET(name1, exp1, [name2…], [exp2…], calculation)

exp1 is resolved and assigned to name1, exp2 is resolved and assigned to name2, then assign names to calculation for result.

LET(x, 1, x+1) -> 2

LET(sum, total(A), n, count(A), sum/n)

ORG-13898

Command Window improvement

Command Window now supports Zoom in/out and auto code complete

support mouse wheel zoom, more support on auto complete

ORG-21926

Introduce new LabTalk command to update pending locks

Improve Labtalk command run -p to update pending locks for active book/sheet.

Code Block
run -p aub;//active book run -p auw;//active sheet run -p aubd;//active book and all its descendants run -p auwd;//active sheet and all its descendants

ORG-21587

LabTalk Access to Dash Definition at Plot Level

Labtalk command set supports setting line dash property.

Syntax: set name -ldf value

Code Block
set %c -ldf "5 20 10";

ORG-19233

GetN supports dataset elements

GetN Box now supports to assign dataset values.

E.g.

dataset values;
values.setsize(3);
getn (Value 1) values[1] (Value 2) values[2] (Value 3) values[3];

ORG-22214

LT Labtalk control of Box Plots

Add more Labtalk controls to customize Box Plot properties such as statistical lines, labels, etc

layer.plot1.boxchart.line=1,2,3; //show lines in box chart, 1=median,2=mean or 3 both

layer.plot1.boxchart.label=1,2,3;//show label of line, 1=median,2=mean or 3 both

layer.plot.label.font=1; //label font

layer.plot1.label.fsize=20; //label font size

layer.plot1.label.color=2; //label color based on color list, e.g. 1=black, 2=red, etc.

ORG-18101

Sort columns by Long name, etc.

Added Labtalk worksheet method SortCols() to sort columns by Long names

wks.SortCols(L,d);//sort LongName decending

ORG-21874

ORG-22418

ORG-22525

Labtalk access to more plot properties

Add more Labtalk controls to customize plot properties such as symbol overlaps, label properties, etc

Code Block

layer.plot.label.Spec$="0";//to show label at end of plot
layer.plot.label.Spec$="";//turn off show label at specific indices checkbox
layer.plot.label.fsize
layer.plot.label.color
layer.plot.label.form$
layer.plot.symbol.offset = 1; // Symbol Overlapped Arrangement: 0=disable, 1=horizontal, 2=vertical
layer.plot.symbol.oct = 1; // Symbol Overlapped offset center type
layer.plot.contlines = 1; // Enable Contours for surface plot
layer.plot.contmat //specify the index of matrix use for contour line, 0 = self
set/get %c -ccl name //set/get the matrix use for contour line
layer.plot.colorlist$
layer.plot.symbol.size
layer.plot.symbol.kind

ORG-22475

GetNBox focus issue

Increase default GetNBox entry area length focus time

Changed the default value of @ETG to 1700.

ORG-22313

Skip none-accessible objects in doc looping

doc -e G will skip none-accessible objects in looping graph objects.

When use doc -e G command to loop for all labels and other named objects in the active graph layer, the objects that not accessible from LabTalk will be skipped now.

ORG-21997

Plot Hide Show events from Labtalk

Add a new event “Plot Hide Show” in Object Properties

Open Object Properties dialog, in Programming tab, a new event is added in the Script Run After drop-down list. Choose it and then script will be execution when plot hide/show.

...

Versions Compared

Old Version 237

New Version 238

Key

Data Handling