Juniper-systems Allegro CX Manual Manuel d'utilisateur télécharger pdf (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)

1 2 ... 167 168 169 170 171 172 173 174 175 176 177 ... 303 304

Pas de commentaire

Juniper-systems Allegro CX Manual Manuel d'utilisateur Page 172