Juniper-systems Allegro CX Manual Manuel d'utilisateur télécharger pdf (Page 176)

176 Allegro CX Owner’s Manual

InsertCells(colsRows)

Inserts cells (true - columns, false - rows).

Example:

InsertCells(false)

InsertSheet( worksheet)

Inserts new worksheet.

Example:

InsertSheet(“Cars”)

LastCol([rowNumber] )

Returns the last nonblank cell in the whole sheet (if rowNumber is not

speciﬁ ed) or in the speciﬁ ed row.

Example:

last = LastCol()

last = LastCol(15)

LastRow([columnNumber])

Returns the last nonblank cell in the whole sheet (if columnNumber is

not speciﬁ ed) or in the speciﬁ ed column.

Example:

last = LastRow()

last = LastRow(15)

ListBox(title, range)

Shows list box dialog with items from range and with the title and

returns the index of the selected item or its value (if retValue is

TRUE).

Example:

med = ListBox(“Choose medicine”, Medicines!a1:a50, TRUE)

ListBox2(title, item, item2, item3... item29)

Shows list box dialog with items: item1, item2, item3... and with the

title and returns the text of the selected item.

Example:

car = ListBox(“Choose car”, “BMW”, “Jaguar”, “Ferrari”)

1 2 ... 171 172 173 174 175 176 177 178 179 180 181 ... 303 304

Pas de commentaire

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