Juniper Systems Allegro CX Manual - Manual (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
specifi ed) or in the specifi ed row.
Example:
last = LastCol()
last = LastCol(15)
LastRow([columnNumber])
Returns the last nonblank cell in the whole sheet (if columnNumber is
not specifi ed) or in the specifi 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”)