Juniper Systems Allegro DOS Manual User Manual

Page 147

Advertising
background image

Windows CE Page 4-81

Default values of parameters: Chart(“Type:Bar”, “”Series:Rows”,
“Legend”, “Xaxis”, “Yaxis”, “Xgrid:No”, “Ygrid:Yes”, “AutoScale”).
Example: Sel(a1:c20)

Chart(“Type:XY”, “Title:Sin(x)”, “Xgrid”, “Ygrid”)
Sel(b2:f5)
Chart(“Series:Columns”, “AutoScale:No”)

Clear()
Clears contents in the current selection.
Example: Clear()

ClearFormat()
Clears format in the current selection.
Example: ClearFormat()

ColHide([hideUnhide])
Returns whether the first column of current selection is hidden and
hides (true) or unhides (false) selected columns if hideUnhide is
specified.
Example: Sel(B1:B1)

ColHide(true)

ColWidth([width])
Returns column width of the first column of current selection and sets
width of selected columns if width is specified.
Example: Sel(B1:C1)

ColWidth(100)

Copy()
Copies the current selection to the clipboard.
Example: Sel(A1:A5)

Copy()
Sel(B1)
Paste()

DeleteCells(colsRows)
Deletes cells (true - columns, false - rows).

Example: DeleteCells(true)

FileBox(title [,filter])
Opens a file dialog box with the title and the file type filter.
Example: picture=FileBox(“Pictures”,

“*.jpg,*.gif,*.bmp,*.2bp,*.xbm”)
ShowPicture(picture)

Filter(onOff)
Sets auto filter (true = autofilter on, false = autofilter off). Auto filter
range is the current selection.
Example: Filter(true)

Advertising