| Interface | Description |
|---|---|
| CellStyleHolder |
the style holder interface
|
| EventQueueModelEventListener |
A model event listener that listen model event through event queue (not from model directly).
|
| FormulaContent |
Indicate that the object has formula content
|
| ModelEventListener |
A listener to handle
ModelEvent. |
| SAutoFilter |
Contains autofilter's setting.
|
| SAutoFilter.NFilterColumn |
A filter column contains information for filtering, e.g. criteria.
|
| SBook |
The root of Spreadsheet's data model which contains sheets.
|
| SBookSeries |
It contains multiple
SBook objects so that formulas in them can reference to cells of another book. |
| SBorder |
Border object
|
| SBorderLine | |
| SCell |
Represent a cell of a sheet in a Spreadsheet.
|
| SCellStyle |
Represent style information e.g. alignment, border, format pattern, font, color, fill pattern, wrap text, and hidden status.
|
| SCFValueObject |
Conditional Formatting value object.
|
| SChart |
Represents a chart in a sheet.
|
| SChartAxis |
Represent an axis in
SChart. |
| SColor |
A color which might relate to a text or a border.
|
| SColorFilter |
Color filter
|
| SColorScale | |
| SColumn |
A column of a sheet.
|
| SColumnArray |
It stores first and last column index of a group of column that has same width and cell style.
|
| SComment |
A comment is some texts written by a user which is separated from text of a cell.
|
| SConditionalFormatting |
Conditional Formatting
|
| SConditionalFormattingRule | |
| SConditionalStyle |
Extra embedded style for SConditonalFormatting.
|
| SCustomFilter | |
| SCustomFilters | |
| SDataBar |
Condiditional Formatting of "dataBar" type.
|
| SDataValidation |
This class stores the restrictions on what data can or should be entered in a cell.
|
| SDynamicFilter | |
| SExtraStyle |
Extra embedded style for STable and SConditonalFormatting.
|
| SFill |
Fill pattern and colors
|
| SFont |
Represents a font used in cells.
|
| SFooter |
The text in the footer.
|
| SHeader |
The text in the header.
|
| SHyperlink |
A hyperlink of a cell.
|
| SIconSet | |
| SName |
A named range (or defined name) which refer to a region.
|
| SNamedStyle |
Cell Style referred via a name.
|
| SPicture |
A picture in a sheet.
|
| SPictureData |
Picture data in a picture.
|
| SPrintSetup |
Store various setting for printing.
|
| SRichText |
A rich text can have multiple segments which have different fonts for
each one in a cell.
|
| SRichText.Segment | |
| SRow |
A row of a sheet.
|
| SSheet |
A sheet of a book.
|
| SSheetProtection | |
| SSheetViewInfo |
Store those visual statuses of a sheet, e.g. freeze status of row (column), or grid-line display.
|
| STable |
Table
|
| STableColumn |
Table column
|
| STableStyle |
Table Style.
|
| STableStyleElem |
Table style element.
|
| STableStyleInfo |
Table style info.
|
| STop10Filter |
| Class | Description |
|---|---|
| CellRegion |
An immutable object that represents a block of cells with 4 indexes which are first and last row index, first and last column index.
|
| ErrorValue |
An error result of a evaluated formula.
|
| ModelEvent |
The event will be sent when there is an operation performed on a book model.
|
| ModelEvents |
A collection of factory method that help you create
ModelEvent. |
| PasteCellRegion | |
| PasteOption |
This class contains various paste options used for
SSheet.pasteCell(SheetRegion, CellRegion, PasteOption). |
| PasteSheetRegion | |
| SBooks |
Contains factory methods to create a
SBook. |
| SBookSeriesBuilder |
A utility class that build a book series that allow external book references can work.
|
| SheetRegion |
Indicates a immutable region of cells in a sheet.
|
| ViewAnchor |
Represent a anchor position by its left-top cell index, width, height, x and y offset within the cell,
or a right-bottom anchor position by its right-bottom cell index with 0 width and height.
|
| Exception | Description |
|---|---|
| InvalidDataValidationException |
The exception is thrown when encountering invalid parameters.
|
| InvalidFormulaException |
The exception is thrown when encountering an invalid formula.
|
| InvalidModelOpException |
This exception is thrown when you perform an unreasonable operation on the model.
|
ZK Spreadsheet Internal Book Model classes.
Copyright © 2005-2010 Potix Corporation. All Rights Reserved.