Juniper Systems Allegro DOS Manual User Manual
Page 147
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)