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.
|
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.
|
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.
|
SDataValidation |
This class stores the restrictions on what data can or should be entered in a cell.
|
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.
|
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.
|
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 . |
PasteOption |
This class contains various paste options used for
SSheet.pasteCell(SheetRegion, CellRegion, PasteOption) . |
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.
|
Enum | Description |
---|---|
PasteOption.PasteOperation | |
PasteOption.PasteType | |
SAutoFilter.FilterOp | |
SBorder.BorderType |
The border type
|
SCell.CellType | |
SCellStyle.Alignment |
The horizontal alignment
|
SCellStyle.VerticalAlignment |
The vertical alignment
|
SChart.BarDirection | |
SChart.ChartGrouping | |
SChart.ChartLegendPosition | |
SChart.ChartType | |
SChartAxis.SChartAxisType | |
SDataValidation.AlertStyle | |
SDataValidation.OperatorType | |
SDataValidation.ValidationType | |
SFill.FillPattern |
The fill pattern
|
SFont.Boldweight | |
SFont.TypeOffset | |
SFont.Underline | |
SHyperlink.HyperlinkType | |
SPicture.Format | |
SPrintSetup.PaperSize | |
SSheet.SheetVisible | |
STableColumn.STotalsRowFunction |
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.