...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Table of Contents maxLevel 4 minLevel 2
ORG-3422
| Table of Contents |
|---|
Create and plot a named range via virtual dataset
ORG-3423
Syntax: create name -nrs extract_rule [range_string, designation, scope_range_string]
| Value | Meaning |
|---|---|
| 0 | Concatenate by column. Combine the values in a selected block of cells through column direction. |
| 1 | Concatenate by row. Combine the values in a selected block of cells through row direction. |
| 2 | Mean of row. Use the mean value of each row in selection. |
| 3 | SD of row. Use the standard deviation of each row in selection. |
| 4 | Even rows. Use the values in the even rows of selection. |
| 5 | Odd rows. Use the values in the odd rows of selection. |
| Code Block |
|---|
//Plot a graph with 1st row of worksheet as X, 2nd row of worksheet as Y
create myvsx -nrs 1 "[Book1]Sheet1![1]:[1]";//Create a virtual dataset myvsx from 1st row of Book1 Sheet1
create myvsy -nrs 1 "[Book1]Sheet1![2]:[2]";//Create a virtual dataset myvsy from 2nd row of Book1 Sheet1
plotxy (myvsx, myvsy);//Plot a graph, using myvsx as X and myvsy as Y |
| Code Block |
|---|
//Plot a box chart from a block of cells
create myvsbox -nrs 1 "[Book1]Sheet1!1[2]:3[4]"; //Create a virtual dataset myvsbox from a block of cells
win -t p box; //Create a black graph window with box chart template
layer -i206 myvsbox;//Add virtual dataset myvsbox to the graph |
LabTalk Callable OC function to Execute an Operation
...
Range Notation Improvements
Support Variables for Row Subrange Notation
...
| Code Block |
|---|
int a = 1; int b = 12; range rr=col(1)[a:b]; |
...
Virtual Dataset for a Block of Cells
ORG-8226
| Code Block |
|---|
//Import a sample data into a new book fname$=system.path.program$ + "\Samples\Matrix Conversion and Gridding\DirectXY.dat"; newbook; impasc; //Define the first row (from column B to E) as the first block range -v r1=B[1]:E[1]; //Define the first column (from row 2 to 6) as the second block range -v r2=A[2:6]; //Assign the values in the first block to the second block r2=r1; |
Support Range Declaration for Local Loose Dataset:
| Code Block |
|---|
dataset ds1,ds2; range rngld1=[??]!ds1; range rngld2=[??]!ds2[10:15]; range aa=1!1, bb=2[10:15]; //Given col(a)&col(b) is filled with row numbers: rngld1=aa; rngld2=bb; |
...
| Function Area | Variable | Type | Default | Supported | Description |
|---|---|---|---|---|---|
| Smart Labeling | @SLD | bool | 0 | globally enable smart labeling of data label | |
| @SLDF | double | [0.0, 1.0] | favor count factor, missing value means auto | ||
| @SLDL | bool | 0 | look ahead | ||
| @SLDM | double | measure constant variant, missing value means auto | |||
| @SLDR | double | ray number, -1 means auto | |||
| @SLDG | double | Smart Labeling reposition gap | |||
| Hidden Row | @GMH | bool | 0 |
| |
| @b3d0 | bool | 1 | whether minus values needs down drawing | ||
| @b3d0b | bool | 1 | whether z=0 face shows black color | ||
| Polar Grid | @DPA | 3 | % of DPI as a minimum distance between closest grids | ||
| @CWS | int | 13 | Change Worksheet search option bits. 1 = Compare column short name 2 = Compare column long name 4 = Compare column designation 8 = Compare column index. | ||
| @OGLSL | bool | 1 | 1 = Enable shearing for axis titles and tick labels if they are in axis plane and 3D cube has been sheared. 0 = Disable their shearing. | ||
| Text Filter | @TFS | int | 1 | 0,1,2,3 | Text Filter label display 0=Enter, 1=Space (default), 2=Comma, 3=Semicolon |
| @TFL | double | 50 | The max length of text filter label | ||
| @AUFL | bool | if it is non-zero, always set Auto as auto update mode; if @AUFL equals to zero, check whether there is an operation in the column, if there is, keep therecalculate mode, otherwise, set Auto as recalculate mode. | |||
| Paste Unicode | @PSTU | int | 4 | 0,1,2,3,4 |
|
| Copy Unicode | @COPU | int | 1 | 0,1 | 0 = Disable to put unicode on clipboard 1 = Enable to put unicode on clipboard |
| @ARD | int | 0 | 0, 1 | 0 = Restrict direct arithmetic's like +2 in Script Window 1 = direct arithmetic's like +2 in Script Window. When enabled, user can highlight column B in worksheet, and then enter +3 in Script window to add 3 to each row of column B | |
| Rescale When Manual | @NRM | 0 | 0,1 | 0 = Enable to scale in or scale out (old behavior) when axis scale is set to manual 1 = Disable to scale in or scale out when both axes scale are set to manual |
...
| Name | JIRA | Description |
|---|---|---|
| wks.hierarchical | ORG-8452 | LT property to indicate if worksheet is hierarchical (i.e., report sheets) |
Provide Tooltip for any object with Script, Run After set – We will hide it in 9.1
...