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 onlyio.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 Spreadsheetio.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 SSheetSheet. 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 SSheetSheetImpl. getInternalSheet()SSheetSheetImpl. 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 SheetAnchorSheetImpl. toSheetAnchor(SSheet sheet, ViewAnchor anchor)Utility method, internal use onlystatic ViewAnchorSheetImpl. toViewAnchor(SSheet sheet, SheetAnchor anchor)Utility method, internal use onlyConstructor parameters in io.keikai.api.model.impl with type arguments of type SSheet 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.importer
Methods in io.keikai.importer that return SSheet Modifier and Type Method Description protected SSheetXlsxImporter. importSheet(XlsxExtractor.XlsxSheetExtractor xSheet)Methods in io.keikai.importer with parameters of type SSheet Modifier and Type Method Description protected intXlsxImporter. getAnchorHeightInPx(io.keikai.importer.ShapeJson shapeJson, SSheet sheet)DefaultBookWidgetLoader.getXSSFHeightInPx()protected intXlsxImporter. getAnchorWidthInPx(io.keikai.importer.ShapeJson shapeJson, SSheet sheet)Reference DefaultBookWidgetLoader.getXSSFWidthInPx()protected voidXlsxImporter. importAutoFilter(XlsxExtractor.XlsxSheetExtractor xSheet, SSheet sheet)protected SCellXlsxImporter. importCell(XlsxExtractor.XlsxCellExtractor xCell, int row, SSheet sheet)protected voidXlsxImporter. importChart(io.keikai.importer.ChartSpaceJson chartSpaceJson, XlsxExtractor.XlsxSheetExtractor xSheet, SSheet sheet)protected voidXlsxImporter. 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 voidXlsxImporter. importConditionalFormatting(XlsxExtractor.XlsxSheetExtractor xSheet, SSheet sheet, List<XlsxExtractor.XlsxExtExtractor> extList)protected voidXlsxImporter. importDrawings(XlsxExtractor.XlsxSheetExtractor xSheet, SSheet sheet)protected voidXlsxImporter. importMergedRegions(XlsxExtractor.XlsxSheetExtractor xSheet, SSheet sheet)protected voidXlsxImporter. importPassword(XlsxExtractor.XlsxSheetProtectionExtractor protectionExtractor, SSheet sheet)protected voidXlsxImporter. importPicture(io.keikai.importer.PictureJson pictureJson, XlsxExtractor.XlsxSheetExtractor xSheet, SSheet sheet)protected voidXlsxImporter. importPrintArea(XlsxExtractor.XlsxSheetExtractor xSheet, SSheet sheet)protected SRowXlsxImporter. importRow(XlsxExtractor.XlsxRowExtractor xRow, SSheet sheet)protected voidXlsxImporter. importSheetProtection(XlsxExtractor.XlsxSheetExtractor xSheet, SSheet sheet)protected voidXlsxImporter. importSparklines(XlsxExtractor.XlsxSheetExtractor xSheet, SSheet sheet, List<XlsxExtractor.XlsxExtExtractor> extList)protected voidXlsxImporter. importTables(XlsxExtractor.XlsxSheetExtractor xSheet, SSheet sheet)protected voidXlsxImporter. importValidation(XlsxExtractor.XlsxSheetExtractor xSheet, SSheet sheet, List<XlsxExtractor.XlsxExtExtractor> extList)Reference BookHelper.validate()protected ConditionalFormattingImplXlsxImporter. prepareConditionalFormattingImpl(SSheet sheet, XlsxExtractor.XlsxConditionalFormattingExtractor cf)protected ViewAnchorXlsxImporter. toSparklineViewAnchor(String anchorRef, SSheet sheet)protected ViewAnchorXlsxImporter. 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 Description SSheetSBook. createSheet(String name)Create a sheetSSheetSBook. 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.SSheetSBook. 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.SSheetModelEvent. getSheet()SSheetSBook. getSheet(int idx)Get sheet at the indexSSheetSCell. getSheet()SSheetSChart. getSheet()SSheetSColumn. getSheet()SSheetSColumnArray. getSheet()SSheetSConditionalFormatting. getSheet()The sheet on which this conditional formatting coveredSSheetSConditionalFormattingRule. getSheet()SSheetSDataValidation. getSheet()SSheetSheetRegion. getSheet()SSheetSPicture. getSheet()SSheetSRow. getSheet()SSheetSBook. getSheetById(String id)Get the sheet by idSSheetSBook. getSheetByName(String name)Get the sheet by nameMethods in io.keikai.model that return types with arguments of type SSheet Modifier and Type Method Description List<SSheet>SBook. getSheets()Get all sheetsMethods in io.keikai.model with parameters of type SSheet Modifier and Type Method Description static ModelEventModelEvents. createModelEvent(String name, SBook book, SSheet sheet, Map data)static ModelEventModelEvents. createModelEvent(String name, SSheet sheet)static ModelEventModelEvents. createModelEvent(String name, SSheet sheet, CellRegion region)static ModelEventModelEvents. createModelEvent(String name, SSheet sheet, CellRegion region, Map data)static ModelEventModelEvents. createModelEvent(String name, SSheet sheet, Map data)SSheetSBook. 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.SSheetSBook. 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.voidSBook. deleteSheet(SSheet sheet)Delete the sheetViewAnchorViewAnchor. getRightBottomAnchor(SSheet sheet)intSBook. getSheetIndex(SSheet sheet)Get the index of sheetvoidSBook. moveSheetTo(SSheet sheet, int index)Move the sheet to new positionvoidSBook. setSheetName(SSheet sheet, String newname)Set the sheet to a new nameConstructors in io.keikai.model with parameters of type SSheet 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 classAbstractSheetAdvclassSheetImplMethods in io.keikai.model.impl that return SSheet Modifier and Type Method Description SSheetBookImpl. createSheet(String name)SSheetBookImpl. createSheet(String name, SSheet src)SSheetBookImpl. createSheet(String name, SSheet src, boolean valueOnly)SSheetBookImpl. getSheet(int i)SSheetCellImpl. getSheet()SSheetChartImpl. getSheet()SSheetColumnArrayImpl. getSheet()SSheetConditionalFormattingImpl. getSheet()SSheetConditionalFormattingRuleImpl. getSheet()SSheetDataValidationImpl. getSheet()SSheetPictureImpl. getSheet()SSheetRowImpl. getSheet()SSheetBookImpl. getSheetById(String id)SSheetBookImpl. getSheetByName(String name)Methods in io.keikai.model.impl that return types with arguments of type SSheet Modifier and Type Method Description List<SSheet>BookImpl. getSheets()Methods in io.keikai.model.impl with parameters of type SSheet Modifier and Type Method Description protected voidBookImpl. checkOwnership(SSheet sheet)SSheetBookImpl. createSheet(String name, SSheet src)SSheetBookImpl. createSheet(String name, SSheet src, boolean valueOnly)voidBookImpl. deleteSheet(SSheet sheet)intBookImpl. getSheetIndex(SSheet sheet)voidBookImpl. moveSheetTo(SSheet sheet, int index)voidBookImpl. setSheetName(SSheet sheet, String newname)Constructors in io.keikai.model.impl with parameters of type SSheet Constructor 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 Description static ToHtmlToHtml. create(SSheet ws, OutputStream output)voidHtmlExporter. export(SSheet worksheet, OutputStream outputStream)Exports Keikai SpreadsheetSSheetinto another format written to astatic voidToHtml. export(SSheet ws, CellRegion area, OutputStream outputStream)static voidToHtml. export(SSheet ws, CellRegion area, OutputStream outputStream, boolean noHeader)static voidToHtml. export(SSheet ws, OutputStream outputStream)static voidToHtml. export(SSheet ws, OutputStream outputStream, boolean noHeader)voidToHtml. 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 Description protected SSheetPdfExporter. _currentSheetMethods in io.keikai.model.impl.pdf with parameters of type SSheet Modifier and Type Method Description protected com.lowagie.text.pdf.PdfPCellPdfExporter. createEmptyRowSpanCell(SSheet sheet, CellRegion outlineRegion, double rowHeight, CellRegion renderRegion, int rowIdx, int colIdx, boolean printOutline, boolean printGridline)protected com.lowagie.text.pdf.PdfPCellPdfExporter. createPdfCell(CellRegion clipRegion, CellRegion renderRegion, SCell zssCell, CellRegion outlineRegion, SSheet sheet, boolean printGridLines, boolean printOutline, boolean extended)creates a PdfCell from POICellprotected com.lowagie.text.pdf.PdfPTablePdfExporter. createPdfTable(int bCol, int eCol, SSheet sheet)voidPdfExporter. export(SSheet worksheet, OutputStream outputStream)Exports Keikai SpreadsheetSSheetinto another format written to aprotected voidPdfExporter. exportSheet(SSheet sheet, int sheetIndex, com.lowagie.text.Document doc)converts POISSheetto Pdf page(s)protected voidPdfExporter. exportSheetSelection(SSheet sheet, int sheetIndex, CellRegion area, com.lowagie.text.Document doc)converts POISSheetto Pdf page(s)protected intPdfExporter. getAcrossSelectionColumn0(SSheet sheet, int rowIdx, int colIdx)protected SFooterPdfExporter. getCurrentFooter(SSheet sheet)protected SHeaderPdfExporter. getCurrentHeader(SSheet sheet)protected SPrintSetupPdfExporter. getCurrentPrintSetup(SSheet sheet)protected intPdfExporter. getExtendedEndColumn(SSheet sheet, SCell zssCell, int colIdx)protected intPdfExporter. getExtendedEndColumn0(SSheet sheet, SCell zssCell, int colIdx)protected CellRegionPdfExporter. getMergedRegionIfAny(SSheet sheet, int rowIdx, int colIdx)returns merged region cell range for a given cellprotected voidPdfExporter. getPictureData(SSheet sheet)retrieve all zkpictures for given sheetprotected CellRegion[]PdfExporter. getPrintAreas(SPrintSetup ps, SSheet sheet)protected voidPdfExporter. initDocument(SSheet sheet, com.lowagie.text.Document doc)Set pdf page common properties such as margins and document standard fontprotected voidPdfExporter. initDocumentForSheet(SSheet sheet, com.lowagie.text.Document doc)protected voidPdfExporter. initPrintArea(SSheet sheet, CellRegion region)sets the column bounds for passedSSheetprotected voidPdfExporter. initRowColumnPositions(SSheet sheet)protected voidPdfExporter. initSelectedPrintArea(SSheet sheet)protected voidPdfExporter. initSheetPrintSetup(SSheet sheet)protected booleanPdfExporter. isPartOfMergedRegion(SSheet sheet, SCell cell)checks if POICellis part of any merged regions on the passedSSheetprotected voidPdfExporter. layoutCharts(SSheet sheet, int bRow, int eRow, int bCol, int eCol, com.lowagie.text.pdf.PdfWriter writer)protected voidPdfExporter. layoverPictureIfAny(SSheet sheet, int bRow, int eRow, int bCol, int eCol, com.lowagie.text.pdf.PdfWriter writer)lays images over PdfTableprotected voidPdfExporter. prepareColBreaks(SSheet sheet, boolean ignoreManualBreaks)protected intPdfExporter. prepareFitPageScale(SSheet sheet, int fitWidth, int fitHeight)protected double[]PdfExporter. preparePageXYInfo(SSheet sheet, int bRow, int eRow, int bCol, int eCol)protected voidPdfExporter. prepareRowBreaks(SSheet sheet, boolean ignoreManualBreaks)Sets column/row breaks if not defined alreadyprotected intPdfExporter. prepareScaleX(SSheet sheet, int fitWidth)protected intPdfExporter. prepareScaleY(SSheet sheet, int fitHeight)protected intPdfExporter. 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 voidPdfExporter. printPage(int bRow, int eRow, int bCol, int eCol, SSheet sheet, com.lowagie.text.Document doc)protected voidPdfExporter. printRow(com.lowagie.text.pdf.PdfPTable pdfTable, int rowIdx, int bRow, int eRow, int bCol, int eCol, SSheet sheet, float rowHeight, CellRegion outlineRegion)protected voidPdfExporter. printScaleSheet(SSheet sheet, com.lowagie.text.Document doc, SPrintSetup ps)protected voidPdfExporter. printSheet(SSheet sheet, com.lowagie.text.Document doc)protected intPdfExporter. searchNonBlankEndColumn(SSheet sheet, int rowIdx, int lastColIdx)Returns the last cell that contains valueprotected voidPdfExporter. setupColumnBreaks(SSheet sheet)sets auto column breaks based on column width and available page widthprotected com.lowagie.text.DocumentPdfExporter. setupExporter(SSheet sheet, OutputStream outputStream, com.lowagie.text.Document document)protected voidPdfExporter. 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 Description SSheetEvalSheet. getNSheet()Methods in io.keikai.model.impl.sys.formula with parameters of type SSheet Modifier and Type Method Description voidFormulaEngineImpl. clearIterationValue(SBook book, SSheet sheet, SCell cell)Constructors in io.keikai.model.impl.sys.formula with parameters of type SSheet Constructor 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 Description SSheetFormulaClearContext. getSheet()SSheetFormulaEvaluationContext. getSheet()SSheetFormulaParseContext. getSheet()Constructors in io.keikai.model.sys.formula with parameters of type SSheet 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 SSheetSRange. cloneSheet(String name)Clone sheet as specified in this Range.SSheetSRange. cloneSheetFrom(String name, SSheet sheet)Clone from the specified source sheet to the owner book of this range.SSheetSRange. cloneSheetFrom(String name, SSheet sheet, boolean valueOnly)Clone from the specified source sheet to the owner book of this range.SSheetSRange. createSheet(String name)Create sheet of this book as specified in this Range.SSheetSRange. getSheet()Returns associateSSheetof this range.Methods in io.keikai.range with parameters of type SSheet Modifier and Type Method Description SSheetSRange. cloneSheetFrom(String name, SSheet sheet)Clone from the specified source sheet to the owner book of this range.SSheetSRange. 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 toSSheetstatic SRangeSRanges. range(SSheet sheet)static SRangeSRanges. range(SSheet sheet, int row, int col)static SRangeSRanges. range(SSheet sheet, int tRow, int lCol, int bRow, int rCol)Returns the associatedXRangeof the specifiedXNSheetand area.static SRangeSRanges. range(SSheet sheet, CellRegion region)static SRangeSRanges. range(SSheet sheet, String areaReference)static SRangeSRanges. rangeByName(SSheet sheet, String name)Returns the associatedSRangeof 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 SSheetRangeHelperBase. sheetMethods in io.keikai.range.impl that return SSheet Modifier and Type Method Description SSheetRangeImpl. cloneSheet(String name)SSheetRangeImpl. cloneSheetFrom(String name, SSheet sheet)SSheetRangeImpl. cloneSheetFrom(String name, SSheet sheet, boolean valueOnly)SSheetRangeImpl. createSheet(String name)SSheetAutoFilterUpdate. getSheet()SSheetInsertDeleteUpdate. getSheet()SSheetMergeUpdate. getSheet()SSheetRangeImpl. getSheet()Methods in io.keikai.range.impl with parameters of type SSheet Modifier and Type Method Description voidModelUpdateCollector. addAutoFilterUpdate(SSheet sheet, STable table)voidModelUpdateCollector. addCellUpdate(SSheet sheet, int row, int column, int lastRow, int lastColumn, CellAttribute cellAttr)voidModelUpdateCollector. addInsertDeleteUpdate(SSheet sheet, boolean inserted, boolean isRow, int index, int lastIndex)voidModelUpdateCollector. addMergeChange(SSheet sheet, CellRegion original, CellRegion changeTo)SSheetRangeImpl. cloneSheetFrom(String name, SSheet sheet)SSheetRangeImpl. cloneSheetFrom(String name, SSheet sheet, boolean valueOnly)static Set<String>InsertDeleteHelper. collectContainedTables(SSheet sheet, int row1, int col1, int row2, int col2)static voidInsertDeleteHelper. deleteTablesByNames(SSheet sheet, Set<String> toDelete)static booleanDataRegionHelper. isOneCell(SSheet sheet, CellRegion rng)voidNotifyChangeHelper. notifyChartChange(SSheet sheet, String chartId)voidNotifyChangeHelper. notifyCustomEvent(String customEventName, SSheet sheet, Object data)voidNotifyChangeHelper. notifyDataValidationChange(SSheet sheet, String validationId)voidNotifyChangeHelper. notifyDisplayGridlines(SSheet sheet, boolean show)voidNotifyChangeHelper. notifyNameNameChange(SSheet sheet, SName name, String oldName)voidNotifyChangeHelper. notifyProtectSheet(SSheet sheet, boolean protect)voidNotifyChangeHelper. notifyReleaseSelectedCache(SSheet sheet)voidNotifyChangeHelper. notifySheetAutoFilterChange(SSheet sheet, STable table)voidNotifyChangeHelper. notifySheetChartAdd(SSheet sheet, String id)voidNotifyChangeHelper. notifySheetChartDelete(SSheet sheet, String id)voidNotifyChangeHelper. notifySheetChartUpdate(SSheet sheet, String id)voidNotifyChangeHelper. notifySheetCreate(SSheet sheet)voidNotifyChangeHelper. notifySheetDelete(SBook book, SSheet deletedSheet, int deletedIndex)voidNotifyChangeHelper. notifySheetFreezeChange(SSheet sheet)voidNotifyChangeHelper. notifySheetGroupChange(SSheet sheet)voidNotifyChangeHelper. notifySheetNameChange(SSheet sheet, String oldName)voidNotifyChangeHelper. notifySheetPictureAdd(SSheet sheet, String id)voidNotifyChangeHelper. notifySheetPictureDelete(SSheet sheet, String id)voidNotifyChangeHelper. notifySheetPictureMove(SSheet sheet, String id)voidNotifyChangeHelper. notifySheetReorder(SSheet sheet, int oldIdx)voidNotifyChangeHelper. notifySheetSelect(SSheet sheet)voidNotifyChangeHelper. notifySheetVisibleChange(SSheet sheet)Constructors in io.keikai.range.impl with parameters of type SSheet 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 voidAutoFillHelper. fill(SSheet sheet, CellRegion srcRegion, CellRegion dstRegion, SRange.FillType fillType)fill the sheet, from srcRef to dstRefvoidAutoFillHelper. fillDown(SSheet sheet, CellRegion srcRef, CellRegion dstRef, SRange.FillType fillType)voidAutoFillHelper. fillLeft(SSheet sheet, CellRegion srcRef, CellRegion dstRef, SRange.FillType fillType)voidAutoFillHelper. fillRight(SSheet sheet, CellRegion srcRef, CellRegion dstRef, SRange.FillType fillType)voidAutoFillHelper. 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 Description protected SSheetAbstractExcelImporter. importSheet(Sheet poiSheet, int poiSheetIndex)Methods in io.keikai.range.impl.imexp with parameters of type SSheet Modifier and Type Method Description protected voidExcelXlsxExporter. addPoiRule(SSheet sheet, org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCfRule ctRule, SConditionalFormattingRule rule)voidAbstractExporter. export(SSheet sheet, OutputStream fos)protected abstract voidAbstractExcelExporter. exportAutoFilter(SSheet sheet, Sheet poiSheet)protected voidExcelXlsExporter. exportAutoFilter(SSheet sheet, Sheet poiSheet)protected voidExcelXlsxExporter. exportAutoFilter(SSheet sheet, Sheet poiSheet)See Javadoc atAbstractExcelImporterimportAutoFilter().protected abstract voidAbstractExcelExporter. exportChart(SSheet sheet, Sheet poiSheet)protected voidExcelXlsExporter. exportChart(SSheet sheet, Sheet poiSheet)protected voidExcelXlsxExporter. exportChart(SSheet sheet, Sheet poiSheet)reference DrawingManagerImpl.addChartX()protected abstract voidAbstractExcelExporter. exportColumnArray(SSheet sheet, Sheet poiSheet, SColumnArray columnArr)protected voidExcelXlsExporter. exportColumnArray(SSheet sheet, Sheet poiSheet, SColumnArray columnArr)protected voidExcelXlsxExporter. exportColumnArray(SSheet sheet, Sheet poiSheet, SColumnArray columnArr)protected abstract voidAbstractExcelExporter. exportConditionalFormatting(SSheet sheet, Sheet poiSheet)protected voidExcelXlsExporter. exportConditionalFormatting(SSheet sheet, Sheet poiSheet)protected voidExcelXlsxExporter. exportConditionalFormatting(SSheet sheet, Sheet poiSheet)protected abstract voidAbstractExcelExporter. exportExtLst(SSheet sheet, Sheet poiSheet)protected voidExcelXlsExporter. exportExtLst(SSheet sheet, Sheet poiSheet)protected voidExcelXlsxExporter. exportExtLst(SSheet sheet, Sheet poiSheet)protected voidAbstractExcelExporter. exportMergedRegions(SSheet sheet, Sheet poiSheet)protected abstract voidAbstractExcelExporter. exportPassword(SSheet sheet, Sheet poiSheet)protected voidExcelXlsExporter. exportPassword(SSheet sheet, Sheet poiSheet)Export hashed password directly to poiSheet.protected voidExcelXlsxExporter. exportPassword(SSheet sheet, Sheet poiSheet)Export hashed password directly to poiSheet.protected abstract voidAbstractExcelExporter. exportPicture(SSheet sheet, Sheet poiSheet)protected voidExcelXlsExporter. exportPicture(SSheet sheet, Sheet poiSheet)protected voidExcelXlsxExporter. exportPicture(SSheet sheet, Sheet poiSheet)Reference DrawingManagerImpl.addPicture()protected voidAbstractExcelExporter. exportRow(SSheet sheet, Sheet poiSheet, SRow row)protected voidAbstractExcelExporter. exportRowColumn(SSheet sheet, Sheet poiSheet)protected voidExcelXlsxExporter. exportRowColumn(SSheet sheet, Sheet poiSheet)protected voidAbstractExcelExporter. exportSheet(SSheet sheet)protected abstract voidAbstractExcelExporter. exportSheetPr(SSheet sheet, Sheet poiSheet)protected voidExcelXlsExporter. exportSheetPr(SSheet sheet, Sheet poiSheet)protected voidExcelXlsxExporter. exportSheetPr(SSheet sheet, Sheet poiSheet)protected voidAbstractExcelExporter. exportSheetProtection(SSheet sheet, Sheet poiSheet)POI SheetProtection.protected abstract intAbstractExcelExporter. exportTables(SSheet sheet, Sheet poiSheet, int tbId)protected intExcelXlsExporter. exportTables(SSheet sheet, Sheet poiSheet, int tbId)protected intExcelXlsxExporter. exportTables(SSheet sheet, Sheet poiSheet0, int tbId)protected abstract voidAbstractExcelExporter. exportValidation(SSheet sheet, Sheet poiSheet)protected voidExcelXlsExporter. exportValidation(SSheet sheet, Sheet poiSheet)protected voidExcelXlsxExporter. exportValidation(SSheet sheet, Sheet poiSheet)According toSDataValidation.ValidationType, FORMULA means custom validation.protected voidAbstractExcelImporter. importAutoFilter(Sheet poiSheet, SSheet sheet)POI AutoFilter.getFilterColumn(i) sometimes returns null.protected SCellAbstractExcelImporter. importCell(Cell poiCell, int row, SSheet sheet)protected voidExcelXlsImporter. importChart(List<HSSFChartShape> poiCharts, Sheet poiSheet, SSheet sheet)protected abstract voidAbstractExcelImporter. importColumn(Sheet poiSheet, SSheet sheet)When a column is hidden with default width, we don't import the width for it's 0.protected voidExcelXlsImporter. 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 voidAbstractExcelImporter. importConditionalFormatting(SSheet sheet, Sheet poiSheet)protected voidExcelXlsImporter. importConditionalFormatting(SSheet sheet, Sheet poiSheet)protected abstract voidAbstractExcelImporter. importDrawings(Sheet poiSheet, SSheet sheet)Drawings includes charts and pictures.protected voidExcelXlsImporter. importDrawings(Sheet poiSheet, SSheet sheet)reference DrawingManagerImpl.initHSSFDrawings()protected voidAbstractExcelImporter. importMergedRegions(Sheet poiSheet, SSheet sheet)protected abstract voidAbstractExcelImporter. importPassword(Sheet poiSheet, SSheet sheet)protected voidExcelXlsImporter. importPassword(Sheet poiSheet, SSheet sheet)protected voidAbstractExcelImporter. importPicture(List<Picture> poiPictures, Sheet poiSheet, SSheet sheet)protected SRowAbstractExcelImporter. importRow(Row poiRow, SSheet sheet)protected voidAbstractExcelImporter. importSheetDefaultColumnWidth(Sheet poiSheet, SSheet sheet)protected abstract voidAbstractExcelImporter. importSheetProtection(Sheet poiSheet, SSheet sheet)POI SheetProtection.protected voidExcelXlsImporter. importSheetProtection(Sheet poiSheet, SSheet sheet)protected abstract voidAbstractExcelImporter. importTables(Sheet poiSheet, SSheet sheet)POI sheet tablesprotected voidExcelXlsImporter. importTables(Sheet poiSheet, SSheet sheet)protected abstract voidAbstractExcelImporter. importValidation(Sheet poiSheet, SSheet sheet)protected voidExcelXlsImporter. importValidation(Sheet poiSheet, SSheet sheet)protected ClientAnchorExcelXlsxExporter. toClientAnchor(ViewAnchor viewAnchor, SSheet sheet) -
Uses of SSheet in io.keikai.ui
Methods in io.keikai.ui that return SSheet Modifier and Type Method Description SSheetSpreadsheet. 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 voidSpreadsheet. clearClientCache(SSheet sheet)Call this method to clear client side cache for a Sheet and fine tune data loading speed.HeaderPositionHelperSpreadsheet. getColumnPosition(SSheet sheet)HeaderPositionHelperSpreadsheet. getRowPosition(SSheet sheet)intSpreadsheet. getSheetMaxVisibleColumns(SSheet sheet)Returns the max visible columns of the specified sheetintSpreadsheet. getSheetMaxVisibleRows(SSheet sheet)Returns the max visible rows of the specified sheetvoidSpreadsheet. setAutofitColumnWidth(SSheet sheet, int column)AutoFit a single column width according to its data size.voidSpreadsheet. setAutofitColumnWidth(SSheet sheet, int fromColumn, int toColumn)AutoFit multiple columns width according to each one's data size from thefromColumn to thetoColumn .voidSpreadsheet. setSheetMaxVisibleColumns(SSheet sheet, int maxColumns)Sets the max visibles columns of the specified sheet.voidSpreadsheet. 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 SSheetHeaderMouseEvent. getSheet()get SheetSSheetHeaderUpdateEvent. getSheet()get SheetConstructors in io.keikai.ui.event with parameters of type SSheet 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 booleanActiveRangeHelper. contains(SSheet sheet, int row, int col)booleanActiveRangeHelper. contains(SSheet sheet, int tRow, int lCol, int bRow, int rCol)booleanActiveRangeHelper. containsSheet(SSheet sheet)AreaRefActiveRangeHelper. getArea(SSheet sheet)static StringCellFormatHelper. getCellHtmlText(SSheet sheet, int row, int column)Gets Cell text by given row and columnstatic StringCellFormatHelper. getCellHtmlText(SSheet sheet, int row, int column, FormatResult ft, SCellStyle tbStyle, SConditionalStyle cdStyle)Gets Cell text by given row and columnStringSimpleCellDisplayLoader. getCellHtmlText(SSheet sheet, int row, int column)StringSimpleCellDisplayLoader. getCellHtmlText(SSheet sheet, int row, int column, FormatResult ft, SCellStyle tbStyle, SConditionalStyle cdStyle)static StringCellFormatHelper. getFontHtmlStyle(SSheet sheet, SCell cell, SCellStyle cellStyle, FormatResult ft, SCellStyle tbCellStyle, SConditionalStyle cdStyle)static StringCellFormatHelper. getRichCellHtmlText(SSheet sheet, int row, int column)Gets Cell text by given row and column, it handlingstatic StringCellFormatHelper. getRichCellHtmlText(SSheet sheet, int row, int column, FormatResult ft, SCellStyle tbStyle, SConditionalStyle cdStyle)Gets Cell text by given row and column, it handlingstatic StringCellFormatHelper. getRichTextEditCellHtml(SSheet sheet, int row, int column)voidVoidWidgetHandler. onLoadOnDemand(SSheet sheet, int left, int top, int right, int bottom)AreaRefActiveRangeHelper. removeActiveRange(SSheet sheet)voidActiveRangeHelper. setActiveRange(SSheet sheet, int tRow, int lCol, int bRow, int rCol)voidActiveRangeHelper. setActiveRange(SSheet sheet, int tRow, int lCol, int bRow, int rCol, boolean clearFirst)voidVoidWidgetHandler. updateWidget(SSheet sheet, String widgetId)voidVoidWidgetHandler. updateWidgets(SSheet sheet, int left, int top, int right, int bottom)Constructors in io.keikai.ui.impl with parameters of type SSheet 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 SSheetReserveUtil.ReservedResult. getSheet()Methods in io.keikai.ui.impl.undo with parameters of type SSheet Modifier and Type Method Description static ReserveUtil.ReservedResultReserveUtil. 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 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 voidWidgetLoader. addChartWidget(SSheet sheet, SChart chart)call when spreadsheet try to load a block of cell to client side.voidSpreadsheetOutCtrl. addMergeCell(SSheet sheet, int left, int top, int right, int bottom)voidWidgetLoader. addPictureWidget(SSheet sheet, SPicture picture)voidWidgetLoader. deleteChartWidget(SSheet sheet, String chartId)voidSpreadsheetOutCtrl. deleteMergeCell(SSheet sheet, int left, int top, int right, int bottom)voidWidgetLoader. deletePictureWidget(SSheet sheet, String pictureId)org.zkoss.json.JSONObjectSpreadsheetCtrl. 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>StringCellDisplayLoader. getCellHtmlText(SSheet sheet, int row, int column)return the html text for this cellStringCellDisplayLoader. getCellHtmlText(SSheet sheet, int row, int column, FormatResult ft, SCellStyle tbStyle, SConditionalStyle cdStyle)org.zkoss.json.JSONObjectSpreadsheetCtrl. getColumnHeaderAttrs(SSheet sheet, int colStart, int colEnd)MergeMatrixHelperSpreadsheetCtrl. getMergeMatrixHelper(SSheet sheet)org.zkoss.json.JSONObjectSpreadsheetCtrl. getRangeAttrs(SSheet sheet, SpreadsheetCtrl.Header containsHeader, SpreadsheetCtrl.CellAttribute type, int left, int top, int right, int bottom)org.zkoss.json.JSONObjectSpreadsheetCtrl. getRowHeaderAttrs(SSheet sheet, int rowStart, int rowEnd)voidSpreadsheetOutCtrl. insertColumns(SSheet sheet, int col, int size)voidSpreadsheetOutCtrl. insertRows(SSheet sheet, int row, int size)voidWidgetLoader. onColumnChange(SSheet sheet, int left, int right)voidWidgetHandler. onLoadOnDemand(SSheet sheet, int left, int top, int right, int bottom)call when spreadsheet try to load a block of cell to client side.voidWidgetLoader. onResetSparklineAnchor(SSheet sheet, CellRegion region)voidWidgetLoader. onRowChange(SSheet sheet, int top, int bottom)voidWidgetLoader. onRowColumnChange(SSheet sheet, CellRegion region)voidWidgetLoader. onSheetClean(SSheet sheet)indicate the sheet is dis-selectedvoidWidgetLoader. onSheetFreeze(SSheet sheet)indicate the sheet's freeze panel is changed.voidWidgetLoader. onSheetSelected(SSheet sheet)indicate the selected sheet of a spreadsheet is changed.voidSpreadsheetOutCtrl. removeColumns(SSheet sheet, int col, int size)voidSpreadsheetOutCtrl. removeRows(SSheet sheet, int row, int size)voidSpreadsheetOutCtrl. setColumnWidth(SSheet sheet, int col, int width, int id, boolean hidden)voidSpreadsheetOutCtrl. setRowHeight(SSheet sheet, int row, int height, int id, boolean hidden, boolean isCustom)voidWidgetLoader. updateChartWidget(SSheet sheet, SChart chart)voidSpreadsheetOutCtrl. updateMergeCell(SSheet sheet, int left, int top, int right, int bottom, int oleft, int otop, int oright, int obottom)voidWidgetLoader. updatePictureWidget(SSheet sheet, SPicture picture)voidWidgetHandler. 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 StringCellDisplayLoaderImpl. getCellHtmlText(SSheet sheet, int row, int column)StringCellDisplayLoaderImpl. 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 voidDefaultBookWidgetLoader. addChartWidget(SSheet sheet, SChart chart)voidDefaultBookWidgetLoader. addPictureWidget(SSheet sheet, SPicture picture)voidDefaultBookWidgetLoader. deleteChartWidget(SSheet sheet, String chartId)voidDefaultBookWidgetLoader. deletePictureWidget(SSheet sheet, String pictureId)protected WidgetDefaultBookWidgetLoader. newChartWidget(SSheet sheet, SChart chart, String panel, int zindex)protected List<Widget>DefaultBookWidgetLoader. newChartWidgetGroup(SSheet sheet, SChart chart, int zindex)protected WidgetDefaultBookWidgetLoader. 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)voidDefaultBookWidgetLoader. onColumnChange(SSheet sheet, int left, int right)voidDefaultWidgetHandler. onLoadOnDemand(SSheet sheet, int left, int top, int right, int bottom)voidDefaultBookWidgetLoader. onResetSparklineAnchor(SSheet sheet, CellRegion region)voidDefaultBookWidgetLoader. onRowChange(SSheet sheet, int top, int bottom)voidDefaultBookWidgetLoader. onRowColumnChange(SSheet sheet, CellRegion region)voidDefaultBookWidgetLoader. onSheetClean(SSheet sheet)voidDefaultBookWidgetLoader. onSheetFreeze(SSheet sheet)voidDefaultBookWidgetLoader. onSheetSelected(SSheet sheet)voidDefaultBookWidgetLoader. updateChartWidget(SSheet sheet, SChart chart)voidDefaultBookWidgetLoader. updatePictureWidget(SSheet sheet, SPicture picture)voidDefaultWidgetHandler. updateWidget(SSheet sheet, String widgetId)Constructors in io.keikaiex.ui.widget with parameters of type SSheet Constructor Description ChartsWidget(SSheet sheet, SChart chartInfo, String panel, int zindex)ImageWidget(SSheet sheet, SPicture pic, String panel)
-