Uses of Class
io.keikai.model.CellRegion

Packages that use CellRegion

Package	Description
io.keikai.api	Keikai Spreadsheet API classes.
io.keikai.api.impl	Keikai Spreadsheet API implementation classes, internal use only
io.keikai.model	Keikai Spreadsheet Internal Book Model classes.
io.keikai.model.impl	Keikai Spreadsheet Internal Book Model Implementation classes.
io.keikai.model.impl.html	The exporter that convert Keikai Spreadsheet to HTML.
io.keikai.model.impl.pdf	The exporter that convert Keikai Spreadsheet to PDF.
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.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.widget	Classes used to implement extended Keikai Spreadsheet UI Component(implementation only).

Uses of CellRegion in io.keikai.api

Methods in io.keikai.api that return CellRegion

Modifier and Type	Method	Description
CellRegion	Range.getDataRegion()	Returns the region which contains data(including chart, picture, and fills) in the sheet of this Range; return null if empty sheet.
CellRegion	Range.getMergedRegion()	Returns the merged region of the left top cell of this Range if any; otherwise, returns null if not a merged region.

Uses of CellRegion in io.keikai.api.impl

Methods in io.keikai.api.impl that return CellRegion

Modifier and Type	Method	Description
CellRegion	RangeImpl.getDataRegion()
CellRegion	RangeImpl.getMergedRegion()

Uses of CellRegion in io.keikai.model

Subclasses of CellRegion in io.keikai.model

Modifier and Type	Class	Description
class	PasteCellRegion

Methods in io.keikai.model that return CellRegion

Modifier and Type	Method	Description
CellRegion	CellRegion.cloneCellRegion()
CellRegion	SCell.getArrayFormulaRegion()	Only valid for array formula cells
CellRegion	SSheet.getCellRegionInArrayFormula(SCell cell)	Returns the cell regin if the given cell is in an array formula.
CellRegion	SSheet.getDataRegion()	Returns the region which contains data(including chart, picture, and fills) in this sheet; return null if empty sheet.
CellRegion	SSheet.getMergedRegion(int idx)
CellRegion	SSheet.getMergedRegion(int row, int column)
CellRegion	SSheet.getMergedRegion(String cellRefString)
CellRegion	CellRegion.getOverlap(CellRegion target)
CellRegion	SName.getRefersToCellRegion()
CellRegion	ModelEvent.getRegion()
CellRegion	SAutoFilter.getRegion()	Returns the filtered Region.
CellRegion	SheetRegion.getRegion()
CellRegion	SPrintSetup.getRepeatingColumnsTitle()
CellRegion	SPrintSetup.getRepeatingRowsTitle()
CellRegion	CellRegion.intersect(CellRegion target)
CellRegion	SSheet.pasteCell(SheetRegion src, CellRegion dest, PasteOption option)	paste cell from src sheet to this sheet, the sheets must in same book
CellRegion	SSheet.removeArrayFormula(SCell cell)	Remove an Array Formula from this sheet.
CellRegion	SSheet.setArrayFormula(String formula, CellRegion region)	Sets array formula to specified region for result.

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

Modifier and Type	Method	Description
List<CellRegion>	CellRegion.diff(CellRegion target)
List<CellRegion>	SSheet.getAllArrayFormulas()	Returns all cell regions of array formula in the given sheet
List<CellRegion>	SSheet.getContainsMergedRegions(CellRegion region)	Get the merged region that are contained by region.
List<CellRegion>	SSheet.getMergedRegions()
List<CellRegion>	SSheet.getOverlapsMergedRegions(CellRegion region, boolean excludeContains)	Get the merged region that overlapped the region
Set<CellRegion>	SConditionalFormatting.getRegions()	Regions that this conditional formatting covered
Collection<CellRegion>	SConditionalFormattingRule.getRegions()	Get applied regions.
Set<CellRegion>	SDataValidation.getRegions()

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

Modifier and Type	Method	Description
SDataValidation	SSheet.addDataValidation(CellRegion region)
SDataValidation	SSheet.addDataValidation(CellRegion region, SDataValidation src)
void	SSheet.addMergedRegion(CellRegion region)	Add a merged area, you can't assign a area that overlaps existed merged area.
void	SConditionalFormatting.addRegion(CellRegion region)
void	SDataValidation.addRegion(CellRegion region)
void	SSheet.clearCell(CellRegion region)	Clear cells in specified region
boolean	CellRegion.contains(CellRegion region)
SAutoFilter	SSheet.createAutoFilter(CellRegion region)	Creates a new auto filter, the old one will be drop directly.
static ModelEvent	ModelEvents.createModelEvent(String name, SSheet sheet, CellRegion region)
static ModelEvent	ModelEvents.createModelEvent(String name, SSheet sheet, CellRegion region, Map data)
void	SSheet.deleteCell(CellRegion region, boolean horizontal)	Delete a region of cells and shift existing cells.
List<SDataValidation>	SSheet.deleteDataValidationRegion(CellRegion region)	Delete data validations that are covered by the specified region.
List<CellRegion>	CellRegion.diff(CellRegion target)
List<CellRegion>	SSheet.getContainsMergedRegions(CellRegion region)	Get the merged region that are contained by region.
CellRegion	CellRegion.getOverlap(CellRegion target)
List<CellRegion>	SSheet.getOverlapsMergedRegions(CellRegion region, boolean excludeContains)	Get the merged region that overlapped the region
void	SSheet.insertCell(CellRegion region, boolean horizontal)	Insert a region of cells and shift existing cells.
CellRegion	CellRegion.intersect(CellRegion target)
void	SSheet.moveCell(CellRegion region, int rowOffset, int columnOffset)	Move one or more cells.
boolean	CellRegion.overlaps(CellRegion region)
CellRegion	SSheet.pasteCell(SheetRegion src, CellRegion dest, PasteOption option)	paste cell from src sheet to this sheet, the sheets must in same book
void	SSheet.removeMergedRegion(CellRegion region, boolean removeOverlaps)	Remove the merged area that are contained by region
void	SConditionalFormatting.removeRegion(CellRegion region)	Remove partial region in the ConditionalFormatting
void	SDataValidation.removeRegion(CellRegion region)
CellRegion	SSheet.setArrayFormula(String formula, CellRegion region)	Sets array formula to specified region for result.

Method parameters in io.keikai.model with type arguments of type CellRegion

Modifier and Type	Method	Description
void	SConditionalFormatting.setRegions(Set<CellRegion> regions)
void	SDataValidation.setRegions(Set<CellRegion> regions)

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

Constructor	Description
SheetRegion(SSheet sheet, CellRegion region)

Uses of CellRegion in io.keikai.model.impl

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

Modifier and Type	Method	Description
CellRegion	SheetImpl.checkMergedRegion(CellRegion region)
CellRegion	CellImpl.getArrayFormulaRegion()
CellRegion	SheetImpl.getCellRegionInArrayFormula(SCell cell)
CellRegion	SheetImpl.getDataRegion()
CellRegion	SheetImpl.getMergedRegion(int idx)
CellRegion	SheetImpl.getMergedRegion(int row, int column)
CellRegion	SheetImpl.getMergedRegion(String cellRef)
CellRegion	NameImpl.getRefersToCellRegion()
CellRegion	AutoFilterImpl.getRegion()
CellRegion	PrintSetupImpl.getRepeatingColumnsTitle()
CellRegion	PrintSetupImpl.getRepeatingRowsTitle()
CellRegion	PasteCellHelper.pasteCell(SheetRegion src, CellRegion dest, PasteOption option)
CellRegion	SheetImpl.pasteCell(SheetRegion src, CellRegion dest, PasteOption option)
CellRegion	SheetImpl.removeArrayFormula(SCell cell)
CellRegion	SheetImpl.setArrayFormula(String formula, CellRegion region)

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

Modifier and Type	Method	Description
abstract List<CellRegion>	AbstractSheetAdv.getAllArrayFormulas()
List<CellRegion>	SheetImpl.getAllArrayFormulas()
List<CellRegion>	SheetImpl.getContainsMergedRegions(CellRegion region)
List<CellRegion>	SheetImpl.getMergedRegions()
List<CellRegion>	SheetImpl.getOverlapsMergedRegions(CellRegion region, boolean excludeContains)
Set<CellRegion>	ConditionalFormattingImpl.getRegions()
Collection<CellRegion>	ConditionalFormattingRuleImpl.getRegions()
Set<CellRegion>	DataValidationImpl.getRegions()

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

Modifier and Type	Method	Description
abstract SConditionalFormatting	AbstractSheetAdv.addConditionalFormatting(CellRegion srcrgn, CellRegion dstrgn, SConditionalFormatting src, int rowOff, int colOff)	Paste from src a new ConditionalFormatting at the specified region.
SConditionalFormatting	SheetImpl.addConditionalFormatting(CellRegion srcrgn, CellRegion dstrgn, SConditionalFormatting src, int rowOff, int colOff)
SDataValidation	SheetImpl.addDataValidation(CellRegion region)
SDataValidation	SheetImpl.addDataValidation(CellRegion region, SDataValidation src)
void	SheetImpl.addDirectlyMergedRegion(CellRegion region)
void	SheetImpl.addMergedRegion(CellRegion region)
void	ConditionalFormattingImpl.addRegion(CellRegion region)
void	DataValidationImpl.addRegion(CellRegion region)
CellRegion	SheetImpl.checkMergedRegion(CellRegion region)
void	SheetImpl.clearCell(CellRegion region)
SAutoFilter	SheetImpl.createAutoFilter(CellRegion region)
void	SheetImpl.deleteCell(CellRegion region, boolean horizontal)
abstract List<SConditionalFormatting>	AbstractSheetAdv.deleteConditionalFormattingRegion(CellRegion region)	Delete a region from conditional formatting and return the deleted conditional formatting.
List<SConditionalFormatting>	SheetImpl.deleteConditionalFormattingRegion(CellRegion region)
List<SDataValidation>	SheetImpl.deleteDataValidationRegion(CellRegion region)
List<CellRegion>	SheetImpl.getContainsMergedRegions(CellRegion region)
List<CellRegion>	SheetImpl.getOverlapsMergedRegions(CellRegion region, boolean excludeContains)
void	SheetImpl.insertCell(CellRegion region, boolean horizontal)
void	SheetImpl.moveCell(CellRegion region, int rowOffset, int columnOffset)
CellRegion	PasteCellHelper.pasteCell(SheetRegion src, CellRegion dest, PasteOption option)
CellRegion	SheetImpl.pasteCell(SheetRegion src, CellRegion dest, PasteOption option)
abstract void	AbstractSheetAdv.removeConditionalFormattingRegion(CellRegion region)	Remove a region from conditional formatting.
void	SheetImpl.removeConditionalFormattingRegion(CellRegion region)
void	SheetImpl.removeMergedRegion(CellRegion region, boolean removeOverlaps)
void	ConditionalFormattingImpl.removeRegion(CellRegion region)
void	DataValidationImpl.removeRegion(CellRegion region)
CellRegion	SheetImpl.setArrayFormula(String formula, CellRegion region)

Method parameters in io.keikai.model.impl with type arguments of type CellRegion

Modifier and Type	Method	Description
void	ConditionalFormattingImpl.setRegions(Set<CellRegion> regions)
void	DataValidationImpl.setRegions(Set<CellRegion> regions)

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

Constructor	Description
AutoFilterImpl(CellRegion region)

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

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

Modifier and Type	Method	Description
static void	ToHtml.export(SSheet ws, CellRegion area, OutputStream outputStream)
static void	ToHtml.export(SSheet ws, CellRegion area, OutputStream outputStream, boolean noHeader)

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

Fields in io.keikai.model.impl.pdf with type parameters of type CellRegion

Modifier and Type	Field	Description
protected TreeSet<CellRegion>	PdfExporter._extendRegions

Methods in io.keikai.model.impl.pdf that return CellRegion

Modifier and Type	Method	Description
protected CellRegion	PdfExporter.getExtendRegion(int rowIdx, int colIdx)
protected CellRegion	PdfExporter.getMergedRegionIfAny(SSheet sheet, int rowIdx, int colIdx)	returns merged region cell range for a given cell
protected CellRegion[]	PdfExporter.getPrintAreas(SPrintSetup ps, SSheet sheet)
protected CellRegion	PdfExporter.splitRegionsInBoundaries(CellRegion region, int bRow, int eRow, int bCol, int eCol)

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

Modifier and Type	Method	Description
protected void	PdfExporter.addExtendRegion(CellRegion region)
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 void	PdfExporter.exportSheetSelection(SSheet sheet, int sheetIndex, CellRegion area, com.lowagie.text.Document doc)	converts POI SSheet to Pdf page(s)
protected io.keikai.model.impl.pdf.PixelInfo	PdfExporter.getPixelInfo(CellRegion clipRegion)
protected double	PdfExporter.getRegionHeight(CellRegion region)
protected double	PdfExporter.getRegionWidth(CellRegion region)
protected void	PdfExporter.initPrintArea(SSheet sheet, CellRegion region)	sets the column bounds for passed SSheet
protected io.keikai.model.impl.pdf.RenderInfo	PdfExporter.prepareClipInfo(CellRegion clipRegion)
protected io.keikai.model.impl.pdf.RenderInfo	PdfExporter.prepareRenderInfo(CellRegion clipRegion, CellRegion renderRegion, boolean extended, boolean number)
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.printImage(com.lowagie.text.pdf.PdfContentByte canvas, byte[] rawData, ViewAnchor anchor1, ViewAnchor anchor2, CellRegion clipRegion, CellRegion renderRegion, double pageColumnX, double pageRowY, double clipOffsetX, double clipOffsetY, boolean outline)
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 CellRegion	PdfExporter.splitRegionsInBoundaries(CellRegion region, int bRow, int eRow, int bCol, int eCol)

Uses of CellRegion in io.keikai.range

Methods in io.keikai.range that return CellRegion

Modifier and Type	Method	Description
CellRegion	SRange.getDataRegion()	Returns the region which contains data(including chart, picture, and fills) in the sheet of this Range; return null if empty sheet.
CellRegion	SRange.getMergedRegion()	Returns the merged region of the left top cell of this Range if any; otherwise, returns null if not a merged region.

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

Modifier and Type	Method	Description
static SRange	SRanges.range(SSheet sheet, CellRegion region)	Returns the associated SRange of the specified SSheet and cell-region

Uses of CellRegion in io.keikai.range.impl

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

Modifier and Type	Method	Description
CellRegion	DataRegionHelper.findAutoFilterDataRegion()
CellRegion	AutoFilterHelper.findAutoFilterRegion()
CellRegion	DataRegionHelper.findCustomSortRegion()
CellRegion	RangeImpl.getDataRegion()
CellRegion	MergeUpdate.getMerge()
CellRegion	RangeImpl.getMergedRegion()
CellRegion	MergeUpdate.getOrigMerge()

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

Modifier and Type	Method	Description
void	ModelUpdateCollector.addMergeChange(SSheet sheet, CellRegion original, CellRegion changeTo)
static boolean	DataRegionHelper.isOneCell(SSheet sheet, CellRegion rng)

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

Constructor	Description
MergeUpdate(SSheet sheet, CellRegion origMerge, CellRegion merge)
RangeImpl(SSheet sheet, CellRegion region)

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

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

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

Uses of CellRegion in io.keikai.ui.impl

Constructor parameters in io.keikai.ui.impl with type arguments of type CellRegion

Constructor	Description
MergeMatrixHelper(List<CellRegion> mergeRange, int frozenRow, int frozenCol)

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

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

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

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

Modifier and Type	Method	Description
protected boolean	AbstractUndoableAction.isAnyCellProtected(Sheet sheet, CellRegion cellRegion)
void	ReserveUtil.ReservedResult.setMergeInfo(CellRegion[] mergeInfo)

Uses of CellRegion in io.keikai.ui.sys

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

Modifier and Type	Method	Description
void	WidgetLoader.onResetSparklineAnchor(SSheet sheet, CellRegion region)
void	WidgetLoader.onRowColumnChange(SSheet sheet, CellRegion region)

Uses of CellRegion in io.keikaiex.ui.widget

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

Modifier and Type	Method	Description
void	DefaultBookWidgetLoader.onResetSparklineAnchor(SSheet sheet, CellRegion region)
void	DefaultBookWidgetLoader.onRowColumnChange(SSheet sheet, CellRegion region)