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.importer
io.keikai.model	Keikai Spreadsheet Internal Book Model classes.
io.keikai.model.impl	Keikai Spreadsheet Internal Book Model Implementation classes.
io.keikai.model.impl.html	The exporter that convert Keikai Spreadsheet to HTML.
io.keikai.model.impl.pdf	The exporter that convert Keikai Spreadsheet to PDF.
io.keikai.model.impl.sys.formula	Keikai Spreadsheet Internal Book Model Implementation classes.
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 and 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 and 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 and Description
ModelRef<SSheet>	SheetImpl.getRef()

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

Modifier and Type	Method and 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

Constructor and Description
ChartImpl(ModelRef<SSheet> sheetRef, ModelRef<SChart> chartRef)
PictureImpl(ModelRef<SSheet> sheetRef, ModelRef<SPicture> picRef)
SheetImpl(ModelRef<SBook> book, ModelRef<SSheet> sheet)
SheetProtectionImpl(ModelRef<SSheet> sheetRef, ModelRef<SSheetProtection> sspRef)

Uses of SSheet in io.keikai.importer

Methods in io.keikai.importer that return SSheet

Modifier and Type	Method and Description
protected SSheet	XlsxImporter.importSheet(XlsxExtractor.XlsxSheetExtractor xSheet)

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

Modifier and Type	Method and Description
protected int	XlsxImporter.getAnchorHeightInPx(io.keikai.importer.ShapeJson shapeJson, SSheet sheet) DefaultBookWidgetLoader.getXSSFHeightInPx()
protected int	XlsxImporter.getAnchorWidthInPx(io.keikai.importer.ShapeJson shapeJson, SSheet sheet) Reference DefaultBookWidgetLoader.getXSSFWidthInPx()
protected void	XlsxImporter.importAutoFilter(XlsxExtractor.XlsxSheetExtractor xSheet, SSheet sheet)
protected SCell	XlsxImporter.importCell(XlsxExtractor.XlsxCellExtractor xCell, int row, SSheet sheet)
protected void	XlsxImporter.importChart(io.keikai.importer.ChartSpaceJson chartSpaceJson, XlsxExtractor.XlsxSheetExtractor xSheet, SSheet sheet) Not import X & Y axis title because XSSFCategoryAxis doesn't provide API to get title.
protected void	XlsxImporter.importColumn(XlsxExtractor.XlsxSheetExtractor xSheet, SSheet sheet) [ISO/IEC 29500-1 1st Edition] 18.3.1.13 col (Column Width & Formatting) By experiments, CT_Col is always created in ascending order by min and the range specified by min & max doesn't overlap each other. For example:
protected void	XlsxImporter.importConditionalFormatting(XlsxExtractor.XlsxSheetExtractor xSheet, SSheet sheet)
protected void	XlsxImporter.importDrawings(XlsxExtractor.XlsxSheetExtractor xSheet, SSheet sheet)
protected void	XlsxImporter.importMergedRegions(XlsxExtractor.XlsxSheetExtractor xSheet, SSheet sheet)
protected void	XlsxImporter.importPassword(XlsxExtractor.XlsxSheetProtectionExtractor protectionExtractor, SSheet sheet)
protected void	XlsxImporter.importPicture(io.keikai.importer.PictureJson pictureJson, XlsxExtractor.XlsxSheetExtractor xSheet, SSheet sheet)
protected void	XlsxImporter.importPrintArea(XlsxExtractor.XlsxSheetExtractor xSheet, SSheet sheet)
protected SRow	XlsxImporter.importRow(XlsxExtractor.XlsxRowExtractor xRow, SSheet sheet)
protected void	XlsxImporter.importSheetProtection(XlsxExtractor.XlsxSheetExtractor xSheet, SSheet sheet)
protected void	XlsxImporter.importTables(XlsxExtractor.XlsxSheetExtractor xSheet, SSheet sheet)
protected void	XlsxImporter.importValidation(XlsxExtractor.XlsxSheetExtractor xSheet, SSheet sheet) Reference BookHelper.validate()
protected ConditionalFormattingImpl	XlsxImporter.prepareConditionalFormattingImpl(SSheet sheet, XlsxExtractor.XlsxConditionalFormattingExtractor cf)
protected ViewAnchor	XlsxImporter.toViewAnchor(io.keikai.importer.ShapeJson shapeJson, SSheet sheet)

Uses of SSheet in io.keikai.model

Methods in io.keikai.model that return SSheet

Modifier and Type	Method and 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	SheetRegion.getSheet()
SSheet	SRow.getSheet()
SSheet	SPicture.getSheet()
SSheet	SDataValidation.getSheet()
SSheet	SConditionalFormattingRule.getSheet()
SSheet	SConditionalFormatting.getSheet() The sheet on which this conditional formatting covered
SSheet	SColumnArray.getSheet()
SSheet	SColumn.getSheet()
SSheet	SChart.getSheet()
SSheet	SCell.getSheet()
SSheet	ModelEvent.getSheet()
SSheet	SBook.getSheet(int idx) Get sheet at the index
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 and Description
List<SSheet>	SBook.getSheets() Get all sheets

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

Modifier and Type	Method and 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.
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

Constructor and Description
PasteSheetRegion(SSheet sheet, int row, int column, int lastRow, int lastColumn, boolean wholeColumn) Deprecated.
PasteSheetRegion(SSheet sheet, int row, int column, int lastRow, int lastColumn, boolean wholeColumn, boolean wholeRow)
SheetRegion(SSheet sheet, CellRegion region)
SheetRegion(SSheet sheet, int row, int column)
SheetRegion(SSheet sheet, int row, int column, int lastRow, int lastColumn)
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 and Description
class	AbstractSheetAdv
class	SheetImpl

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

Modifier and Type	Method and Description
SSheet	BookImpl.createSheet(String name)
SSheet	BookImpl.createSheet(String name, SSheet src)
SSheet	RowImpl.getSheet()
SSheet	PictureImpl.getSheet()
SSheet	DataValidationImpl.getSheet()
SSheet	ConditionalFormattingRuleImpl.getSheet()
SSheet	ConditionalFormattingImpl.getSheet()
SSheet	ColumnArrayImpl.getSheet()
SSheet	ChartImpl.getSheet()
SSheet	CellImpl.getSheet()
SSheet	BookImpl.getSheet(int i)
SSheet	BookImpl.getSheetById(String id)
SSheet	BookImpl.getSheetByName(String name)

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

Modifier and Type	Method and Description
List<SSheet>	BookImpl.getSheets()

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

Modifier and Type	Method and Description
protected void	BookImpl.checkOwnership(SSheet sheet)
SSheet	BookImpl.createSheet(String name, SSheet src)
void	BookImpl.deleteSheet(SSheet sheet)
int	BookImpl.getSheetIndex(SSheet sheet)
void	BookImpl.moveSheetTo(SSheet sheet, int index)
void	BookImpl.setSheetName(SSheet sheet, String newname)

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

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

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

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

Modifier and Type	Method and Description
static ToHtml	ToHtml.create(SSheet ws, OutputStream output)
static void	ToHtml.export(SSheet ws, CellRegion area, OutputStream outputStream)
static void	ToHtml.export(SSheet ws, CellRegion area, OutputStream outputStream, boolean noHeader)
static void	ToHtml.export(SSheet ws, OutputStream outputStream)
void	HtmlExporter.export(SSheet worksheet, OutputStream outputStream) Exports Keikai Spreadsheet SSheet into another format written to a
static void	ToHtml.export(SSheet ws, OutputStream outputStream, boolean noHeader)
void	ToHtml.printSheet(SSheet sheet)

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

Fields in io.keikai.model.impl.pdf declared as SSheet

Modifier and Type	Field and Description
protected SSheet	PdfExporter._currentSheet

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

Modifier and Type	Method and Description
protected com.lowagie.text.pdf.PdfPCell	PdfExporter.createEmptyRowSpanCell(SSheet sheet, CellRegion outlineRegion, double rowHeight, CellRegion renderRegion, int rowIdx, int colIdx, boolean printOutline, boolean printGridline)
protected com.lowagie.text.pdf.PdfPCell	PdfExporter.createPdfCell(CellRegion clipRegion, CellRegion renderRegion, SCell zssCell, CellRegion outlineRegion, SSheet sheet, boolean printGridLines, boolean printOutline, boolean extended) creates a PdfCell from POI Cell
protected com.lowagie.text.pdf.PdfPTable	PdfExporter.createPdfTable(int bCol, int eCol, SSheet sheet)
void	PdfExporter.export(SSheet worksheet, OutputStream outputStream) Exports Keikai Spreadsheet SSheet into another format written to a
protected void	PdfExporter.exportSheet(SSheet sheet, int sheetIndex, com.lowagie.text.Document doc) converts POI SSheet to Pdf page(s)
protected void	PdfExporter.exportSheetSelection(SSheet sheet, int sheetIndex, CellRegion area, com.lowagie.text.Document doc) converts POI SSheet to Pdf page(s)
protected int	PdfExporter.getAcrossSelectionColumn0(SSheet sheet, int rowIdx, int colIdx)
protected SFooter	PdfExporter.getCurrentFooter(SSheet sheet)
protected SHeader	PdfExporter.getCurrentHeader(SSheet sheet)
protected SPrintSetup	PdfExporter.getCurrentPrintSetup(SSheet sheet)
protected int	PdfExporter.getExtendedEndColumn(SSheet sheet, SCell zssCell, int colIdx)
protected int	PdfExporter.getExtendedEndColumn0(SSheet sheet, SCell zssCell, int colIdx)
protected CellRegion	PdfExporter.getMergedRegionIfAny(SSheet sheet, int rowIdx, int colIdx) returns merged region cell range for a given cell
protected void	PdfExporter.getPictureData(SSheet sheet) retrieve all zkpictures for given sheet
protected CellRegion[]	PdfExporter.getPrintAreas(SPrintSetup ps, SSheet sheet)
protected void	PdfExporter.initDocument(SSheet sheet, com.lowagie.text.Document doc) Set pdf page common properties such as margins and document standard font
protected void	PdfExporter.initDocumentForSheet(SSheet sheet, com.lowagie.text.Document doc)
protected void	PdfExporter.initPrintArea(SSheet sheet, CellRegion region) sets the column bounds for passed SSheet
protected void	PdfExporter.initRowColumnPositions(SSheet sheet)
protected void	PdfExporter.initSelectedPrintArea(SSheet sheet)
protected void	PdfExporter.initSheetPrintSetup(SSheet sheet)
protected boolean	PdfExporter.isPartOfMergedRegion(SSheet sheet, SCell cell) checks if POI Cell is part of any merged regions on the passed SSheet
protected void	PdfExporter.layoutCharts(SSheet sheet, int bRow, int eRow, int bCol, int eCol, com.lowagie.text.pdf.PdfWriter writer)
protected void	PdfExporter.layoverPictureIfAny(SSheet sheet, int bRow, int eRow, int bCol, int eCol, com.lowagie.text.pdf.PdfWriter writer) lays images over PdfTable
protected void	PdfExporter.prepareColBreaks(SSheet sheet, boolean ignoreManualBreaks)
protected int	PdfExporter.prepareFitPageScale(SSheet sheet, int fitWidth, int fitHeight)
protected double[]	PdfExporter.preparePageXYInfo(SSheet sheet, int bRow, int eRow, int bCol, int eCol)
protected void	PdfExporter.prepareRowBreaks(SSheet sheet, boolean ignoreManualBreaks) Sets column/row breaks if not defined already
protected int	PdfExporter.prepareScaleX(SSheet sheet, int fitWidth)
protected int	PdfExporter.prepareScaleY(SSheet sheet, int fitHeight)
protected int	PdfExporter.printCell(com.lowagie.text.pdf.PdfPTable pdfTable, int rowIdx, int colIdx, SSheet sheet, double rowHeight, int bRow, int eRow, int bCol, int eCol, CellRegion outlineRegion)
protected void	PdfExporter.printPage(int bRow, int eRow, int bCol, int eCol, SSheet sheet, com.lowagie.text.Document doc)
protected void	PdfExporter.printRow(com.lowagie.text.pdf.PdfPTable pdfTable, int rowIdx, int bRow, int eRow, int bCol, int eCol, SSheet sheet, float rowHeight, CellRegion outlineRegion)
protected void	PdfExporter.printScaleSheet(SSheet sheet, com.lowagie.text.Document doc, SPrintSetup ps)
protected void	PdfExporter.printSheet(SSheet sheet, com.lowagie.text.Document doc)
protected int	PdfExporter.searchNonBlankEndColumn(SSheet sheet, int rowIdx, int lastColIdx) Returns the last cell that contains value
protected void	PdfExporter.setupColumnBreaks(SSheet sheet) sets auto column breaks based on column width and available page width
protected com.lowagie.text.Document	PdfExporter.setupExporter(SSheet sheet, OutputStream outputStream, com.lowagie.text.Document document)
protected void	PdfExporter.setupRowBreaks(SSheet sheet) sets auto row breaks based on row heights and available total page height

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

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

Modifier and Type	Method and Description
SSheet	EvalSheet.getNSheet()

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

Constructor and Description
EvalSheet(SSheet sheet)

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

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

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

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

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

Uses of SSheet in io.keikai.range

Methods in io.keikai.range that return SSheet

Modifier and Type	Method and 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.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 and Description
SSheet	SRange.cloneSheetFrom(String name, SSheet sheet) Clone from the specified source sheet to the owner book of this range.
void	SExporter.export(SSheet sheet, OutputStream fos) Deprecated.
static SRange	SRanges.range(SSheet sheet) Returns the associated SRange of the whole specified SSheet.
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, 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, 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 and Description
protected SSheet	RangeHelperBase.sheet

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

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

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

Modifier and Type	Method and Description
void	ModelUpdateCollector.addAutoFilterUpdate(SSheet sheet, STable table)
void	ModelUpdateCollector.addCellUpdate(SSheet sheet, int row, int column, int lastRow, int lastColumn) Deprecated.
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)
SSheet	RangeImpl.cloneSheetFrom(String name, SSheet sheet)
static Set<String>	InsertDeleteHelper.collectContainedTables(SSheet sheet, int row1, int col1, int row2, int col2)
static void	InsertDeleteHelper.deleteTablesByNames(SSheet sheet, Set<String> toDelete)
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.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.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.notifySheetVisibleChange(SSheet sheet)

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

Constructor and 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, CellRegion region)
RangeImpl(SSheet sheet, int row, int col)
RangeImpl(SSheet sheet, int tRow, int lCol, int bRow, int rCol)

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 and 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 that return SSheet

Modifier and Type	Method and Description
protected SSheet	AbstractExcelImporter.importSheet(Sheet poiSheet, int poiSheetIndex)

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

Modifier and Type	Method and Description
protected void	ExcelXlsxExporter.addPoiRule(SSheet sheet, org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCfRule ctRule, SConditionalFormattingRule rule, int priority)
void	AbstractExporter.export(SSheet sheet, OutputStream fos)
protected void	ExcelXlsxExporter.exportAutoFilter(SSheet sheet, Sheet poiSheet) See Javadoc at AbstractExcelImporter importAutoFilter().
protected void	ExcelXlsExporter.exportAutoFilter(SSheet sheet, Sheet poiSheet)
protected abstract void	AbstractExcelExporter.exportAutoFilter(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsxExporter.exportChart(SSheet sheet, Sheet poiSheet) reference DrawingManagerImpl.addChartX()
protected void	ExcelXlsExporter.exportChart(SSheet sheet, Sheet poiSheet)
protected abstract void	AbstractExcelExporter.exportChart(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsxExporter.exportColumnArray(SSheet sheet, Sheet poiSheet, SColumnArray columnArr)
protected void	ExcelXlsExporter.exportColumnArray(SSheet sheet, Sheet poiSheet, SColumnArray columnArr)
protected abstract void	AbstractExcelExporter.exportColumnArray(SSheet sheet, Sheet poiSheet, SColumnArray columnArr)
protected void	ExcelXlsxExporter.exportConditionalFormatting(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsExporter.exportConditionalFormatting(SSheet sheet, Sheet poiSheet)
protected abstract void	AbstractExcelExporter.exportConditionalFormatting(SSheet sheet, Sheet poiSheet)
protected void	AbstractExcelExporter.exportMergedRegions(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsxExporter.exportPassword(SSheet sheet, Sheet poiSheet) Export hashed password directly to poiSheet.
protected void	ExcelXlsExporter.exportPassword(SSheet sheet, Sheet poiSheet) Export hashed password directly to poiSheet.
protected abstract void	AbstractExcelExporter.exportPassword(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsxExporter.exportPicture(SSheet sheet, Sheet poiSheet) Reference DrawingManagerImpl.addPicture()
protected void	ExcelXlsExporter.exportPicture(SSheet sheet, Sheet poiSheet)
protected abstract void	AbstractExcelExporter.exportPicture(SSheet sheet, Sheet poiSheet)
protected void	AbstractExcelExporter.exportRow(SSheet sheet, Sheet poiSheet, SRow row)
protected void	AbstractExcelExporter.exportRowColumn(SSheet sheet, Sheet poiSheet)
protected void	AbstractExcelExporter.exportSheet(SSheet sheet)
protected void	AbstractExcelExporter.exportSheetProtection(SSheet sheet, Sheet poiSheet) POI SheetProtection.
protected int	ExcelXlsxExporter.exportTables(SSheet sheet, Sheet poiSheet0, int tbId)
protected int	ExcelXlsExporter.exportTables(SSheet sheet, Sheet poiSheet, int tbId)
protected abstract int	AbstractExcelExporter.exportTables(SSheet sheet, Sheet poiSheet, int tbId)
protected void	ExcelXlsxExporter.exportValidation(SSheet sheet, Sheet poiSheet) According to SDataValidation.ValidationType, FORMULA means custom validation.
protected void	ExcelXlsExporter.exportValidation(SSheet sheet, Sheet poiSheet)
protected abstract void	AbstractExcelExporter.exportValidation(SSheet sheet, Sheet poiSheet)
protected void	AbstractExcelImporter.importAutoFilter(Sheet poiSheet, SSheet sheet) POI AutoFilter.getFilterColumn(i) sometimes returns null.
protected SCell	AbstractExcelImporter.importCell(Cell poiCell, int row, SSheet sheet)
protected void	ExcelXlsxImporter.importChart(List<ZssChartX> poiCharts, Sheet poiSheet, SSheet sheet) Not import X & Y axis title because XSSFCategoryAxis doesn't provide API to get title.
protected void	ExcelXlsImporter.importChart(List<ZssChartX> poiCharts, Sheet poiSheet, SSheet sheet)
protected void	ExcelXlsxImporter.importColumn(Sheet poiSheet, SSheet sheet) [ISO/IEC 29500-1 1st Edition] 18.3.1.13 col (Column Width & Formatting) By experiments, CT_Col is always created in ascending order by min and the range specified by min & max doesn't overlap each other. For example:
protected void	ExcelXlsImporter.importColumn(Sheet poiSheet, SSheet sheet) When a column is hidden with default width, we don't import the width for it's 0.
protected abstract void	AbstractExcelImporter.importColumn(Sheet poiSheet, SSheet sheet) When a column is hidden with default width, we don't import the width for it's 0.
protected void	ExcelXlsxImporter.importConditionalFormatting(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsImporter.importConditionalFormatting(SSheet sheet, Sheet poiSheet)
protected abstract void	AbstractExcelImporter.importConditionalFormatting(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsxImporter.importDrawings(Sheet poiSheet, SSheet sheet)
protected void	ExcelXlsImporter.importDrawings(Sheet poiSheet, SSheet sheet) reference DrawingManagerImpl.initHSSFDrawings()
protected abstract void	AbstractExcelImporter.importDrawings(Sheet poiSheet, SSheet sheet) Drawings includes charts and pictures.
protected void	AbstractExcelImporter.importMergedRegions(Sheet poiSheet, SSheet sheet)
protected void	ExcelXlsxImporter.importPassword(Sheet poiSheet, SSheet sheet)
protected void	ExcelXlsImporter.importPassword(Sheet poiSheet, SSheet sheet)
protected abstract void	AbstractExcelImporter.importPassword(Sheet poiSheet, SSheet sheet)
protected void	AbstractExcelImporter.importPicture(List<Picture> poiPictures, Sheet poiSheet, SSheet sheet)
protected SRow	AbstractExcelImporter.importRow(Row poiRow, SSheet sheet)
protected void	ExcelXlsxImporter.importSheetDefaultColumnWidth(Sheet poiSheet, SSheet sheet)
protected void	AbstractExcelImporter.importSheetDefaultColumnWidth(Sheet poiSheet, SSheet sheet)
protected void	ExcelXlsxImporter.importSheetProtection(Sheet poiSheet, SSheet sheet)
protected void	ExcelXlsImporter.importSheetProtection(Sheet poiSheet, SSheet sheet)
protected abstract void	AbstractExcelImporter.importSheetProtection(Sheet poiSheet, SSheet sheet) POI SheetProtection.
protected void	ExcelXlsxImporter.importTables(Sheet poiSheet, SSheet sheet)
protected void	ExcelXlsImporter.importTables(Sheet poiSheet, SSheet sheet)
protected abstract void	AbstractExcelImporter.importTables(Sheet poiSheet, SSheet sheet) POI sheet tables
protected void	ExcelXlsxImporter.importValidation(Sheet poiSheet, SSheet sheet) Reference BookHelper.validate()
protected void	ExcelXlsImporter.importValidation(Sheet poiSheet, SSheet sheet)
protected abstract void	AbstractExcelImporter.importValidation(Sheet poiSheet, SSheet sheet)
protected void	ExcelXlsxExporter.plotPoiChart(SChart chart, ChartData chartData, SSheet sheet, Sheet poiSheet) Create and plot a POI chart with its chart data.
protected ConditionalFormattingImpl	ExcelXlsxImporter.prepareConditionalFormattingImpl(SSheet sheet, XSSFConditionalFormatting cf)
protected ClientAnchor	ExcelXlsxExporter.toClientAnchor(ViewAnchor viewAnchor, SSheet sheet)

Uses of SSheet in io.keikai.ui

Methods in io.keikai.ui that return SSheet

Modifier and Type	Method and Description
SSheet	Spreadsheet.getSelectedSSheet() Gets the selected sheet, the default selected sheet is first sheet.
SSheet	Spreadsheet.getSelectedXSheet() Deprecated. since 3.0.0 , use Spreadsheet.getSelectedSheet()

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

Modifier and Type	Method and Description
void	Spreadsheet.clearClientCache(SSheet sheet) Call this method to clear client side cache for a Sheet and fine tune data loading speed.
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.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 and Description
SSheet	HeaderUpdateEvent.getSheet() get Sheet
SSheet	HeaderMouseEvent.getSheet() get Sheet

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

Constructor and 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 and Description
Iterator<SSheet>	ActiveRangeHelper.sheetIterator()

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

Modifier and Type	Method and 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)
String	SimpleCellDisplayLoader.getCellHtmlText(SSheet sheet, int row, int column)
static String	CellFormatHelper.getCellHtmlText(SSheet sheet, int row, int column) Gets Cell text by given row and column
String	SimpleCellDisplayLoader.getCellHtmlText(SSheet sheet, int row, int column, FormatResult ft, SCellStyle tbStyle) Deprecated.
String	SimpleCellDisplayLoader.getCellHtmlText(SSheet sheet, int row, int column, FormatResult ft, SCellStyle tbStyle, SConditionalStyle cdStyle)
static String	CellFormatHelper.getCellHtmlText(SSheet sheet, int row, int column, FormatResult ft, SCellStyle tbStyle, SConditionalStyle cdStyle) Gets Cell text by given row and column
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	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

Constructor and Description
CellFormatHelper(SSheet sheet, int row, int col, MergeMatrixHelper mmhelper) Deprecated.
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 and Description
SSheet	ReserveUtil.ReservedResult.getSheet()

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

Modifier and Type	Method and 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

Constructor and 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 and 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)
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) Deprecated.
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, int left, int top, int right, int bottom)
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.onRowChange(SSheet sheet, int top, int bottom)
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
void	WidgetHandler.updateWidgets(SSheet sheet, int left, int top, int right, int bottom) Deprecated.

Uses of SSheet in io.keikaiex.ui.impl

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

Modifier and Type	Method and Description
String	CellDisplayLoaderImpl.getCellHtmlText(SSheet sheet, int row, int column)
String	CellDisplayLoaderImpl.getCellHtmlText(SSheet sheet, int row, int column, FormatResult ft, SCellStyle tbStyle) Deprecated.
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 and 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.onRowChange(SSheet sheet, int top, int bottom)
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)
void	DefaultWidgetHandler.updateWidgets(SSheet sheet, int left, int top, int right, int bottom) Deprecated.

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

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