beautypg.com

Juniper Systems Allegro DOS Manual User Manual

Page 146

background image

Page 4-80 Windows CE

You can structure your code into more simple tasks and then you can
call previously defined task from within a task using its name.
Example:
Set(a1,100)
while a1>0
Hello
Set(a1,a1-1)
end

Automating Tasks Functions Reference
Parameters in [ ] are optional.

ActiveCell()
Returns the active (highlighted) cell.
Example: Set(ActiveCell(), "Hello World!")

ActiveSheet([index])
Returns the number of the active sheet (1-based) and selects the new one
if index is specified. Returns "!!Val" if index is less than 1 or greater than
number of sheets.
Example: ActiveSheet(2)

CellRef(col, row [, sheetIndex])
Returns the cell reference.
Example: Set(CellRef(a1,2), 123);

CellTask(text, task [, icon])
Creates cell task in the current cell. Text is cell label visible in sheet, task
is task source and icon is number of icon (see Cell Task dialog for more
info). If icon=0 (or if this parameter is omitted) cell task is executed by
tapping on cell. If icon>0 then cell task is executed by tapping on icon.
Example: CellTask(“Picture”,”ShowPicture(””pic.jpg””)”,3)

Chart([“Type:Bar/Line/LineMarkers/Pie/XY/XYLines/XYLinesMarkers”,
“Title:ChartTitle”,
”XTitle:XaxisTitle”,
”YTitle:YaxisTitle”,
“Series:Rows” or “Series:Columns”,
”Legend” or “Legend:No”,
”Xaxis” or “Xaxis:No”,
”Yaxis” or “Yaxis:No”,
”Xgrid” or “Xgrid:No”,
”Ygrid” or “Ygrid:No”,
”AutoScale” or “AutoScale:No”])
Shows the chart of the selection. All parameters are optional and their
order is not important.