Uses of Interface
io.keikai.model.SSheet

Packages that use SSheet

Package	Description
io.keikai.api.model	Keikai Spreadsheet Model API classes.
io.keikai.api.model.impl	Keikai Spreadsheet Model API implementation classes, Internal use only
io.keikai.model	Keikai Spreadsheet Internal Book Model classes.
io.keikai.model.impl	Keikai Spreadsheet Internal Book Model Implementation classes.
io.keikai.model.impl.pdf	The exporter that convert Keikai Spreadsheet to PDF.
io.keikai.model.sys.formula	Keikai Spreadsheet Internal Book Model Engines classes.
io.keikai.range	Keikai Spreadsheet Internal Range API classes.
io.keikai.range.impl	Keikai Spreadsheet Internal Range API Implementation classes.
io.keikai.range.impl.autofill	Keikai Spreadsheet Internal Range API Implementation classes.
io.keikai.range.impl.imexp	Keikai Spreadsheet Internal Range API Implementation classes.
io.keikai.ui	Defines UI Component class of Keikai Spreadsheet
io.keikai.ui.event	Events of Keikai Spreadsheet UI Component.
io.keikai.ui.impl	Classes for implementing Keikai Spreadsheet UI Components (implementation only).
io.keikai.ui.impl.undo	Classes that doing system undoable action control on Keikai Spreadsheet UI Components.
io.keikai.ui.sys	Classes that doing system control on Keikai Spreadsheet UI Components.
io.keikaiex.ui.impl
io.keikaiex.ui.widget	Classes used to implement extended Keikai Spreadsheet UI Component(implementation only).

Uses of SSheet in io.keikai.api.model

Methods in io.keikai.api.model that return SSheet

Modifier and Type	Method	Description
SSheet	Sheet.getInternalSheet()	get the internal model object to do advanced operation Note : operate on internal object will not automatically update Spreadsheet

Uses of SSheet in io.keikai.api.model.impl

Methods in io.keikai.api.model.impl that return SSheet

Modifier and Type	Method	Description
SSheet	SheetImpl.getInternalSheet()
SSheet	SheetImpl.getNative()

Methods in io.keikai.api.model.impl that return types with arguments of type SSheet

Modifier and Type	Method	Description
ModelRef<SSheet>	SheetImpl.getRef()

Methods in io.keikai.api.model.impl with parameters of type SSheet

Modifier and Type	Method	Description
static SheetAnchor	SheetImpl.toSheetAnchor(SSheet sheet, ViewAnchor anchor)	Utility method, internal use only
static ViewAnchor	SheetImpl.toViewAnchor(SSheet sheet, SheetAnchor anchor)	Utility method, internal use only

Constructor parameters in io.keikai.api.model.impl with type arguments of type SSheet

Modifier	Constructor	Description
	ChartImpl(ModelRef<SSheet> sheetRef, ModelRef<SChart> chartRef)
	PictureImpl(ModelRef<SSheet> sheetRef, ModelRef<SPicture> picRef)
	SheetProtectionImpl(ModelRef<SSheet> sheetRef, ModelRef<SSheetProtection> sspRef)

Uses of SSheet in io.keikai.model

Methods in io.keikai.model that return SSheet

Modifier and Type	Method	Description
SSheet	SBook.createSheet(String name)	Create a sheet
SSheet	SBook.createSheet(String name, SSheet src)	Create a sheet and copy the content from the specified src sheet; note the owner book of the specified src sheet can be different from this book.
SSheet	SBook.createSheet(String name, SSheet src, boolean valueOnly)	Create a sheet and copy the content from the specified src sheet; note the owner book of the specified src sheet can be different from this book.
SSheet	ModelEvent.getSheet()
SSheet	SBook.getSheet(int idx)	Get sheet at the index
SSheet	SCell.getSheet()
SSheet	SChart.getSheet()
SSheet	SColumn.getSheet()
SSheet	SColumnArray.getSheet()
SSheet	SConditionalFormatting.getSheet()	The sheet on which this conditional formatting covered
SSheet	SConditionalFormattingRule.getSheet()
SSheet	SDataValidation.getSheet()
SSheet	SheetRegion.getSheet()
SSheet	SPicture.getSheet()
SSheet	SRow.getSheet()
SSheet	SBook.getSheetById(String id)	Get the sheet by id
SSheet	SBook.getSheetByName(String name)	Get the sheet by name

Methods in io.keikai.model that return types with arguments of type SSheet

Modifier and Type	Method	Description
List<SSheet>	SBook.getSheets()	Get all sheets

Methods in io.keikai.model with parameters of type SSheet

Modifier and Type	Method	Description
static ModelEvent	ModelEvents.createModelEvent(String name, SBook book, SSheet sheet, Map data)
static ModelEvent	ModelEvents.createModelEvent(String name, SSheet sheet)
static ModelEvent	ModelEvents.createModelEvent(String name, SSheet sheet, CellRegion region)
static ModelEvent	ModelEvents.createModelEvent(String name, SSheet sheet, CellRegion region, Map data)
static ModelEvent	ModelEvents.createModelEvent(String name, SSheet sheet, Map data)
SSheet	SBook.createSheet(String name, SSheet src)	Create a sheet and copy the content from the specified src sheet; note the owner book of the specified src sheet can be different from this book.
SSheet	SBook.createSheet(String name, SSheet src, boolean valueOnly)	Create a sheet and copy the content from the specified src sheet; note the owner book of the specified src sheet can be different from this book.
void	SBook.deleteSheet(SSheet sheet)	Delete the sheet
ViewAnchor	ViewAnchor.getRightBottomAnchor(SSheet sheet)
int	SBook.getSheetIndex(SSheet sheet)	Get the index of sheet
void	SBook.moveSheetTo(SSheet sheet, int index)	Move the sheet to new position
void	SBook.setSheetName(SSheet sheet, String newname)	Set the sheet to a new name

Constructors in io.keikai.model with parameters of type SSheet

Modifier	Constructor	Description
	PasteSheetRegion(SSheet sheet, int row, int column, int lastRow, int lastColumn, boolean wholeColumn, boolean wholeRow)
	SheetRegion(SSheet sheet, int row, int column)
	SheetRegion(SSheet sheet, int row, int column, int lastRow, int lastColumn)
	SheetRegion(SSheet sheet, CellRegion region)
	SheetRegion(SSheet sheet, String areaReference)

Uses of SSheet in io.keikai.model.impl

Classes in io.keikai.model.impl that implement SSheet

Modifier and Type	Class	Description
class	AbstractSheetAdv

Methods in io.keikai.model.impl that return SSheet

Modifier and Type	Method	Description
SSheet	ChartImpl.getSheet()
SSheet	ConditionalFormattingImpl.getSheet()
SSheet	ConditionalFormattingRuleImpl.getSheet()
SSheet	DataValidationImpl.getSheet()
SSheet	PictureImpl.getSheet()

Constructors in io.keikai.model.impl with parameters of type SSheet

Modifier	Constructor	Description
	ConditionalFormattingImpl(SSheet sheet)
	PasteCellHelper(SSheet destSheet)

Uses of SSheet in io.keikai.model.impl.pdf

Methods in io.keikai.model.impl.pdf with parameters of type SSheet

Modifier and Type	Method	Description
void	PdfExporter.export(SSheet sheet, OutputStream outputStream)	Deprecated. Exports a single sheet as PDF (restores the 6.3 sheet-level overload).
void	RustPdfExporter.export(SSheet sheet, OutputStream fos)	Exports a single sheet (restores the 6.3 sheet-level overload).

Uses of SSheet in io.keikai.model.sys.formula

Methods in io.keikai.model.sys.formula that return SSheet

Modifier and Type	Method	Description
SSheet	FormulaClearContext.getSheet()
SSheet	FormulaEvaluationContext.getSheet()
SSheet	FormulaParseContext.getSheet()

Constructors in io.keikai.model.sys.formula with parameters of type SSheet

Modifier	Constructor	Description
	FormulaClearContext(SSheet sheet)
	FormulaEvaluationContext(SSheet sheet, SCell cell, Ref dependent, int[] offset, boolean externFormula)
	FormulaEvaluationContext(SSheet sheet, Ref dependent)
	FormulaEvaluationContext(SSheet sheet, Ref dependent, int[] offset)
	FormulaParseContext(SBook book, SSheet sheet, SCell cell, String sheetName, Ref dependent)
	FormulaParseContext(SBook book, SSheet sheet, SCell cell, String sheetName, Ref dependent, FormulaType formulaType)
	FormulaParseContext(SBook book, SSheet sheet, SCell cell, String sheetName, Ref dependent, Locale locale, FormulaType formulaType)
	FormulaParseContext(SSheet sheet, Ref dependent)
	FormulaParseContext(SSheet sheet, Ref dependent, FormulaType formulaType)
	FormulaParseContext(SSheet sheet, String sheetName, Ref dependent)
	FormulaParseContext(SSheet sheet, String sheetName, Ref dependent, FormulaType formulaType)

Uses of SSheet in io.keikai.range

Methods in io.keikai.range that return SSheet

Modifier and Type	Method	Description
SSheet	SRange.cloneSheet(String name)	Clone sheet as specified in this Range.
SSheet	SRange.cloneSheetFrom(String name, SSheet sheet)	Clone from the specified source sheet to the owner book of this range.
SSheet	SRange.cloneSheetFrom(String name, SSheet sheet, boolean valueOnly)	Clone from the specified source sheet to the owner book of this range.
SSheet	SRange.createSheet(String name)	Create sheet of this book as specified in this Range.
SSheet	SRange.getSheet()	Returns associate SSheet of this range.

Methods in io.keikai.range with parameters of type SSheet

Modifier and Type	Method	Description
SSheet	SRange.cloneSheetFrom(String name, SSheet sheet)	Clone from the specified source sheet to the owner book of this range.
SSheet	SRange.cloneSheetFrom(String name, SSheet sheet, boolean valueOnly)	Clone from the specified source sheet to the owner book of this range.
static List<String>	SRanges.getNames(SSheet sheet)	Returns a list of the defined names belong to SSheet
static SRange	SRanges.range(SSheet sheet)	Returns the associated SRange of the whole specified SSheet.
static SRange	SRanges.range(SSheet sheet, int row, int col)	Returns the associated SRange of the specified SSheet and cell row and column.
static SRange	SRanges.range(SSheet sheet, int tRow, int lCol, int bRow, int rCol)	Returns the associated XRange of the specified XNSheet and area.
static SRange	SRanges.range(SSheet sheet, CellRegion region)	Returns the associated SRange of the specified SSheet and cell-region
static SRange	SRanges.range(SSheet sheet, String areaReference)	Returns the associated SRange of the specified SSheet and area reference string (e.g.
static SRange	SRanges.rangeByName(SSheet sheet, String name)	Returns the associated SRange of the specified name of a NamedRange (e.g.

Uses of SSheet in io.keikai.range.impl

Fields in io.keikai.range.impl declared as SSheet

Modifier and Type	Field	Description
protected final SSheet	RangeHelperBase.sheet

Methods in io.keikai.range.impl that return SSheet

Modifier and Type	Method	Description
SSheet	RangeImpl.cloneSheet(String name)
SSheet	RangeImpl.cloneSheetFrom(String name, SSheet sheet)
SSheet	RangeImpl.cloneSheetFrom(String name, SSheet sheet, boolean valueOnly)
SSheet	RangeImpl.createSheet(String name)
SSheet	AutoFilterUpdate.getSheet()
SSheet	InsertDeleteUpdate.getSheet()
SSheet	MergeUpdate.getSheet()
SSheet	RangeImpl.getSheet()

Methods in io.keikai.range.impl with parameters of type SSheet

Modifier and Type	Method	Description
void	ModelUpdateCollector.addAutoFilterUpdate(SSheet sheet, STable table)
void	ModelUpdateCollector.addCellUpdate(SSheet sheet, int row, int column, int lastRow, int lastColumn, CellAttribute cellAttr)
void	ModelUpdateCollector.addInsertDeleteUpdate(SSheet sheet, boolean inserted, boolean isRow, int index, int lastIndex)
void	ModelUpdateCollector.addMergeChange(SSheet sheet, CellRegion original, CellRegion changeTo)
static void	AdvancedFilterHelper.applyAdvancedFilter(SSheet sheet, CellRegion dataRange, CellRegion criteriaRange, CellRegion copyToRange, boolean unique, AdvancedFilterAction action)	Applies the advanced filter to the given data range.
static void	SubtotalHelper.applySubtotal(SSheet sheet, CellRegion range, int groupByCol, SubtotalFunction function, int[] totalCols, boolean replace, boolean pageBreak, boolean summaryBelowData)	Applies subtotals to the specified range on the sheet.
SSheet	RangeImpl.cloneSheetFrom(String name, SSheet sheet)
SSheet	RangeImpl.cloneSheetFrom(String name, SSheet sheet, boolean valueOnly)
static Set<String>	InsertDeleteHelper.collectContainedTables(SSheet sheet, int row1, int col1, int row2, int col2)
static void	InsertDeleteHelper.deleteTablesByNames(SSheet sheet, Set<String> toDelete)
CellRegion	FindReplaceHelper.find(SSheet sheet, String searchText, FindOptions options, int startRow, int startCol)	Finds the next cell matching the search text, starting after the given position.
List<CellRegion>	FindReplaceHelper.findAll(SSheet sheet, String searchText, FindOptions options)	Finds all cells matching the search text in the given sheet.
static boolean	DataRegionHelper.isOneCell(SSheet sheet, CellRegion rng)
void	NotifyChangeHelper.notifyChartChange(SSheet sheet, String chartId)
void	NotifyChangeHelper.notifyCustomEvent(String customEventName, SSheet sheet, Object data)
void	NotifyChangeHelper.notifyDataValidationChange(SSheet sheet, String validationId)
void	NotifyChangeHelper.notifyDisplayGridlines(SSheet sheet, boolean show)
void	NotifyChangeHelper.notifyNameNameChange(SSheet sheet, SName name, String oldName)
void	NotifyChangeHelper.notifyProtectSheet(SSheet sheet, boolean protect)
void	NotifyChangeHelper.notifyReleaseSelectedCache(SSheet sheet)
void	NotifyChangeHelper.notifySheetAutoFilterChange(SSheet sheet, STable table)
void	NotifyChangeHelper.notifySheetChartAdd(SSheet sheet, String id)
void	NotifyChangeHelper.notifySheetChartDelete(SSheet sheet, String id)
void	NotifyChangeHelper.notifySheetChartUpdate(SSheet sheet, String id)
void	NotifyChangeHelper.notifySheetCreate(SSheet sheet)
void	NotifyChangeHelper.notifySheetDelete(SBook book, SSheet deletedSheet, int deletedIndex)
void	NotifyChangeHelper.notifySheetFreezeChange(SSheet sheet)
void	NotifyChangeHelper.notifySheetGroupChange(SSheet sheet)
void	NotifyChangeHelper.notifySheetNameChange(SSheet sheet, String oldName)
void	NotifyChangeHelper.notifySheetPictureAdd(SSheet sheet, String id)
void	NotifyChangeHelper.notifySheetPictureDelete(SSheet sheet, String id)
void	NotifyChangeHelper.notifySheetPictureMove(SSheet sheet, String id)
void	NotifyChangeHelper.notifySheetReorder(SSheet sheet, int oldIdx)
void	NotifyChangeHelper.notifySheetSelect(SSheet sheet)
void	NotifyChangeHelper.notifySheetVisibleChange(SSheet sheet)
int	FindReplaceHelper.replace(SSheet sheet, String searchText, String replacement, FindOptions options)	Replaces all occurrences of the search text with the replacement in the given sheet.

Constructors in io.keikai.range.impl with parameters of type SSheet

Modifier	Constructor	Description
	AutoFilterUpdate(SSheet sheet, STable table)
	InsertDeleteUpdate(SSheet sheet, boolean inserted, boolean row, int index, int lastIndex)
	MergeUpdate(SSheet sheet, CellRegion origMerge, CellRegion merge)
	PasteRangeImpl(SSheet sheet, int tRow, int lCol, int bRow, int rCol, boolean wholeRow, boolean wholeColumn)
	RangeImpl(SSheet sheet)
	RangeImpl(SSheet sheet, int row, int col)
	RangeImpl(SSheet sheet, int tRow, int lCol, int bRow, int rCol)
	RangeImpl(SSheet sheet, CellRegion region)

Uses of SSheet in io.keikai.range.impl.autofill

Methods in io.keikai.range.impl.autofill with parameters of type SSheet

Modifier and Type	Method	Description
void	AutoFillHelper.fill(SSheet sheet, CellRegion srcRegion, CellRegion dstRegion, SRange.FillType fillType)	fill the sheet, from srcRef to dstRef
void	AutoFillHelper.fillDown(SSheet sheet, CellRegion srcRef, CellRegion dstRef, SRange.FillType fillType)
void	AutoFillHelper.fillLeft(SSheet sheet, CellRegion srcRef, CellRegion dstRef, SRange.FillType fillType)
void	AutoFillHelper.fillRight(SSheet sheet, CellRegion srcRef, CellRegion dstRef, SRange.FillType fillType)
void	AutoFillHelper.fillUp(SSheet sheet, CellRegion srcRef, CellRegion dstRef, SRange.FillType fillType)

Uses of SSheet in io.keikai.range.impl.imexp

Methods in io.keikai.range.impl.imexp with parameters of type SSheet

Modifier and Type	Method	Description
void	AbstractExporter.export(SSheet sheet, OutputStream fos)

Uses of SSheet in io.keikai.ui

Methods in io.keikai.ui that return SSheet

Modifier and Type	Method	Description
SSheet	Spreadsheet.getSelectedSSheet()	Gets the selected sheet, the default selected sheet is first visible sheet.

Methods in io.keikai.ui with parameters of type SSheet

Modifier and Type	Method	Description
void	Spreadsheet.clearClientCache(SSheet sheet)	Call this method to clear client side cache for a Sheet and fine tune data loading speed.
HeaderPositionHelper	Spreadsheet.getColumnPosition(SSheet sheet)
HeaderPositionHelper	Spreadsheet.getRowPosition(SSheet sheet)
int	Spreadsheet.getSheetMaxVisibleColumns(SSheet sheet)	Returns the max visible columns of the specified sheet
int	Spreadsheet.getSheetMaxVisibleRows(SSheet sheet)	Returns the max visible rows of the specified sheet
void	Spreadsheet.setAutofitColumnWidth(SSheet sheet, int column)	AutoFit a single column width according to its data size.
void	Spreadsheet.setAutofitColumnWidth(SSheet sheet, int fromColumn, int toColumn)	AutoFit multiple columns width according to each one's data size from the fromColumn to the toColumn.
void	Spreadsheet.setSheetMaxVisibleColumns(SSheet sheet, int maxColumns)	Sets the max visibles columns of the specified sheet.
void	Spreadsheet.setSheetMaxVisibleRows(SSheet sheet, int maxRows)	Sets the max visible rows of the specified sheet

Uses of SSheet in io.keikai.ui.event

Methods in io.keikai.ui.event that return SSheet

Modifier and Type	Method	Description
SSheet	HeaderMouseEvent.getSheet()	get Sheet
SSheet	HeaderUpdateEvent.getSheet()	get Sheet

Constructors in io.keikai.ui.event with parameters of type SSheet

Modifier	Constructor	Description
	HeaderMouseEvent(String name, org.zkoss.zk.ui.Component target, int x, int y, int keys, SSheet sheet, HeaderType type, int index, int clientx, int clienty)
	HeaderUpdateEvent(String name, org.zkoss.zk.ui.Component target, SSheet sheet, HeaderType type, HeaderAction acton, int index, int size, boolean hidden)

Uses of SSheet in io.keikai.ui.impl

Methods in io.keikai.ui.impl that return types with arguments of type SSheet

Modifier and Type	Method	Description
Iterator<SSheet>	ActiveRangeHelper.sheetIterator()

Methods in io.keikai.ui.impl with parameters of type SSheet

Modifier and Type	Method	Description
boolean	ActiveRangeHelper.contains(SSheet sheet, int row, int col)
boolean	ActiveRangeHelper.contains(SSheet sheet, int tRow, int lCol, int bRow, int rCol)
boolean	ActiveRangeHelper.containsSheet(SSheet sheet)
AreaRef	ActiveRangeHelper.getArea(SSheet sheet)
static String	CellFormatHelper.getCellHtmlText(SSheet sheet, int row, int column)	Gets Cell text by given row and column
static String	CellFormatHelper.getCellHtmlText(SSheet sheet, int row, int column, FormatResult ft, SCellStyle tbStyle, SConditionalStyle cdStyle)	Gets Cell text by given row and column
String	SimpleCellDisplayLoader.getCellHtmlText(SSheet sheet, int row, int column)
String	SimpleCellDisplayLoader.getCellHtmlText(SSheet sheet, int row, int column, FormatResult ft, SCellStyle tbStyle, SConditionalStyle cdStyle)
static String	CellFormatHelper.getFontHtmlStyle(SSheet sheet, SCell cell, SCellStyle cellStyle, FormatResult ft, SCellStyle tbCellStyle, SConditionalStyle cdStyle)
static String	CellFormatHelper.getRichCellHtmlText(SSheet sheet, int row, int column)	Gets Cell text by given row and column, it handling
static String	CellFormatHelper.getRichCellHtmlText(SSheet sheet, int row, int column, FormatResult ft, SCellStyle tbStyle, SConditionalStyle cdStyle)	Gets Cell text by given row and column, it handling
static String	CellFormatHelper.getRichTextEditCellHtml(SSheet sheet, int row, int column)
void	VoidWidgetHandler.onLoadOnDemand(SSheet sheet, int left, int top, int right, int bottom)
AreaRef	ActiveRangeHelper.removeActiveRange(SSheet sheet)
void	ActiveRangeHelper.setActiveRange(SSheet sheet, int tRow, int lCol, int bRow, int rCol)
void	ActiveRangeHelper.setActiveRange(SSheet sheet, int tRow, int lCol, int bRow, int rCol, boolean clearFirst)
void	VoidWidgetHandler.updateWidget(SSheet sheet, String widgetId)
void	VoidWidgetHandler.updateWidgets(SSheet sheet, int left, int top, int right, int bottom)

Constructors in io.keikai.ui.impl with parameters of type SSheet

Modifier	Constructor	Description
	CellFormatHelper(SSheet sheet, int row, int col, MergeMatrixHelper mmhelper, SConditionalStyle cdStyle)

Uses of SSheet in io.keikai.ui.impl.undo

Methods in io.keikai.ui.impl.undo that return SSheet

Modifier and Type	Method	Description
SSheet	ReserveUtil.ReservedResult.getSheet()

Methods in io.keikai.ui.impl.undo with parameters of type SSheet

Modifier and Type	Method	Description
static ReserveUtil.ReservedResult	ReserveUtil.reserve(SSheet sheet, int row, int column, int lastRow, int lastColumn, int reserveType)
static CellRegion[]	ReserveUtil.reserveMergeInfo(SSheet sheet, int row, int column, int lastRow, int lastColumn)	reserve the merge information that in the given range.

Constructors in io.keikai.ui.impl.undo with parameters of type SSheet

Modifier	Constructor	Description
	ReservedResult(SSheet sheet, int row, int column, int lastRow, int lastColumn, int reserveType)

Uses of SSheet in io.keikai.ui.sys

Methods in io.keikai.ui.sys with parameters of type SSheet

Modifier and Type	Method	Description
void	WidgetLoader.addChartWidget(SSheet sheet, SChart chart)	call when spreadsheet try to load a block of cell to client side.
void	SpreadsheetOutCtrl.addMergeCell(SSheet sheet, int left, int top, int right, int bottom)
void	WidgetLoader.addPictureWidget(SSheet sheet, SPicture picture)
void	WidgetLoader.deleteChartWidget(SSheet sheet, String chartId)
void	SpreadsheetOutCtrl.deleteMergeCell(SSheet sheet, int left, int top, int right, int bottom)
void	WidgetLoader.deletePictureWidget(SSheet sheet, String pictureId)
org.zkoss.json.JSONObject	SpreadsheetCtrl.getCellAttr(SSheet sheet, SpreadsheetCtrl.CellAttribute type, int row, int col, StringAggregation styleAggregation, StringAggregation textAggregation, MergeAggregation mergeAggregation)	Return Cell attributes r: row number c: column number t: cell html text et: cell edit text ft: format text meft: merge cell html text, edit text and format text ct: cell type s: cell style is: cell inner style rb: cell right border l: locked</> wp: wrap ha: horizontal alignment</> va: vertical alignment</> mi: merge id index mc: merge CSS index fs: font size fn: font name ovf: overflow Ignore put attribute if it's default Default attributes Cell type: blank</> Locked: true</> Wrap: false Horizontal alignment: left</> Vertical alignment: top</> Overflow: false Font size: 11pt</>
String	CellDisplayLoader.getCellHtmlText(SSheet sheet, int row, int column)	return the html text for this cell
String	CellDisplayLoader.getCellHtmlText(SSheet sheet, int row, int column, FormatResult ft, SCellStyle tbStyle, SConditionalStyle cdStyle)
org.zkoss.json.JSONObject	SpreadsheetCtrl.getColumnHeaderAttrs(SSheet sheet, int colStart, int colEnd)
MergeMatrixHelper	SpreadsheetCtrl.getMergeMatrixHelper(SSheet sheet)
org.zkoss.json.JSONObject	SpreadsheetCtrl.getRangeAttrs(SSheet sheet, SpreadsheetCtrl.Header containsHeader, SpreadsheetCtrl.CellAttribute type, int left, int top, int right, int bottom)
org.zkoss.json.JSONObject	SpreadsheetCtrl.getRowHeaderAttrs(SSheet sheet, int rowStart, int rowEnd)
void	SpreadsheetOutCtrl.insertColumns(SSheet sheet, int col, int size)
void	SpreadsheetOutCtrl.insertRows(SSheet sheet, int row, int size)
void	WidgetLoader.onColumnChange(SSheet sheet, int left, int right)
void	WidgetHandler.onLoadOnDemand(SSheet sheet, int left, int top, int right, int bottom)	call when spreadsheet try to load a block of cell to client side.
void	WidgetLoader.onResetSparklineAnchor(SSheet sheet, CellRegion region)
void	WidgetLoader.onRowChange(SSheet sheet, int top, int bottom)
void	WidgetLoader.onRowColumnChange(SSheet sheet, CellRegion region)
void	WidgetLoader.onSheetClean(SSheet sheet)	indicate the sheet is dis-selected
void	WidgetLoader.onSheetFreeze(SSheet sheet)	indicate the sheet's freeze panel is changed.
void	WidgetLoader.onSheetSelected(SSheet sheet)	indicate the selected sheet of a spreadsheet is changed.
void	SpreadsheetOutCtrl.removeColumns(SSheet sheet, int col, int size)
void	SpreadsheetOutCtrl.removeRows(SSheet sheet, int row, int size)
void	SpreadsheetOutCtrl.setColumnWidth(SSheet sheet, int col, int width, int id, boolean hidden)
void	SpreadsheetOutCtrl.setRowHeight(SSheet sheet, int row, int height, int id, boolean hidden, boolean isCustom)
void	WidgetLoader.updateChartWidget(SSheet sheet, SChart chart)
void	SpreadsheetOutCtrl.updateMergeCell(SSheet sheet, int left, int top, int right, int bottom, int oleft, int otop, int oright, int obottom)
void	WidgetLoader.updatePictureWidget(SSheet sheet, SPicture picture)
void	WidgetHandler.updateWidget(SSheet sheet, String widgetId)	Redraw widget

Uses of SSheet in io.keikaiex.ui.impl

Methods in io.keikaiex.ui.impl with parameters of type SSheet

Modifier and Type	Method	Description
String	CellDisplayLoaderImpl.getCellHtmlText(SSheet sheet, int row, int column)
String	CellDisplayLoaderImpl.getCellHtmlText(SSheet sheet, int row, int column, FormatResult ft, SCellStyle tbStyle, SConditionalStyle cdStyle)

Uses of SSheet in io.keikaiex.ui.widget

Methods in io.keikaiex.ui.widget with parameters of type SSheet

Modifier and Type	Method	Description
void	DefaultBookWidgetLoader.addChartWidget(SSheet sheet, SChart chart)
void	DefaultBookWidgetLoader.addPictureWidget(SSheet sheet, SPicture picture)
void	DefaultBookWidgetLoader.deleteChartWidget(SSheet sheet, String chartId)
void	DefaultBookWidgetLoader.deletePictureWidget(SSheet sheet, String pictureId)
protected Widget	DefaultBookWidgetLoader.newChartWidget(SSheet sheet, SChart chart, String panel, int zindex)
protected List<Widget>	DefaultBookWidgetLoader.newChartWidgetGroup(SSheet sheet, SChart chart, int zindex)
protected Widget	DefaultBookWidgetLoader.newImageWidget(SSheet sheet, SPicture picture, org.zkoss.image.Image image, String panel, int zindex)
protected List<Widget>	DefaultBookWidgetLoader.newImageWidgetGroup(SSheet sheet, SPicture picture, int zindex)
void	DefaultBookWidgetLoader.onColumnChange(SSheet sheet, int left, int right)
void	DefaultWidgetHandler.onLoadOnDemand(SSheet sheet, int left, int top, int right, int bottom)
void	DefaultBookWidgetLoader.onResetSparklineAnchor(SSheet sheet, CellRegion region)
void	DefaultBookWidgetLoader.onRowChange(SSheet sheet, int top, int bottom)
void	DefaultBookWidgetLoader.onRowColumnChange(SSheet sheet, CellRegion region)
void	DefaultBookWidgetLoader.onSheetClean(SSheet sheet)
void	DefaultBookWidgetLoader.onSheetFreeze(SSheet sheet)
void	DefaultBookWidgetLoader.onSheetSelected(SSheet sheet)
void	DefaultBookWidgetLoader.updateChartWidget(SSheet sheet, SChart chart)
void	DefaultBookWidgetLoader.updatePictureWidget(SSheet sheet, SPicture picture)
void	DefaultWidgetHandler.updateWidget(SSheet sheet, String widgetId)

Constructors in io.keikaiex.ui.widget with parameters of type SSheet

Modifier	Constructor	Description
	ChartsWidget(SSheet sheet, SChart chartInfo, String panel, int zindex)
	ImageWidget(SSheet sheet, SPicture pic, String panel)