Juniper Systems Allegro CX Manual - Manual (Page 172)

172 Allegro CX Owner’s Manual
CellRefR(dcol , drow, [, sheetIndex ])
Returns the cell reference relative to the current cell.
Example:
Sel(a1)
Sel(CellRefR(1,0))
MsgBox(“the current cell is now B1”)
Sel(CellRefR(0,5))
MsgBox(“the current cell is now B6”)
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.
Default values of parameters: Chart(“Type:Bar”, “”Series:Rows”,
“Legend”, “Xaxis”, “Yaxis”, “Xgrid:No”, “Ygrid:Yes”, “AutoScale”).
Example:
Sel(a1:c20)