Promote worksheet data rows to label rows
1. wrow2label longname:=1 unit:=2;
2. wrow2label comment:=3 removerow:=0 showlabel:=0;
Please refer to the page for additional option switches when accessing the x-function from script
| Display Name |
Variable Name |
I/O and Type |
Default Value |
Description |
|---|---|---|---|---|
| Worksheet To Set Label Value | iw |
Input Worksheet |
|
Specifies the input worksheet. |
| Row Index of Name | name |
Input int |
|
Specifies the index of the row that will be converted to short name. Note that from Origin 2017 column Short Name is restricted to alphabetical order and it cannot be edited by default. So Row Index of Name option is hidden from GUI. If you want to rename column Short Names, you will need to go to the input workbook, uncheck Spreadsheet Cell Notation checkbox in the Properties tab of Window Properties dialog to enable editing column Short Name. |
| Row Index of Long Name | longname |
Input int |
|
Specifies the index of the row that will be converted to long name. |
| Row Index of Unit | unit |
Input int |
|
Specifies the index of the row that will be converted to unit. |
| Row Index of Comment | comment |
Input int |
|
Specifies the index of the row that will be converted to comment. |
| Remove Rows | removerow |
Input int |
|
Specifies whether to remove the converted rows. |
| Show Labels | showlabel |
Input int |
|
Specifies whether to force the label rows that have the converted information to be shown after this X-Function is executed. |
This X-function is used to set the label value.