Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES

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

Packages that use CellRangeAddress
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 | 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 | usermodel package maps HSSF low level strutures to familiar workbook/sheet model
org.apache.poi.hssf.util | util package contains tools needed for writing HSSF files that are not necesarily "real" HSSF concepts.
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.charts |
org.apache.poi.ss.usermodel.helpers |
org.apache.poi.ss.util |
org.apache.poi.ss.util.cellwalk |
org.apache.poi.xssf.streaming |
org.apache.poi.xssf.usermodel |
org.apache.poi.xssf.usermodel.helpers |

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

Methods in org.apache.poi.hssf.converter that return CellRangeAddress
`static CellRangeAddress[][]` | `ExcelToHtmlUtils.buildMergedRangesMap(HSSFSheet sheet)` Creates a map (i.e.
`static CellRangeAddress` | `AbstractExcelUtils.getMergedRange(CellRangeAddress[][] mergedRanges, int rowNumber, int columnNumber)`

Methods in org.apache.poi.hssf.converter with parameters of type CellRangeAddress
`static CellRangeAddress` | `AbstractExcelUtils.getMergedRange(CellRangeAddress[][] mergedRanges, int rowNumber, int columnNumber)`
`protected int` | `ExcelToHtmlConverter.processRow(CellRangeAddress[][] mergedRanges, HSSFRow row, org.w3c.dom.Element tableRowElement)`
`protected int` | `ExcelToFoConverter.processRow(HSSFWorkbook workbook, CellRangeAddress[][] mergedRanges, HSSFRow row, org.w3c.dom.Element tableRowElement)`

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

Methods in org.apache.poi.hssf.model that return CellRangeAddress
`CellRangeAddress` | `InternalSheet.getMergedRegionAt(int index)`

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

Methods in org.apache.poi.hssf.record that return CellRangeAddress
`CellRangeAddress` | `MergeCellsRecord.getAreaAt(int index)`
`CellRangeAddress` | `CFRule12Record.getAssociatedRange()`
`CellRangeAddress` | `CFHeader12Record.getAssociatedRange()`
`CellRangeAddress[]` | `CFHeaderBase.getCellRanges()`
`CellRangeAddress[]` | `FeatRecord.getCellRefs()`
`CellRangeAddress` | `CFHeaderBase.getEnclosingCellRange()`

Methods in org.apache.poi.hssf.record with parameters of type CellRangeAddress
`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
`CFHeader12Record(CellRangeAddress[] regions, int nRules)`
`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
`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
`void` | `FormulaRecordAggregate.setArrayFormula(CellRangeAddress r, Ptg[] ptgs)`

Constructors in org.apache.poi.hssf.record.aggregates with parameters of type CellRangeAddress
`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
`CellRangeAddress` | `FutureRecord.getAssociatedRange()`
`CellRangeAddress` | `FtrHeader.getAssociatedRange()`

Methods in org.apache.poi.hssf.record.common with parameters of type CellRangeAddress
`void` | `FtrHeader.setAssociatedRange(CellRangeAddress associatedRange)`

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

Methods in org.apache.poi.hssf.usermodel that return CellRangeAddress
`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
`java.util.List<CellRangeAddress>` | `HSSFSheet.getMergedRegions()`

Methods in org.apache.poi.hssf.usermodel with parameters of type CellRangeAddress
`int` | `HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule rule1)`
`int` | `HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule[] cfRules)`
`int` | `HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule rule1, ConditionalFormattingRule rule2)`
`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` | `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(java.lang.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.hssf.util

Methods in org.apache.poi.hssf.util with parameters of type CellRangeAddress
`static void` | `HSSFRegionUtil.setBorderBottom(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the borderBottom attribute of the HSSFRegionUtil object
`static void` | `HSSFRegionUtil.setBorderLeft(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the left border for a region of cells by manipulating the cell style of the individual cells on the left
`static void` | `HSSFRegionUtil.setBorderRight(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the borderRight attribute of the HSSFRegionUtil object
`static void` | `HSSFRegionUtil.setBorderTop(int border, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the borderBottom attribute of the HSSFRegionUtil object
`static void` | `HSSFRegionUtil.setBottomBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the bottomBorderColor attribute of the HSSFRegionUtil object
`static void` | `HSSFRegionUtil.setLeftBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the leftBorderColor attribute of the HSSFRegionUtil object
`static void` | `HSSFRegionUtil.setRightBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the rightBorderColor attribute of the HSSFRegionUtil object
`static void` | `HSSFRegionUtil.setTopBorderColor(int color, CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook)` Sets the topBorderColor attribute of the HSSFRegionUtil object

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

Methods in org.apache.poi.ss.formula that return CellRangeAddress
`CellRangeAddress[]` | `EvaluationConditionalFormatRule.getRegions()`

Constructors in org.apache.poi.ss.formula with parameters of type CellRangeAddress
`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
`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
`java.util.List<CellRangeAddress>` | `Sheet.getMergedRegions()` Returns the list of merged regions.

Methods in org.apache.poi.ss.usermodel with parameters of type CellRangeAddress
`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).
`CellRange<? extends Cell>` | `Sheet.setArrayFormula(java.lang.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.charts

Methods in org.apache.poi.ss.usermodel.charts with parameters of type CellRangeAddress
`static ChartDataSource<java.lang.Number>` | `DataSources.fromNumericCellRange(Sheet sheet, CellRangeAddress cellRangeAddress)`
`static ChartDataSource<java.lang.String>` | `DataSources.fromStringCellRange(Sheet sheet, CellRangeAddress cellRangeAddress)`

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

Methods in org.apache.poi.ss.usermodel.helpers that return types with arguments of type CellRangeAddress
`java.util.List<CellRangeAddress>` | `RowShifter.shiftMergedRegions(int startRow, int endRow, int n)` Shifts, grows, or shrinks the merged regions due to a row shift.

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

Fields in org.apache.poi.ss.util with type parameters of type CellRangeAddress
`protected java.util.List<CellRangeAddress>` | `CellRangeAddressList._list` List of `CellRangeAddress`es.

Methods in org.apache.poi.ss.util that return CellRangeAddress
`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)`
`static CellRangeAddress` | `CellRangeAddress.valueOf(java.lang.String ref)` Creates a CellRangeAddress from a cell range reference string.

Methods in org.apache.poi.ss.util with parameters of type CellRangeAddress
`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 boolean` | `SheetUtil.containsCell(CellRangeAddress cr, int rowIx, int colIx)` Deprecated. 3.15 beta 2. Use `CellRangeAddressBase.isInRange(int, int)`.
`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, BorderExtent extent)` Draws 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.
`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.setBorderBottom(int border, CellRangeAddress region, Sheet sheet)` Deprecated. POI 3.16 beta 1. Use `RegionUtil.setBorderBottom(BorderStyle, CellRangeAddress, Sheet)`.
`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.setBorderLeft(int border, CellRangeAddress region, Sheet sheet)` Deprecated. 3.16 beta 1. Use `RegionUtil.setBorderLeft(BorderStyle, CellRangeAddress, Sheet)`.
`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.setBorderRight(int border, CellRangeAddress region, Sheet sheet)` Deprecated. POI 3.16 beta 1. Use `RegionUtil.setBorderRight(BorderStyle, CellRangeAddress, Sheet)`.
`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.setBorderTop(int border, CellRangeAddress region, Sheet sheet)` Deprecated. 3.16 beta 1. Use `RegionUtil.setBorderTop(BorderStyle, CellRangeAddress, Sheet)`.
`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

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

Constructors in org.apache.poi.ss.util.cellwalk with parameters of type CellRangeAddress
`CellWalk(Sheet sheet, CellRangeAddress range)`

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

Methods in org.apache.poi.xssf.streaming that return CellRangeAddress
`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
`java.util.List<CellRangeAddress>` | `SXSSFSheet.getMergedRegions()` Returns the list of merged regions.

Methods in org.apache.poi.xssf.streaming with parameters of type CellRangeAddress
`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(java.lang.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
`CellRangeAddress` | `XSSFCell.getArrayFormulaRange()`
`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
`java.util.Map<IgnoredErrorType,java.util.Set<CellRangeAddress>>` | `XSSFSheet.getIgnoredErrors()` Returns the errors currently being ignored and the ranges where they are ignored.
`java.util.List<CellRangeAddress>` | `XSSFSheet.getMergedRegions()` Returns the list of merged regions.

Methods in org.apache.poi.xssf.usermodel with parameters of type CellRangeAddress
`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(java.lang.String formula, CellRangeAddress range)`
`XSSFAutoFilter` | `XSSFSheet.setAutoFilter(CellRangeAddress range)`
`void` | `XSSFConditionalFormatting.setFormattingRanges(CellRangeAddress[] ranges)`
`void` | `XSSFSheet.setRepeatingColumns(CellRangeAddress columnRangeRef)`
`void` | `XSSFSheet.setRepeatingRows(CellRangeAddress rowRangeRef)`

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

Methods in org.apache.poi.xssf.usermodel.helpers that return types with arguments of type CellRangeAddress
`java.util.List<CellRangeAddress>` | `XSSFRowShifter.shiftMerged(int startRow, int endRow, int n)` Deprecated. POI 3.15 beta 2. Use `RowShifter.shiftMergedRegions(int, int, int)` instead.

Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES

Copyright 2017 The Apache Software Foundation or its licensors, as applicable.