Uses of Class
org.apache.poi.hssf.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.usermodel.contrib   
org.apache.poi.hssf.util util package contains tools needed for writing HSSF files that are not necesarily "real" HSSF concepts. 
 

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

Methods in org.apache.poi.hssf.model that return CellRangeAddress
 CellRangeAddress Sheet.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 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 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)
           
 

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[] HSSFConditionalFormatting.getFormattingRanges()
           
 CellRangeAddress HSSFSheet.getMergedRegion(int index)
           
 

Methods in org.apache.poi.hssf.usermodel with parameters of type CellRangeAddress
 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)
 

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

Methods in org.apache.poi.hssf.usermodel.contrib 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.hssf.util
 

Methods in org.apache.poi.hssf.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)
           
 

Methods in org.apache.poi.hssf.util with parameters of type CellRangeAddress
 void CellRangeAddressList.addCellRangeAddress(CellRangeAddress cra)
           
static Region[] Region.convertCellRangesToRegions(CellRangeAddress[] cellRanges)
          Deprecated. Convert a List of CellRange objects to an array of regions
 



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