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 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 onlystatic ViewAnchor
SheetImpl. 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 SSheet
XlsxImporter. importSheet(XlsxExtractor.XlsxSheetExtractor xSheet)
Methods in io.keikai.importer with parameters of type SSheet Modifier and Type Method 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)
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, List<XlsxExtractor.XlsxExtExtractor> extList)
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. importSparklines(XlsxExtractor.XlsxSheetExtractor xSheet, SSheet sheet, List<XlsxExtractor.XlsxExtExtractor> extList)
protected void
XlsxImporter. importTables(XlsxExtractor.XlsxSheetExtractor xSheet, SSheet sheet)
protected void
XlsxImporter. importValidation(XlsxExtractor.XlsxSheetExtractor xSheet, SSheet sheet, List<XlsxExtractor.XlsxExtExtractor> extList)
Reference BookHelper.validate()protected ConditionalFormattingImpl
XlsxImporter. prepareConditionalFormattingImpl(SSheet sheet, XlsxExtractor.XlsxConditionalFormattingExtractor cf)
protected ViewAnchor
XlsxImporter. toSparklineViewAnchor(String anchorRef, SSheet sheet)
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 Description SSheet
SBook. createSheet(String name)
Create a sheetSSheet
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 indexSSheet
SCell. getSheet()
SSheet
SChart. getSheet()
SSheet
SColumn. getSheet()
SSheet
SColumnArray. getSheet()
SSheet
SConditionalFormatting. getSheet()
The sheet on which this conditional formatting coveredSSheet
SConditionalFormattingRule. getSheet()
SSheet
SDataValidation. getSheet()
SSheet
SheetRegion. getSheet()
SSheet
SPicture. getSheet()
SSheet
SRow. getSheet()
SSheet
SBook. getSheetById(String id)
Get the sheet by idSSheet
SBook. 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 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 sheetViewAnchor
ViewAnchor. getRightBottomAnchor(SSheet sheet)
int
SBook. getSheetIndex(SSheet sheet)
Get the index of sheetvoid
SBook. moveSheetTo(SSheet sheet, int index)
Move the sheet to new positionvoid
SBook. 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 class
AbstractSheetAdv
class
SheetImpl
Methods in io.keikai.model.impl that return SSheet Modifier and Type Method Description SSheet
BookImpl. createSheet(String name)
SSheet
BookImpl. createSheet(String name, SSheet src)
SSheet
BookImpl. createSheet(String name, SSheet src, boolean valueOnly)
SSheet
BookImpl. getSheet(int i)
SSheet
CellImpl. getSheet()
SSheet
ChartImpl. getSheet()
SSheet
ColumnArrayImpl. getSheet()
SSheet
ConditionalFormattingImpl. getSheet()
SSheet
ConditionalFormattingRuleImpl. getSheet()
SSheet
DataValidationImpl. getSheet()
SSheet
PictureImpl. getSheet()
SSheet
RowImpl. getSheet()
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 Description List<SSheet>
BookImpl. getSheets()
Methods in io.keikai.model.impl with parameters of type SSheet Modifier and Type Method Description protected void
BookImpl. checkOwnership(SSheet sheet)
SSheet
BookImpl. createSheet(String name, SSheet src)
SSheet
BookImpl. createSheet(String name, SSheet src, boolean valueOnly)
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 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 ToHtml
ToHtml. create(SSheet ws, OutputStream output)
void
HtmlExporter. export(SSheet worksheet, OutputStream outputStream)
Exports Keikai SpreadsheetSSheet
into another format written to astatic 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)
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 Description protected SSheet
PdfExporter. _currentSheet
Methods in io.keikai.model.impl.pdf with parameters of type SSheet Modifier and Type Method 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 POICell
protected com.lowagie.text.pdf.PdfPTable
PdfExporter. createPdfTable(int bCol, int eCol, SSheet sheet)
void
PdfExporter. export(SSheet worksheet, OutputStream outputStream)
Exports Keikai SpreadsheetSSheet
into another format written to aprotected void
PdfExporter. exportSheet(SSheet sheet, int sheetIndex, com.lowagie.text.Document doc)
converts POISSheet
to Pdf page(s)protected void
PdfExporter. exportSheetSelection(SSheet sheet, int sheetIndex, CellRegion area, com.lowagie.text.Document doc)
converts POISSheet
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 cellprotected void
PdfExporter. getPictureData(SSheet sheet)
retrieve all zkpictures for given sheetprotected 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 fontprotected void
PdfExporter. initDocumentForSheet(SSheet sheet, com.lowagie.text.Document doc)
protected void
PdfExporter. initPrintArea(SSheet sheet, CellRegion region)
sets the column bounds for passedSSheet
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 POICell
is part of any merged regions on the passedSSheet
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 PdfTableprotected 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 alreadyprotected 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 valueprotected void
PdfExporter. setupColumnBreaks(SSheet sheet)
sets auto column breaks based on column width and available page widthprotected 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 Description SSheet
EvalSheet. getNSheet()
Methods in io.keikai.model.impl.sys.formula with parameters of type SSheet Modifier and Type Method Description void
FormulaEngineImpl. 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 SSheet
FormulaClearContext. getSheet()
SSheet
FormulaEvaluationContext. getSheet()
SSheet
FormulaParseContext. 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 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 associateSSheet
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 toSSheet
static SRange
SRanges. range(SSheet sheet)
static SRange
SRanges. range(SSheet sheet, int row, int col)
static SRange
SRanges. range(SSheet sheet, int tRow, int lCol, int bRow, int rCol)
Returns the associatedXRange
of the specifiedXNSheet
and area.static SRange
SRanges. range(SSheet sheet, CellRegion region)
static SRange
SRanges. range(SSheet sheet, String areaReference)
static SRange
SRanges. rangeByName(SSheet sheet, String name)
Returns the associatedSRange
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 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)
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)
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)
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 void
AutoFillHelper. fill(SSheet sheet, CellRegion srcRegion, CellRegion dstRegion, SRange.FillType fillType)
fill the sheet, from srcRef to dstRefvoid
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 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 Description protected void
ExcelXlsxExporter. addPoiRule(SSheet sheet, org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCfRule ctRule, SConditionalFormattingRule rule)
void
AbstractExporter. export(SSheet sheet, OutputStream fos)
protected abstract void
AbstractExcelExporter. exportAutoFilter(SSheet sheet, Sheet poiSheet)
protected void
ExcelXlsExporter. exportAutoFilter(SSheet sheet, Sheet poiSheet)
protected void
ExcelXlsxExporter. exportAutoFilter(SSheet sheet, Sheet poiSheet)
See Javadoc atAbstractExcelImporter
importAutoFilter().protected abstract void
AbstractExcelExporter. exportChart(SSheet sheet, Sheet poiSheet)
protected void
ExcelXlsExporter. exportChart(SSheet sheet, Sheet poiSheet)
protected void
ExcelXlsxExporter. exportChart(SSheet sheet, Sheet poiSheet)
reference DrawingManagerImpl.addChartX()protected abstract void
AbstractExcelExporter. exportColumnArray(SSheet sheet, Sheet poiSheet, SColumnArray columnArr)
protected void
ExcelXlsExporter. exportColumnArray(SSheet sheet, Sheet poiSheet, SColumnArray columnArr)
protected void
ExcelXlsxExporter. exportColumnArray(SSheet sheet, Sheet poiSheet, SColumnArray columnArr)
protected abstract void
AbstractExcelExporter. exportConditionalFormatting(SSheet sheet, Sheet poiSheet)
protected void
ExcelXlsExporter. exportConditionalFormatting(SSheet sheet, Sheet poiSheet)
protected void
ExcelXlsxExporter. exportConditionalFormatting(SSheet sheet, Sheet poiSheet)
protected abstract void
AbstractExcelExporter. exportExtLst(SSheet sheet, Sheet poiSheet)
protected void
ExcelXlsExporter. exportExtLst(SSheet sheet, Sheet poiSheet)
protected void
ExcelXlsxExporter. exportExtLst(SSheet sheet, Sheet poiSheet)
protected void
AbstractExcelExporter. exportMergedRegions(SSheet sheet, Sheet poiSheet)
protected abstract void
AbstractExcelExporter. exportPassword(SSheet sheet, Sheet poiSheet)
protected void
ExcelXlsExporter. exportPassword(SSheet sheet, Sheet poiSheet)
Export hashed password directly to poiSheet.protected void
ExcelXlsxExporter. exportPassword(SSheet sheet, Sheet poiSheet)
Export hashed password directly to poiSheet.protected abstract void
AbstractExcelExporter. exportPicture(SSheet sheet, Sheet poiSheet)
protected void
ExcelXlsExporter. exportPicture(SSheet sheet, Sheet poiSheet)
protected void
ExcelXlsxExporter. exportPicture(SSheet sheet, Sheet poiSheet)
Reference DrawingManagerImpl.addPicture()protected void
AbstractExcelExporter. exportRow(SSheet sheet, Sheet poiSheet, SRow row)
protected void
AbstractExcelExporter. exportRowColumn(SSheet sheet, Sheet poiSheet)
protected void
ExcelXlsxExporter. exportRowColumn(SSheet sheet, Sheet poiSheet)
protected void
AbstractExcelExporter. exportSheet(SSheet sheet)
protected abstract void
AbstractExcelExporter. exportSheetPr(SSheet sheet, Sheet poiSheet)
protected void
ExcelXlsExporter. exportSheetPr(SSheet sheet, Sheet poiSheet)
protected void
ExcelXlsxExporter. exportSheetPr(SSheet sheet, Sheet poiSheet)
protected void
AbstractExcelExporter. exportSheetProtection(SSheet sheet, Sheet poiSheet)
POI SheetProtection.protected abstract int
AbstractExcelExporter. exportTables(SSheet sheet, Sheet poiSheet, int tbId)
protected int
ExcelXlsExporter. exportTables(SSheet sheet, Sheet poiSheet, int tbId)
protected int
ExcelXlsxExporter. exportTables(SSheet sheet, Sheet poiSheet0, int tbId)
protected abstract void
AbstractExcelExporter. exportValidation(SSheet sheet, Sheet poiSheet)
protected void
ExcelXlsExporter. exportValidation(SSheet sheet, Sheet poiSheet)
protected void
ExcelXlsxExporter. exportValidation(SSheet sheet, Sheet poiSheet)
According toSDataValidation.ValidationType
, FORMULA means custom validation.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
ExcelXlsImporter. importChart(List<HSSFChartShape> poiCharts, Sheet poiSheet, SSheet sheet)
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
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. importConditionalFormatting(SSheet sheet, Sheet poiSheet)
protected void
ExcelXlsImporter. importConditionalFormatting(SSheet sheet, Sheet poiSheet)
protected abstract void
AbstractExcelImporter. importDrawings(Sheet poiSheet, SSheet sheet)
Drawings includes charts and pictures.protected void
ExcelXlsImporter. importDrawings(Sheet poiSheet, SSheet sheet)
reference DrawingManagerImpl.initHSSFDrawings()protected void
AbstractExcelImporter. importMergedRegions(Sheet poiSheet, SSheet sheet)
protected abstract void
AbstractExcelImporter. importPassword(Sheet poiSheet, SSheet sheet)
protected void
ExcelXlsImporter. 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
AbstractExcelImporter. importSheetDefaultColumnWidth(Sheet poiSheet, SSheet sheet)
protected abstract void
AbstractExcelImporter. importSheetProtection(Sheet poiSheet, SSheet sheet)
POI SheetProtection.protected void
ExcelXlsImporter. importSheetProtection(Sheet poiSheet, SSheet sheet)
protected abstract void
AbstractExcelImporter. importTables(Sheet poiSheet, SSheet sheet)
POI sheet tablesprotected void
ExcelXlsImporter. importTables(Sheet poiSheet, SSheet sheet)
protected abstract void
AbstractExcelImporter. importValidation(Sheet poiSheet, SSheet sheet)
protected void
ExcelXlsImporter. importValidation(Sheet poiSheet, SSheet sheet)
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 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 sheetint
Spreadsheet. getSheetMaxVisibleRows(SSheet sheet)
Returns the max visible rows of the specified sheetvoid
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 thefromColumn to thetoColumn .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 SheetSSheet
HeaderUpdateEvent. 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 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 columnstatic String
CellFormatHelper. getCellHtmlText(SSheet sheet, int row, int column, FormatResult ft, SCellStyle tbStyle, SConditionalStyle cdStyle)
Gets Cell text by given row and columnString
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 handlingstatic String
CellFormatHelper. getRichCellHtmlText(SSheet sheet, int row, int column, FormatResult ft, SCellStyle tbStyle, SConditionalStyle cdStyle)
Gets Cell text by given row and column, it handlingstatic 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 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 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 cellString
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-selectedvoid
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 Constructor Description ChartsWidget(SSheet sheet, SChart chartInfo, String panel, int zindex)
ImageWidget(SSheet sheet, SPicture pic, String panel)
-