2.2.3.55 wlabel


Contents

Brief Information

Set display format of column label row.

Note: There is only GUI way to right click label and set its display format.

Command Line Usage

1. wlabel type:=L fmt:="*3";

2. wlabel ty:=C rt:=1;

3. wlabel ty:="File Date" fmt:="yyyy-MM-dd HH:mm";

4. wlabel ty:=D2 fmt:=".2";

5. wlabel ty:="My Time" fmt:="THH:mm";

6. wlabel ty:=MyParam ex:=show;

7. wlabel ty:=MyParam ex:=clear;

X-Function Execution Options

Please refer to the page for additional option switches when accessing the x-function from script

Variables

Display
Name 		Variable
Name 		I/O
and
Type 		Default
Value 		Description
iw iw

Input

Worksheet

<active>
 Specify the input range
execute execute

Input

int

0
 Get or set cell properties.

Option list:

  • 0=set:Set format
  • 1=clear:Clear Format
  • 2=show:Show Format
type type

Input

string

D1
 The character or the name of the column label row.

Please refer to the Character in this table.

fmt fmt

Input

string

Specify the format of the column label row.

Please refer to the format in this page

rt rt

Input

int

-1