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.undo	Classes that doing system undoable action control on Keikai Spreadsheet UI Components.

Uses of CellRegion in io.keikai.api

Methods in io.keikai.api that return CellRegion

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

Methods in io.keikai.model that return CellRegion

Modifier and Type	Method and Description
CellRegion	CellRegion.cloneCellRegion()
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	SheetRegion.getRegion()
CellRegion	SAutoFilter.getRegion() Returns the filtered Region.
CellRegion	ModelEvent.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

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

Modifier and Type	Method and Description
List<CellRegion>	CellRegion.diff(CellRegion target)
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>	SDataValidation.getRegions()
Collection<CellRegion>	SConditionalFormattingRule.getRegions() Get applied regions.
Set<CellRegion>	SConditionalFormatting.getRegions() Regions that this conditional formatting covered

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

Modifier and Type	Method and 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	SDataValidation.addRegion(CellRegion region)
void	SConditionalFormatting.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.removeDataValidationRegion(CellRegion region) Deprecated.
void	SSheet.removeMergedRegion(CellRegion region, boolean removeOverlaps) Remove the merged area that are contained by region
void	SDataValidation.removeRegion(CellRegion region)
void	SConditionalFormatting.removeRegion(CellRegion region) Remove partial region in the ConditionalFormatting

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

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

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

Constructor and 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 and Description
CellRegion	SheetImpl.checkMergedRegion(CellRegion region)
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	SheetImpl.pasteCell(SheetRegion src, CellRegion dest, PasteOption option)
CellRegion	PasteCellHelper.pasteCell(SheetRegion src, CellRegion dest, PasteOption option)

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

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

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

Modifier and Type	Method and Description
SConditionalFormatting	SheetImpl.addConditionalFormatting(CellRegion srcrgn, CellRegion dstrgn, SConditionalFormatting src, int rowOff, int colOff)
abstract SConditionalFormatting	AbstractSheetAdv.addConditionalFormatting(CellRegion srcrgn, CellRegion dstrgn, SConditionalFormatting src, int rowOff, int colOff) Paste from src a new ConditionalFormatting at the specified region.
SDataValidation	SheetImpl.addDataValidation(CellRegion region)
SDataValidation	SheetImpl.addDataValidation(CellRegion region, SDataValidation src)
void	SheetImpl.addDirectlyMergedRegion(CellRegion region)
void	SheetImpl.addMergedRegion(CellRegion region)
void	DataValidationImpl.addRegion(CellRegion region)
void	ConditionalFormattingImpl.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)
List<SConditionalFormatting>	SheetImpl.deleteConditionalFormattingRegion(CellRegion region)
abstract List<SConditionalFormatting>	AbstractSheetAdv.deleteConditionalFormattingRegion(CellRegion region) Delete a region from conditional formatting and return the deleted conditional formatting.
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	SheetImpl.pasteCell(SheetRegion src, CellRegion dest, PasteOption option)
CellRegion	PasteCellHelper.pasteCell(SheetRegion src, CellRegion dest, PasteOption option)
void	SheetImpl.removeConditionalFormattingRegion(CellRegion region)
abstract void	AbstractSheetAdv.removeConditionalFormattingRegion(CellRegion region) Remove a region from conditional formatting.
void	SheetImpl.removeDataValidationRegion(CellRegion region)
void	SheetImpl.removeMergedRegion(CellRegion region, boolean removeOverlaps)
void	DataValidationImpl.removeRegion(CellRegion region)
void	ConditionalFormattingImpl.removeRegion(CellRegion region)

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

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

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

Constructor and 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 and 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 and Description
protected TreeSet<CellRegion>	PdfExporter._extendRegions

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

Modifier and Type	Method and 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 and 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 and 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 and 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 and Description
CellRegion	DataRegionHelper.findAutoFilterDataRegion()
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 and 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 and 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 and Description
void	AutoFillHelper.fill(SSheet sheet, CellRegion srcRegion, CellRegion dstRegion, SRange.FillType fillType) fill the sheet, from srcRef to dstRef
void	AutoFillHelper.fillDown(SSheet sheet, CellRegion srcRef, CellRegion dstRef, SRange.FillType fillType)
void	AutoFillHelper.fillLeft(SSheet sheet, CellRegion srcRef, CellRegion dstRef, SRange.FillType fillType)
void	AutoFillHelper.fillRight(SSheet sheet, CellRegion srcRef, CellRegion dstRef, SRange.FillType fillType)
void	AutoFillHelper.fillUp(SSheet sheet, CellRegion srcRef, CellRegion dstRef, SRange.FillType fillType)

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

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

Modifier and Type	Method and 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 and Description
protected boolean	AbstractUndoableAction.isAnyCellProtected(Sheet sheet, CellRegion cellRegion)
void	ReserveUtil.ReservedResult.setMergeInfo(CellRegion[] mergeInfo)