Catalogen

CellRangeAddress @Cluster 2 (cellref0, col, row)

ThExtraerNotas.java

sets the

127. CellRangeAddress mergedRegion = getMergedRegion(srcSheet, srcRow.getRowNum(), (short)oldCell.getColumnIndex());     
131.   CellRangeAddress newMergedRegion = new CellRangeAddress(mergedRegion.getFirstRow()+deltaRows, mergedRegion.getLastRow()+deltaRows, mergedRegion.getFirstColumn(),  mergedRegion.getLastColumn());

JUniPrint.java

< p > sets the poi file ‘ s path . < / p >

825. CellRangeAddress cellReff = workR.getCellRangeAddress(0);
826. if(cellReff.getLastRow()-cellReff.getFirstRow()+1 != kFRowE){

JUniPrint.java

this method returns the font to be used to style the table . < p > it must be in the range [ 0 , 1 2 ] . @ return the

1335. CellRangeAddress workRange = l.getCellRangeAddress(ii);
1336. for(int row = workRange.getFirstRow(); row <= workRange.getLastRow(); row++)

ThExtraerNotas.java

returns true if the “ set “ of the table , value for 0 . < p > works 1 0 0 0 and 1 2 0 0 .

202. CellRangeAddress merged = sheet.getMergedRegion(i);     
203. if (merged.isInRange(rowNum, cellNum)) {

ExcelUtils.java

test that we get the same value as excel and , for

250. public static Boolean hasFormula (HSSFSheet sh, CellRangeAddress cRA){
253.   for(int row=cRA.getFirstRow(); row <= cRA.getLastRow(); row++){
256.       for(int col=cRA.getFirstColumn(); col <= cRA.getLastColumn(); col++){

SheetXSSFImplTest.java

tests that the create aggregate method correctly of an existing workbook with a @ throws illegalstateexception if the cell type returned by { @ link # getcelltypeenum ( ) } isn ‘ t { @ link celltype # formula }

33. CellRangeAddress rangeAddresses = cellRangeAddresses[0];
34. assertEquals(4,rangeAddresses.getFirstColumn());
35. assertEquals(4,rangeAddresses.getLastColumn());
36. assertEquals(11,rangeAddresses.getFirstRow());
37. assertEquals(11,rangeAddresses.getLastRow());

ExcelUtils.java

sets the list of colours that are interpolated between . the number must match { @ link # / _ or } , list of . @ param .

414. public static CellRangeAddress intersectRectangular(CellRangeAddress crA, CellRangeAddress crB){
415.   boolean isIntersect =  !( crB.getFirstColumn() > crA.getLastColumn()
416.               || crB.getLastColumn() < crA.getFirstColumn()
417.               || crB.getFirstRow() > crA.getLastRow()
418.               || crB.getLastRow() < crA.getFirstRow()
422.       new CellRangeAddress(Math.max(crA.getFirstRow(), crB.getFirstRow()), 
423.                  Math.min(crA.getLastRow(), crB.getLastRow()),
424.                  Math.max(crA.getFirstColumn(), crB.getFirstColumn()), 
425.                  Math.min(crA.getLastColumn(), crB.getLastColumn()));

ExcelUtils.java

the ( 0 based ) number of the column number .

414. public static CellRangeAddress intersectRectangular(CellRangeAddress crA, CellRangeAddress crB){
415.   boolean isIntersect =  !( crB.getFirstColumn() > crA.getLastColumn()
416.               || crB.getLastColumn() < crA.getFirstColumn()
417.               || crB.getFirstRow() > crA.getLastRow()
418.               || crB.getLastRow() < crA.getFirstRow()
422.       new CellRangeAddress(Math.max(crA.getFirstRow(), crB.getFirstRow()), 
423.                  Math.min(crA.getLastRow(), crB.getLastRow()),
424.                  Math.max(crA.getFirstColumn(), crB.getFirstColumn()), 
425.                  Math.min(crA.getLastColumn(), crB.getLastColumn()));