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.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.cf |
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.usermodel |
org.apache.poi.ss.usermodel.charts |
org.apache.poi.ss.util |
org.apache.poi.ss.util.cellwalk |

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[]` | `CFHeaderRecord.getCellRanges()`
`CellRangeAddress[]` | `FeatRecord.getCellRefs()`
`CellRangeAddress` | `CFHeaderRecord.getEnclosingCellRange()`

Methods in org.apache.poi.hssf.record with parameters of type CellRangeAddress
`void` | `CFHeaderRecord.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` | `CFHeaderRecord.setEnclosingCellRange(CellRangeAddress cr)`

Constructors in org.apache.poi.hssf.record with parameters of type CellRangeAddress
`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, CFRuleRecord[] rules)`

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

Methods in org.apache.poi.hssf.record.cf that return CellRangeAddress
`static CellRangeAddress` | `CellRangeUtil.createEnclosingCellRange(CellRangeAddress crA, CellRangeAddress crB)` Create an enclosing CellRange for the 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

Methods in org.apache.poi.hssf.record.cf with parameters of type CellRangeAddress
`static boolean` | `CellRangeUtil.contains(CellRangeAddress crA, CellRangeAddress crB)` Check if the specified range is located inside of this cell range.
`static CellRangeAddress` | `CellRangeUtil.createEnclosingCellRange(CellRangeAddress crA, CellRangeAddress crB)` Create an enclosing CellRange for the two cell ranges.
`static boolean` | `CellRangeUtil.hasExactSharedBorder(CellRangeAddress crA, CellRangeAddress crB)` Check if the specified cell range has a shared border with the current range.
`static int` | `CellRangeUtil.intersect(CellRangeAddress crA, CellRangeAddress crB)` Intersect this range with the specified range.
`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

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

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 (hence those cells form one)
`CellRange` | `HSSFSheet.setArrayFormula(java.lang.String formula, CellRangeAddress range)`
`AutoFilter` | `HSSFSheet.setAutoFilter(CellRangeAddress range)`

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

Subclasses of CellRangeAddress in org.apache.poi.hssf.util
`class` | `CellRangeAddress` Deprecated. use `CellRangeAddress`

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

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)
`CellRange` | `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

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` | `DataSources.fromNumericCellRange(Sheet sheet, CellRangeAddress cellRangeAddress)`
`static ChartDataSource` | `DataSources.fromStringCellRange(Sheet sheet, CellRangeAddress cellRangeAddress)`

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

Methods in org.apache.poi.ss.util that return CellRangeAddress
`static CellRangeAddress[]` | `Region.convertRegionsToCellRanges(Region[] regions)` Deprecated.
`static CellRangeAddress` | `Region.convertToCellRangeAddress(Region r)` Deprecated.
`CellRangeAddress` | `CellRangeAddress.copy()`
`CellRangeAddress` | `CellRangeAddressList.getCellRangeAddress(int index)`
`CellRangeAddress[]` | `CellRangeAddressList.getCellRangeAddresses()`
`CellRangeAddress` | `CellRangeAddressList.remove(int rangeIndex)`
`static CellRangeAddress` | `CellRangeAddress.valueOf(java.lang.String ref)`

Methods in org.apache.poi.ss.util with parameters of type CellRangeAddress
`void` | `CellRangeAddressList.addCellRangeAddress(CellRangeAddress cra)`
`static boolean` | `SheetUtil.containsCell(CellRangeAddress cr, int rowIx, int colIx)`
`static Region[]` | `Region.convertCellRangesToRegions(CellRangeAddress[] cellRanges)` Deprecated. Convert a List of CellRange objects to an array of regions
`static void` | `RegionUtil.setBorderBottom(int border, CellRangeAddress region, Sheet sheet, Workbook workbook)` Sets the borderBottom attribute of the RegionUtil object
`static void` | `RegionUtil.setBorderLeft(int border, CellRangeAddress region, Sheet sheet, Workbook workbook)` Sets the left border for a region of cells by manipulating the cell style of the individual cells on the left
`static void` | `RegionUtil.setBorderRight(int border, CellRangeAddress region, Sheet sheet, Workbook workbook)` Sets the borderRight attribute of the RegionUtil object
`static void` | `RegionUtil.setBorderTop(int border, CellRangeAddress region, Sheet sheet, Workbook workbook)` Sets the borderBottom attribute of the RegionUtil object
`static void` | `RegionUtil.setBottomBorderColor(int color, CellRangeAddress region, Sheet sheet, Workbook workbook)` Sets the bottomBorderColor attribute of the RegionUtil object
`static void` | `RegionUtil.setLeftBorderColor(int color, CellRangeAddress region, Sheet sheet, Workbook workbook)` Sets the leftBorderColor attribute of the RegionUtil object
`static void` | `RegionUtil.setRightBorderColor(int color, CellRangeAddress region, Sheet sheet, Workbook workbook)` Sets the rightBorderColor attribute of the RegionUtil object
`static void` | `RegionUtil.setTopBorderColor(int color, CellRangeAddress region, Sheet sheet, Workbook workbook)` Sets the topBorderColor attribute of the RegionUtil object

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

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