String rw backgroundColor
Category ro category
The background color of the receiver in hex format (e.g. blue would be "#0000FF").
GroupOrItem ro cellsOnly
The category to which this object belongs.
int ro childIndex
Gets only the cells from this object (excludes items).
boolean rw collapsed
The index of this object within its parent's child list.
int rw columnWidth
True if this object is collapsed.
boolean rw fontBold
The column width for this selection.
If the selection does not designate a set of columns, this property will return -1 and setting it will have no effect.
String rw fontFace
True if font is bold.
boolean rw fontItalic
The font family name.
float rw fontSize
True if font is italic.
boolean rw fontStrikethrough
The point size of the font.
boolean rw fontUnderline
True if font is strikethrough.
String rw foregroundColor
True if font is underlined.
String rw horizontalAlignment
The foreground color of the receiver in hex format (e.g. blue would be "#0000FF").
String rw name
The horizontal alignment of the receiver - one of "Left", "Right", "Center", or "Automatic".
String rw numberFormatString
The name of this object.
CategoryOrGroup ro parent
Returns the current number format string for this object. May return null for a non-standard format.
int rw rowHeight
The parent of this object.
Object rw value
The row height for this selection.
If the selection does not designate a set of rows, this property will return -1 and setting it will have no effect.
List<Object> ro values
When getting, returns the first value this object contains. When setting, sets all values in this object to the one given.
String rw verticalAlignment
The list of values this object contains.
List<Item> addAfter(Collection<Object> items)
The vertical alignment of the receiver - one of "Top", "Bottom", or "Middle".
List<Item> addAfter(Object... item)
Inserts the contents of
immediately after this one in the current child list. Returns a list of the added items.Parameters:
Inserts the specified items immediately after this one in the current child list. Returns a list of the added items.Parameters:
True if this object can be deleted.
True if this object's name can be set.
True if it is possible to set the number format of this object.
Deletes this object and its children, if any.
Sets this object's number format to accounting.
Sets this object's number format to currency.
Sets this object's number format to percent.
If the object is a Group
GroupOrItemCreateList ro children
SNamedList<Item> ro items
The list of this object's immediate children (not recursive).
The list of all items beneath this object. Does not include groups.
Ungroups the items in this group.
If the object is an Item
int ro itemIndex
The index of this item within its parent's child list.
Copy the item (along with its data) to the clipboard
Remove the item and place it (along with its data) on the clipboard
Paste from the clipboard into the selection for this item. May have different results depending on what's on the clipboard. If nothing valid is on the clipboard, this will have no effect.