Uses of Class
org.apache.poi.ss.util.CellRangeAddress

Packages that use CellRangeAddress

Package	Description
org.apache.poi.hssf.converter
org.apache.poi.hssf.model	Provides low level API structures for reading, writing, modifying XLS files.
org.apache.poi.hssf.record	Record package contains class representations for XLS binary strutures.
org.apache.poi.hssf.record.aggregates	The record aggregates are not real "records" but collections of records that act as a single record.
org.apache.poi.hssf.record.common
org.apache.poi.hssf.usermodel	The usermodel package maps HSSF low level structures to familiar workbook/sheet model
org.apache.poi.ss.formula	This package contains common internal POI code for manipulating formulas.
org.apache.poi.ss.usermodel
org.apache.poi.ss.usermodel.helpers
org.apache.poi.ss.util
org.apache.poi.ss.util.cellwalk
org.apache.poi.xddf.usermodel.chart
org.apache.poi.xssf.streaming
org.apache.poi.xssf.usermodel

Uses of CellRangeAddress in org.apache.poi.hssf.converter

Methods in org.apache.poi.hssf.converter with parameters of type CellRangeAddress

Modifier and Type	Method	Description
protected int	ExcelToFoConverter.processRow(HSSFWorkbook workbook, CellRangeAddress[][] mergedRanges, HSSFRow row, Element tableRowElement)
protected int	ExcelToHtmlConverter.processRow(CellRangeAddress[][] mergedRanges, HSSFRow row, Element tableRowElement)

Uses of CellRangeAddress in org.apache.poi.hssf.model

Methods in org.apache.poi.hssf.model that return CellRangeAddress

Modifier and Type	Method	Description
CellRangeAddress	InternalSheet.getMergedRegionAt(int index)

Uses of CellRangeAddress in org.apache.poi.hssf.record

Methods in org.apache.poi.hssf.record that return CellRangeAddress

Modifier and Type	Method	Description
CellRangeAddress	MergeCellsRecord.getAreaAt(int index)
CellRangeAddress	CFHeader12Record.getAssociatedRange()
CellRangeAddress	CFRule12Record.getAssociatedRange()
CellRangeAddress[]	CFHeaderBase.getCellRanges()
CellRangeAddress[]	FeatRecord.getCellRefs()
CellRangeAddress	CFHeaderBase.getEnclosingCellRange()

Methods in org.apache.poi.hssf.record with parameters of type CellRangeAddress

Modifier and Type	Method	Description
void	CFHeaderBase.setCellRanges(CellRangeAddress[] cellRanges)	Set cell ranges list to a single cell range and modify the enclosing cell range accordingly.
void	FeatRecord.setCellRefs(CellRangeAddress[] cellRefs)
void	CFHeaderBase.setEnclosingCellRange(CellRangeAddress cr)

Constructors in org.apache.poi.hssf.record with parameters of type CellRangeAddress

Modifier	Constructor	Description
	CFHeader12Record(CellRangeAddress[] regions, int nRules)
protected	CFHeaderBase(CellRangeAddress[] regions, int nRules)
	CFHeaderRecord(CellRangeAddress[] regions, int nRules)
	MergeCellsRecord(CellRangeAddress[] regions, int startIndex, int numberOfRegions)

Uses of CellRangeAddress in org.apache.poi.hssf.record.aggregates

Methods in org.apache.poi.hssf.record.aggregates that return CellRangeAddress

Modifier and Type	Method	Description
CellRangeAddress	MergedCellsTable.get(int index)
CellRangeAddress	FormulaRecordAggregate.getArrayFormulaRange()
CellRangeAddress	FormulaRecordAggregate.removeArrayFormula(int rowIndex, int columnIndex)	Removes an array formula

Methods in org.apache.poi.hssf.record.aggregates with parameters of type CellRangeAddress

Modifier and Type	Method	Description
void	FormulaRecordAggregate.setArrayFormula(CellRangeAddress r, Ptg[] ptgs)

Constructors in org.apache.poi.hssf.record.aggregates with parameters of type CellRangeAddress

Modifier	Constructor	Description
	CFRecordsAggregate(CellRangeAddress[] regions, CFRuleBase[] rules)

Uses of CellRangeAddress in org.apache.poi.hssf.record.common

Methods in org.apache.poi.hssf.record.common that return CellRangeAddress

Modifier and Type	Method	Description
CellRangeAddress	FtrHeader.getAssociatedRange()
CellRangeAddress	FutureRecord.getAssociatedRange()

Methods in org.apache.poi.hssf.record.common with parameters of type CellRangeAddress

Modifier and Type	Method	Description
void	FtrHeader.setAssociatedRange(CellRangeAddress associatedRange)

Uses of CellRangeAddress in org.apache.poi.hssf.usermodel

Methods in org.apache.poi.hssf.usermodel that return CellRangeAddress

Modifier and Type	Method	Description
CellRangeAddress	HSSFCell.getArrayFormulaRange()
CellRangeAddress[]	HSSFConditionalFormatting.getFormattingRanges()
CellRangeAddress	HSSFSheet.getMergedRegion(int index)
CellRangeAddress	HSSFSheet.getRepeatingColumns()
CellRangeAddress	HSSFSheet.getRepeatingRows()

Methods in org.apache.poi.hssf.usermodel that return types with arguments of type CellRangeAddress

Modifier and Type	Method	Description
List<CellRangeAddress>	HSSFSheet.getMergedRegions()

Methods in org.apache.poi.hssf.usermodel with parameters of type CellRangeAddress

Modifier and Type	Method	Description
int	HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, HSSFConditionalFormattingRule rule1)
int	HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, HSSFConditionalFormattingRule[] cfRules)	Allows to add a new Conditional Formatting set to the sheet.
int	HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, HSSFConditionalFormattingRule rule1, HSSFConditionalFormattingRule rule2)
int	HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule rule1)
int	HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule[] cfRules)
int	HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule rule1, ConditionalFormattingRule rule2)
int	HSSFSheet.addMergedRegion(CellRangeAddress region)	Adds a merged region of cells on a sheet.
int	HSSFSheet.addMergedRegionUnsafe(CellRangeAddress region)	Adds a merged region of cells (hence those cells form one).
CellRange<HSSFCell>	HSSFSheet.setArrayFormula(String formula, CellRangeAddress range)
HSSFAutoFilter	HSSFSheet.setAutoFilter(CellRangeAddress range)
void	HSSFConditionalFormatting.setFormattingRanges(CellRangeAddress[] ranges)
void	HSSFSheet.setRepeatingColumns(CellRangeAddress columnRangeRef)
void	HSSFSheet.setRepeatingRows(CellRangeAddress rowRangeRef)

Uses of CellRangeAddress in org.apache.poi.ss.formula

Methods in org.apache.poi.ss.formula that return CellRangeAddress

Modifier and Type	Method	Description
CellRangeAddress	EvaluationCell.getArrayFormulaRange()
CellRangeAddress[]	EvaluationConditionalFormatRule.getRegions()

Constructors in org.apache.poi.ss.formula with parameters of type CellRangeAddress

Modifier	Constructor	Description
	EvaluationConditionalFormatRule(WorkbookEvaluator workbookEvaluator, Sheet sheet, ConditionalFormatting formatting, int formattingIndex, ConditionalFormattingRule rule, int ruleIndex, CellRangeAddress[] regions)

Uses of CellRangeAddress in org.apache.poi.ss.usermodel

Methods in org.apache.poi.ss.usermodel that return CellRangeAddress

Modifier and Type	Method	Description
CellRangeAddress	Cell.getArrayFormulaRange()	Only valid for array formula cells
CellRangeAddress[]	ConditionalFormatting.getFormattingRanges()
CellRangeAddress	Sheet.getMergedRegion(int index)	Returns the merged region at the specified index
CellRangeAddress	Sheet.getRepeatingColumns()	Gets the repeating columns used when printing the sheet, as found in File->PageSetup->Sheet.
CellRangeAddress	Sheet.getRepeatingRows()	Gets the repeating rows used when printing the sheet, as found in File->PageSetup->Sheet.

Methods in org.apache.poi.ss.usermodel that return types with arguments of type CellRangeAddress

Modifier and Type	Method	Description
List<CellRangeAddress>	Sheet.getMergedRegions()	Returns the list of merged regions.

Methods in org.apache.poi.ss.usermodel with parameters of type CellRangeAddress

Modifier and Type	Method	Description
int	SheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule rule)	Add a new Conditional Formatting to the sheet.
int	SheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule[] cfRules)	Add a new Conditional Formatting set to the sheet.
int	SheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule rule1, ConditionalFormattingRule rule2)	Add a new Conditional Formatting consisting of two rules.
int	Sheet.addMergedRegion(CellRangeAddress region)	Adds a merged region of cells (hence those cells form one)
int	Sheet.addMergedRegionUnsafe(CellRangeAddress region)	Adds a merged region of cells (hence those cells form one).
void	RangeCopier.copyRange(CellRangeAddress tilePatternRange, CellRangeAddress tileDestRange)	Uses input pattern to tile destination region, overwriting existing content.
void	RangeCopier.copyRange(CellRangeAddress tilePatternRange, CellRangeAddress tileDestRange, boolean copyStyles, boolean copyMergedRanges)	Uses input pattern to tile destination region, overwriting existing content.
CellRange<? extends Cell>	Sheet.setArrayFormula(String formula, CellRangeAddress range)	Sets array formula to specified region for result.
AutoFilter	Sheet.setAutoFilter(CellRangeAddress range)	Enable filtering for a range of cells
void	ConditionalFormatting.setFormattingRanges(CellRangeAddress[] ranges)	Sets the cell ranges the rule conditional formatting must be applied to.
void	Sheet.setRepeatingColumns(CellRangeAddress columnRangeRef)	Sets the repeating columns used when printing the sheet, as found in File->PageSetup->Sheet.
void	Sheet.setRepeatingRows(CellRangeAddress rowRangeRef)	Sets the repeating rows used when printing the sheet, as found in File->PageSetup->Sheet.

Uses of CellRangeAddress in org.apache.poi.ss.usermodel.helpers

Methods in org.apache.poi.ss.usermodel.helpers that return CellRangeAddress

Modifier and Type	Method	Description
static CellRangeAddress	BaseRowColShifter.shiftRange(FormulaShifter formulaShifter, CellRangeAddress cra, int currentExternSheetIx)

Methods in org.apache.poi.ss.usermodel.helpers that return types with arguments of type CellRangeAddress

Modifier and Type	Method	Description
abstract List<CellRangeAddress>	BaseRowColShifter.shiftMergedRegions(int start, int end, int n)	Shifts, grows, or shrinks the merged regions due to a row shift (RowShifter) or column shift (ColumnShifter).
List<CellRangeAddress>	ColumnShifter.shiftMergedRegions(int startColumn, int endColumn, int n)	Shifts, grows, or shrinks the merged regions due to a column shift.
List<CellRangeAddress>	RowShifter.shiftMergedRegions(int startRow, int endRow, int n)	Shifts, grows, or shrinks the merged regions due to a row shift.

Methods in org.apache.poi.ss.usermodel.helpers with parameters of type CellRangeAddress

Modifier and Type	Method	Description
static CellRangeAddress	BaseRowColShifter.shiftRange(FormulaShifter formulaShifter, CellRangeAddress cra, int currentExternSheetIx)

Uses of CellRangeAddress in org.apache.poi.ss.util

Fields in org.apache.poi.ss.util with type parameters of type CellRangeAddress

Modifier and Type	Field	Description
protected final List<CellRangeAddress>	CellRangeAddressList._list	List of CellRangeAddresses.

Methods in org.apache.poi.ss.util that return CellRangeAddress

Modifier and Type	Method	Description
CellRangeAddress	CellRangeAddress.copy()
static CellRangeAddress	CellRangeUtil.createEnclosingCellRange(CellRangeAddress crA, CellRangeAddress crB)	Create an enclosing CellRange for the two cell ranges.
CellRangeAddress	CellRangeAddressList.getCellRangeAddress(int index)
CellRangeAddress[]	CellRangeAddressList.getCellRangeAddresses()
static CellRangeAddress[]	CellRangeUtil.mergeCellRanges(CellRangeAddress[] cellRanges)	Do all possible cell merges between cells of the list so that: if a cell range is completely inside of another cell range, it gets removed from the list if two cells have a shared border, merge them into one bigger cell range
CellRangeAddress	CellRangeAddressList.remove(int rangeIndex)
CellRangeAddress	CellRangeAddress.shift(int rows, int columns)	Shifts cell range by specified number of rows and columns.
static CellRangeAddress	CellRangeAddress.valueOf(String ref)	Creates a CellRangeAddress from a cell range reference string.

Methods in org.apache.poi.ss.util that return types with arguments of type CellRangeAddress

Modifier and Type	Method	Description
List<CellRangeAddress>	CellRangeAddressList.getGenericChildren()

Methods in org.apache.poi.ss.util with parameters of type CellRangeAddress

Modifier and Type	Method	Description
void	CellRangeAddressList.addCellRangeAddress(CellRangeAddress cra)
static boolean	CellRangeUtil.contains(CellRangeAddress crA, CellRangeAddress crB)	Check if cell range A contains cell range B (B <= A) TODO: move this into CellRangeAddressBase
static CellRangeAddress	CellRangeUtil.createEnclosingCellRange(CellRangeAddress crA, CellRangeAddress crB)	Create an enclosing CellRange for the two cell ranges.
void	PropertyTemplate.drawBorderColors(CellRangeAddress range, short color, BorderExtent extent)	Sets the color for a group of cell borders for a cell range.
void	PropertyTemplate.drawBorders(CellRangeAddress range, BorderStyle borderType, short color, BorderExtent extent)	Draws a group of cell borders for a cell range.
void	PropertyTemplate.drawBorders(CellRangeAddress range, BorderStyle borderType, BorderExtent extent)	Draws a group of cell borders for a cell range.
static boolean	CellRangeUtil.hasExactSharedBorder(CellRangeAddress crA, CellRangeAddress crB)	Check if the two cell ranges have a shared border.
static int	CellRangeUtil.intersect(CellRangeAddress crA, CellRangeAddress crB)	Get the type of intersection between two cell ranges
static CellRangeAddress[]	CellRangeUtil.mergeCellRanges(CellRangeAddress[] cellRanges)	Do all possible cell merges between cells of the list so that: if a cell range is completely inside of another cell range, it gets removed from the list if two cells have a shared border, merge them into one bigger cell range
static void	RegionUtil.setBorderBottom(BorderStyle border, CellRangeAddress region, Sheet sheet)	Sets the bottom border style for a region of cells by manipulating the cell style of the individual cells on the bottom
static void	RegionUtil.setBorderLeft(BorderStyle border, CellRangeAddress region, Sheet sheet)	Sets the left border style for a region of cells by manipulating the cell style of the individual cells on the left
static void	RegionUtil.setBorderRight(BorderStyle border, CellRangeAddress region, Sheet sheet)	Sets the right border style for a region of cells by manipulating the cell style of the individual cells on the right
static void	RegionUtil.setBorderTop(BorderStyle border, CellRangeAddress region, Sheet sheet)	Sets the top border style for a region of cells by manipulating the cell style of the individual cells on the top
static void	RegionUtil.setBottomBorderColor(int color, CellRangeAddress region, Sheet sheet)	Sets the bottom border color for a region of cells by manipulating the cell style of the individual cells on the bottom
static void	RegionUtil.setLeftBorderColor(int color, CellRangeAddress region, Sheet sheet)	Sets the left border color for a region of cells by manipulating the cell style of the individual cells on the left
static void	RegionUtil.setRightBorderColor(int color, CellRangeAddress region, Sheet sheet)	Sets the right border color for a region of cells by manipulating the cell style of the individual cells on the right
static void	RegionUtil.setTopBorderColor(int color, CellRangeAddress region, Sheet sheet)	Sets the top border color for a region of cells by manipulating the cell style of the individual cells on the top

Method parameters in org.apache.poi.ss.util with type arguments of type CellRangeAddress

Modifier and Type	Method	Description
static double	SheetUtil.getCellWidth(Cell cell, float defaultCharWidth, DataFormatter formatter, boolean useMergedCells, List<CellRangeAddress> mergedRegions)	Compute width of a single cell This method receives the list of merged regions as querying it from the cell/sheet is time-consuming and thus caching the list across cells speeds up certain operations considerably.
static double	SheetUtil.getCellWidth(Cell cell, int defaultCharWidth, DataFormatter formatter, boolean useMergedCells, List<CellRangeAddress> mergedRegions)	Deprecated. since POI 5.2.5, it is better to pass defaultCharWidth as a float

Uses of CellRangeAddress in org.apache.poi.ss.util.cellwalk

Constructors in org.apache.poi.ss.util.cellwalk with parameters of type CellRangeAddress

Modifier	Constructor	Description
	CellWalk(Sheet sheet, CellRangeAddress range)

Uses of CellRangeAddress in org.apache.poi.xddf.usermodel.chart

Methods in org.apache.poi.xddf.usermodel.chart with parameters of type CellRangeAddress

Modifier and Type	Method	Description
String	XDDFChart.formatRange(CellRangeAddress range)
static XDDFNumericalDataSource<Double>	XDDFDataSourcesFactory.fromNumericCellRange(XSSFSheet sheet, CellRangeAddress cellRangeAddress)
static XDDFCategoryDataSource	XDDFDataSourcesFactory.fromStringCellRange(XSSFSheet sheet, CellRangeAddress cellRangeAddress)

Uses of CellRangeAddress in org.apache.poi.xssf.streaming

Methods in org.apache.poi.xssf.streaming that return CellRangeAddress

Modifier and Type	Method	Description
CellRangeAddress	SXSSFCell.getArrayFormulaRange()	Only valid for array formula cells
CellRangeAddress	SXSSFSheet.getMergedRegion(int index)	Returns the merged region at the specified index.
CellRangeAddress	SXSSFSheet.getRepeatingColumns()
CellRangeAddress	SXSSFSheet.getRepeatingRows()

Methods in org.apache.poi.xssf.streaming that return types with arguments of type CellRangeAddress

Modifier and Type	Method	Description
List<CellRangeAddress>	SXSSFSheet.getMergedRegions()	Returns the list of merged regions.

Methods in org.apache.poi.xssf.streaming with parameters of type CellRangeAddress

Modifier and Type	Method	Description
int	SXSSFSheet.addMergedRegion(CellRangeAddress region)	Adds a merged region of cells (hence those cells form one)
int	SXSSFSheet.addMergedRegionUnsafe(CellRangeAddress region)	Adds a merged region of cells (hence those cells form one)
CellRange<? extends Cell>	SXSSFSheet.setArrayFormula(String formula, CellRangeAddress range)	Sets array formula to specified region for result.
AutoFilter	SXSSFSheet.setAutoFilter(CellRangeAddress range)	Enable filtering for a range of cells
void	SXSSFSheet.setRepeatingColumns(CellRangeAddress columnRangeRef)
void	SXSSFSheet.setRepeatingRows(CellRangeAddress rowRangeRef)

Uses of CellRangeAddress in org.apache.poi.xssf.usermodel

Methods in org.apache.poi.xssf.usermodel that return CellRangeAddress

Modifier and Type	Method	Description
CellRangeAddress	XSSFCell.getArrayFormulaRange()
CellRangeAddress	XSSFSheet.getDimension()	Reads the dimensions of the sheet data
CellRangeAddress[]	XSSFConditionalFormatting.getFormattingRanges()
CellRangeAddress	XSSFSheet.getMergedRegion(int index)	Returns the merged region at the specified index.
CellRangeAddress	XSSFSheet.getRepeatingColumns()
CellRangeAddress	XSSFSheet.getRepeatingRows()

Methods in org.apache.poi.xssf.usermodel that return types with arguments of type CellRangeAddress

Modifier and Type	Method	Description
Map<IgnoredErrorType,Set<CellRangeAddress>>	XSSFSheet.getIgnoredErrors()	Returns the errors currently being ignored and the ranges where they are ignored.
List<CellRangeAddress>	XSSFSheet.getMergedRegions()	Returns the list of merged regions.

Methods in org.apache.poi.xssf.usermodel with parameters of type CellRangeAddress

Modifier and Type	Method	Description
int	XSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule rule1)
int	XSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule[] cfRules)
int	XSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule rule1, ConditionalFormattingRule rule2)
void	XSSFSheet.addIgnoredErrors(CellRangeAddress region, IgnoredErrorType... ignoredErrorTypes)	Ignore errors across a range of cells.
int	XSSFSheet.addMergedRegion(CellRangeAddress region)	Adds a merged region of cells on a sheet.
int	XSSFSheet.addMergedRegionUnsafe(CellRangeAddress region)	Adds a merged region of cells (hence those cells form one).
CellRange<XSSFCell>	XSSFSheet.setArrayFormula(String formula, CellRangeAddress range)
XSSFAutoFilter	XSSFSheet.setAutoFilter(CellRangeAddress range)
void	XSSFSheet.setDimensionOverride(CellRangeAddress dimension)	Currently, this is for internal use.
void	XSSFConditionalFormatting.setFormattingRanges(CellRangeAddress[] ranges)
void	XSSFSheet.setRepeatingColumns(CellRangeAddress columnRangeRef)
void	XSSFSheet.setRepeatingRows(CellRangeAddress rowRangeRef)