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.api.model	Keikai Spreadsheet Model API classes.
io.keikai.api.model.impl	Keikai Spreadsheet Model 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.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.

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

Modifier and Type	Method	Description
static Range	Ranges.range(Sheet sheet, CellRegion cellRegion)	Returns the associated Range of the specified Sheet and cell row and column.

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.api.model

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

Modifier and Type	Method	Description
void	Sheet.addCellRegionValueChangeListener(CellRegion cellRegion, SerializableConsumer<CellRegion> listener)	Adds the listener when specific cell region value change.
boolean	Sheet.removeCellRegionValueChangeListener(CellRegion cellRegion)	Remove all cell region value change listeners of specific cell region.

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

Modifier and Type	Method	Description
void	Sheet.addCellRegionValueChangeListener(CellRegion cellRegion, SerializableConsumer<CellRegion> listener)	Adds the listener when specific cell region value change.
boolean	Sheet.removeCellRegionValueChangeListener(SerializableConsumer<CellRegion> listener)	Remove the cell region value change listener.

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

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

Modifier and Type	Method	Description
void	SheetImpl.addCellRegionValueChangeListener(CellRegion cellRegion, SerializableConsumer<CellRegion> listener)
boolean	SheetImpl.removeCellRegionValueChangeListener(CellRegion cellRegion)

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

Modifier and Type	Method	Description
void	SheetImpl.addCellRegionValueChangeListener(CellRegion cellRegion, SerializableConsumer<CellRegion> listener)
boolean	SheetImpl.removeCellRegionValueChangeListener(SerializableConsumer<CellRegion> listener)

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()	Deprecated. since 7.0.0 — the name is ambiguous between CSE and DA.
default CellRegion	SCell.getArrayRegion()	Returns the full region of any array group containing this cell — either a legacy CSE array OR a dynamic-array spill — or null if the cell is not in any array.
CellRegion	SRevisionFormat.getCellRegion()	Returns the cell region affected by this format change.
CellRegion	SSheet.getCellRegionInArrayFormula(SCell cell)	Deprecated. since 7.0.0 — use SSheet.getCseRegion(SCell) for the clearer name.
default CellRegion	SCell.getCseRegion()	Returns the legacy CSE array region containing this cell, or null if the cell is not in a CSE region.
default CellRegion	SSheet.getCseRegion(SCell cell)	Returns the CSE region containing the given cell, or null if the cell is not in a CSE region.
CellRegion	SSheet.getDataRegion()	Returns the region which contains data(including chart, picture, and fills) in this sheet; return null if empty sheet.
CellRegion	SPivotTable.getLocation()	Returns the output location of this pivot table on the sheet.
CellRegion	SSheet.getMergedRegion(int idx)
CellRegion	SSheet.getMergedRegion(int row, int column)
CellRegion	SSheet.getMergedRegion(String cellRefString)
CellRegion	CellRegion.getOverlap(CellRegion target)
CellRegion	SProtectedRange.getRange()	Returns the cell region covered by this protected range.
CellRegion	SName.getRefersToCellRegion()
CellRegion	ModelEvent.getRegion()
CellRegion	SAutoFilter.getRegion()	Returns the filtered Region.
CellRegion	SheetRegion.getRegion()
CellRegion	SIgnoredError.getRegion()	Returns the cell region for which errors are ignored.
CellRegion	SRevisionInsertDelete.getRegion()	Returns the cell region affected by this insert/delete operation.
CellRegion	SPrintSetup.getRepeatingColumnsTitle()
CellRegion	SPrintSetup.getRepeatingRowsTitle()
CellRegion	SPivotCache.getSourceRange()	Returns the source data range.
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)	Deprecated. since 7.0.0 — use SSheet.removeCseArrayFormula(SCell) for the clearer name.
default CellRegion	SSheet.removeCseArrayFormula(SCell cell)	Removes a legacy CSE array formula from this sheet.
CellRegion	SSheet.setArrayFormula(String formula, CellRegion region)	Deprecated. since 7.0.0 — use SSheet.setCseArrayFormula(String, CellRegion) for the clearer name.
default CellRegion	SSheet.setCseArrayFormula(String formula, CellRegion region)	Installs a legacy CSE array formula in the specified region.

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()	Deprecated. since 7.0.0 — use SSheet.getAllCseRegions() for the clearer name.
default List<CellRegion>	SSheet.getAllCseRegions()	Returns the list of legacy CSE array regions registered on this sheet.
default List<CellRegion>	SSheet.getCellWatches()	Returns the list of cell watches on this sheet.
List<CellRegion>	SSheet.getContainsMergedRegions(CellRegion region)	Get the merged region that are contained by region.
default List<CellRegion>	SSheet.getCseRegionsInViewport(int top, int left, int bottom, int right)	Returns every legacy-CSE array region whose extent overlaps the inclusive viewport rectangle, for painting the array outline (the aflrs wire field).
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
void	SSheet.addCellRegionValueChangeListener(CellRegion cellRegion, SerializableConsumer<CellRegion> listener)	Adds the listener when specific cell region value change.
SDataValidation	SSheet.addDataValidation(CellRegion region)
SDataValidation	SSheet.addDataValidation(CellRegion region, SDataValidation src)
default void	SSheet.addIgnoredError(CellRegion range, ErrorCheckType... types)	Adds an ignored error for the specified cell region and error check types.
void	SSheet.addMergedRegion(CellRegion region)	Add a merged area, you can't assign a area that overlaps existed merged area.
default SPivotTable	SSheet.addPivotTable(String name, CellRegion sourceRange, CellRegion outputLocation)	Adds a new pivot table to this sheet.
default SProtectedRange	SSheet.addProtectedRange(String name, CellRegion range, String password)	Adds a protected range to this sheet.
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
boolean	SSheet.removeCellRegionValueChangeListener(CellRegion cellRegion)	Remove all cell region value change listeners of specific cell region.
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)	Deprecated. since 7.0.0 — use SSheet.setCseArrayFormula(String, CellRegion) for the clearer name.
default CellRegion	SSheet.setCseArrayFormula(String formula, CellRegion region)	Installs a legacy CSE array formula in the specified region.

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

Modifier and Type	Method	Description
void	SSheet.addCellRegionValueChangeListener(CellRegion cellRegion, SerializableConsumer<CellRegion> listener)	Adds the listener when specific cell region value change.
boolean	SSheet.removeCellRegionValueChangeListener(SerializableConsumer<CellRegion> listener)	Remove the cell region value change listener.
void	SConditionalFormatting.setRegions(Set<CellRegion> regions)
void	SDataValidation.setRegions(Set<CellRegion> regions)

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

Modifier	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	RevisionFormatImpl.getCellRegion()
CellRegion	PivotTableImpl.getLocation()
CellRegion	ProtectedRangeImpl.getRange()
CellRegion	NameImpl.getRefersToCellRegion()
CellRegion	AutoFilterImpl.getRegion()
CellRegion	IgnoredErrorImpl.getRegion()
CellRegion	RevisionInsertDeleteImpl.getRegion()
CellRegion	PrintSetupImpl.getRepeatingColumnsTitle()
CellRegion	PrintSetupImpl.getRepeatingRowsTitle()
CellRegion	PivotCacheImpl.getSourceRange()
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	Description
abstract List<CellRegion>	AbstractSheetAdv.getAllArrayFormulas()	Deprecated.
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
void	DataValidationIndex.add(AbstractDataValidationAdv dv, CellRegion region)
abstract SConditionalFormatting	AbstractSheetAdv.addConditionalFormatting(CellRegion srcrgn, CellRegion dstrgn, SConditionalFormatting src, int rowOff, int colOff)	Paste from src a new ConditionalFormatting at the specified region.
void	ConditionalFormattingImpl.addRegion(CellRegion region)
void	DataValidationImpl.addRegion(CellRegion region)
abstract List<SConditionalFormatting>	AbstractSheetAdv.deleteConditionalFormattingRegion(CellRegion region)	Delete a region from conditional formatting and return the deleted conditional formatting.
void	DataValidationIndex.forEachOverlapping(CellRegion region, Consumer<AbstractDataValidationAdv> visitor)	Visits every DV whose MBR overlaps the given region.
CellRegion	PasteCellHelper.pasteCell(SheetRegion src, CellRegion dest, PasteOption option)
void	DataValidationIndex.remove(AbstractDataValidationAdv dv, CellRegion region)
abstract void	AbstractSheetAdv.removeConditionalFormattingRegion(CellRegion region)	Remove a region from conditional formatting.
void	ConditionalFormattingImpl.removeRegion(CellRegion region)
void	DataValidationImpl.removeRegion(CellRegion region)
void	PivotTableImpl.setLocation(CellRegion location)
void	PivotCacheImpl.setSourceRange(CellRegion sourceRange)

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

Modifier	Constructor	Description
	AutoFilterImpl(CellRegion region)
	IgnoredErrorImpl(CellRegion region, ErrorCheckType... types)	Creates an ignored error for the given region with the specified types.
	IgnoredErrorImpl(CellRegion region, Set<ErrorCheckType> types)	Creates an ignored error for the given region with the specified set of types.
	PivotCacheImpl(String id, CellRegion sourceRange, String sourceSheetName)
	PivotTableImpl(String name, CellRegion location, SPivotCache cache)
	ProtectedRangeImpl(String name, CellRegion range, String passwordHash)	Convenience constructor without security descriptor.
	ProtectedRangeImpl(String name, CellRegion range, String passwordHash, String securityDescriptor)	Creates a new protected range.
	RevisionFormatImpl(long id, String author, Date timestamp, String sheetName, CellRegion cellRegion, String description)	Creates a new format change revision.
	RevisionInsertDeleteImpl(long id, RevisionType type, String author, Date timestamp, String sheetName, CellRegion region, boolean insert)	Creates a new insert/delete revision.

Uses of CellRegion in io.keikai.range

Methods in io.keikai.range that return CellRegion

Modifier and Type	Method	Description
CellRegion	SRange.find(String searchText, FindOptions options)	Finds the next cell matching the search text, starting after the top-left cell of this range.
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 that return types with arguments of type CellRegion

Modifier and Type	Method	Description
List<CellRegion>	SRange.findAll(String searchText, FindOptions options)	Finds all cells matching the search text in this range's sheet (or workbook, depending on options).

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

Modifier and Type	Method	Description
void	SRange.advancedFilter(AdvancedFilterAction action, CellRegion criteriaRange, CellRegion copyToRange, boolean unique)	Applies an advanced filter to this range using the specified criteria.
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	FindReplaceHelper.find(SSheet sheet, String searchText, FindOptions options, int startRow, int startCol)	Finds the next cell matching the search text, starting after the given position.
CellRegion	RangeImpl.find(String searchText, FindOptions options)
CellRegion	DataRegionHelper.findAutoFilterDataRegion()
CellRegion	AutoFilterHelper.findAutoFilterRegion()
CellRegion	DataRegionHelper.findCurrentRegion()	Returns the CurrentRegion — the contiguous non-blank block around the anchor cell — for the UI's Ctrl+A / Ctrl+Shift+Space, or null when the anchor has no surrounding non-blank cells.
CellRegion	DataRegionHelper.findCustomSortRegion()
CellRegion	RangeImpl.getDataRegion()
CellRegion	MergeUpdate.getMerge()
CellRegion	RangeImpl.getMergedRegion()
CellRegion	MergeUpdate.getOrigMerge()

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

Modifier and Type	Method	Description
List<CellRegion>	FindReplaceHelper.findAll(SSheet sheet, String searchText, FindOptions options)	Finds all cells matching the search text in the given sheet.
List<CellRegion>	RangeImpl.findAll(String searchText, FindOptions options)

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)
void	RangeImpl.advancedFilter(AdvancedFilterAction action, CellRegion criteriaRange, CellRegion copyToRange, boolean unique)
static void	AdvancedFilterHelper.applyAdvancedFilter(SSheet sheet, CellRegion dataRange, CellRegion criteriaRange, CellRegion copyToRange, boolean unique, AdvancedFilterAction action)	Applies the advanced filter to the given data range.
static void	SubtotalHelper.applySubtotal(SSheet sheet, CellRegion range, int groupByCol, SubtotalFunction function, int[] totalCols, boolean replace, boolean pageBreak, boolean summaryBelowData)	Applies subtotals to the specified range on the sheet.
static boolean	DataRegionHelper.isOneCell(SSheet sheet, CellRegion rng)

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

Modifier	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

Modifier	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)