sets the
96. AreaReference paramCellAreaRef = new AreaReference(paramCellName.getRefersToFormula());
97. CellReference paramCellAreaRefFirstCell = paramCellAreaRef.getFirstCell();sets the as workbook style - either default and a for the 3 2 7 .
556. AreaReference areaReferance = new AreaReference("A"+(wRow+1)+":A"+(ExcelUtils.getReferanceNameRange(nameDataRangeE).getFirstCell().getRow()));
557. for(CellReference celRef:areaReferance.getAllReferencedCells()){sets the
78. AreaReference aref = new AreaReference(aNamedCell.getRefersToFormula());
79. CellReference[] crefs = aref.getAllReferencedCells();sets the
34. AreaReference areaReference = new AreaReference(formula);
35. CellReference firstCellReference = areaReference.getFirstCell();
36. CellReference lastCellReference = areaReference.getLastCell();build a file with the given name . @ param name the name to search ( case - insensitive ) @ param { @ code true } if the { @ link file } does not have a formula the result of the type .
244. public static Boolean hasFormula (HSSFSheet sh, AreaReference areaRef){
245. return hasFormula(sh, new CellRangeAddress(areaRef.getFirstCell().getRow(), areaRef.getLastCell().getRow(),
246. areaRef.getFirstCell().getCol(), areaRef.getLastCell().getCol()));sets the
40. AreaReference areaReference = new AreaReference(formula);
41. CellReference firstCellReference = areaReference.getFirstCell();
42. CellReference lastCellReference = areaReference.getLastCell();sets the
291. AreaReference areaReference = new AreaReference(formula);
292. CellReference firstCellReference = areaReference
294. CellReference lastCellReference = areaReferencesets the
1354. for(AreaReference area:hideFewRow){
1356. area.getFirstCell().getRow(), area.getLastCell().getRow(),
1357. area.getFirstCell().getCol(), area.getLastCell().getCol());sets the
1325. for(AreaReference area:hideOneRow){
1327. area.getFirstCell().getRow(), area.getLastCell().getRow(),
1328. area.getFirstCell().getCol(), area.getLastCell().getCol()), crB);sets the and empty string of the given paragraph ( not data ) @ param
160. private Object[][] getAreaValueArray(AreaReference ar) {
161. int cols = Math.abs(ar.getFirstCell().getCol() - ar.getLastCell().getCol()) + 1;
162. int rows = Math.abs(ar.getFirstCell().getRow() - ar.getLastCell().getRow()) + 1;
163. CellReference[] crs = ar.getAllReferencedCells();sets the
964. AreaReference areaRef = new AreaReference(keyPageSeries[k] +""+(wRow+1) + ":" + keyPageSeries[k]+""+(rowNameDataRangeE+1));
965. if(!areaRef.isSingleCell()){
966. for(int col = areaRef.getFirstCell().getCol(); col <= areaRef.getLastCell().getCol(); col++){
968. for(int row = areaRef.getFirstCell().getRow(); row <= areaRef.getLastCell().getRow(); row++){
969. if (row == areaRef.getFirstCell().getRow()){< p > writes an unsigned two - byte value to an output stream . < / p >
104. AreaReference aref = new AreaReference(nm.getRefersToFormula());
108. band.c1 = aref.getFirstCell().getCol();
109. band.c2 = aref.getLastCell().getCol();
110. band.r1 = aref.getFirstCell().getRow();
111. band.r2 = aref.getLastCell().getRow();
112. band.wholeCols = aref.isWholeColumnReference();sheet 2 is by 3 2 7 6 7 + 3 2 7 6 8 is evaluated to - 1 fix : it not have been taken in excel , and poi the not - 2 0 0 7 .
31. AreaReference ref = new AreaReference( namedRange.getRefersToFormula() );
34. assertTrue( ref.isSingleCell() );
35. assertEquals( row1, ref.getFirstCell().getRow() );
36. assertEquals( col1, ref.getFirstCell().getCol() );
39. assertEquals( row1, Math.min( ref.getFirstCell().getRow(), ref.getLastCell().getRow() ) );
40. assertEquals( col1, Math.min( ref.getFirstCell().getCol(), ref.getLastCell().getCol() ) );
41. assertEquals( row2, Math.max( ref.getFirstCell().getRow(), ref.getLastCell().getRow() ) );
42. assertEquals( col2, Math.max( ref.getFirstCell().getCol(), ref.getLastCell().getCol() ) );sheet 2 is by 3 2 7 6 7 + 3 2 7 6 8 is evaluated to - 1 fix : it not have been taken in excel , and poi the not - 2 0 0 7 .
46. AreaReference ref = new AreaReference( namedRange.getRefersToFormula() );
49. assertTrue( ref.isSingleCell() );
50. assertEquals( row1, ref.getFirstCell().getRow() );
51. assertEquals( col1, ref.getFirstCell().getCol() );
54. assertEquals( row1, Math.min( ref.getFirstCell().getRow(), ref.getLastCell().getRow() ) );
55. assertEquals( col1, Math.min( ref.getFirstCell().getCol(), ref.getLastCell().getCol() ) );
56. assertEquals( row2, Math.max( ref.getFirstCell().getRow(), ref.getLastCell().getRow() ) );
57. assertEquals( col2, Math.max( ref.getFirstCell().getCol(), ref.getLastCell().getCol() ) );sheet 2 is by 3 2 7 6 7 + 3 2 7 6 8 is evaluated to - 1 fix : it not have been taken in excel , and poi the not - 2 0 0 7 .
53. AreaReference ref = new AreaReference( namedRange.getRefersToFormula() );
56. assertTrue( ref.isSingleCell() );
57. assertEquals( row1, ref.getFirstCell().getRow() );
58. assertEquals( col1, ref.getFirstCell().getCol() );
61. assertEquals( row1, Math.min( ref.getFirstCell().getRow(), ref.getLastCell().getRow() ) );
62. assertEquals( col1, Math.min( ref.getFirstCell().getCol(), ref.getLastCell().getCol() ) );
63. assertEquals( row2, Math.max( ref.getFirstCell().getRow(), ref.getLastCell().getRow() ) );
64. assertEquals( col2, Math.max( ref.getFirstCell().getCol(), ref.getLastCell().getCol() ) );sets whether the rowcolheadings are shown in a viewer @ param show whether to show rowcolheadings or not
348. AreaReference ref = ExcelUtils.getReferanceNameRange(nameCUsing);
349. String shName = ref.getFirstCell().getSheetName();
350. int c = ref.getFirstCell().getCol();
351. int r = ref.getFirstCell().getRow();
355. shName = ref.getFirstCell().getSheetName();
356. c = ref.getFirstCell().getCol();
357. r = ref.getFirstCell().getRow();
368. HSSFSheet ash = wb.getSheet(ref.getFirstCell().getSheetName());
369. int begRow = ref.getFirstCell().getRow();