Package org.apache.poi.ss.util

Examples of org.apache.poi.ss.util.AreaReference

248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
        HSSFCell c = r.getCell((int)cref.getCol());
        assertNotNull(c);
    }

    public void testSpecialSheetNames() {
        AreaReference ar;
        ar = new AreaReference("'Sheet A'!A1:A1");
        confirmAreaSheetName(ar, "Sheet A", "'Sheet A'!A1");

        ar = new AreaReference("'Hey! Look Here!'!A1:A1");
        confirmAreaSheetName(ar, "Hey! Look Here!", "'Hey! Look Here!'!A1");

        ar = new AreaReference("'O''Toole'!A1:B2");
        confirmAreaSheetName(ar, "O'Toole", "'O''Toole'!A1:B2");

        ar = new AreaReference("'one:many'!A1:B2");
        confirmAreaSheetName(ar, "one:many", "'one:many'!A1:B2");
    }
View Full Code Here
275
276
277
278
279
280
281
282
283
        confirmWholeColumnRef("$C:D", 2, 3, true, false);
        confirmWholeColumnRef("AD:$AE", 29, 30, false, true);
    }

    private static void confirmWholeColumnRef(String ref, int firstCol, int lastCol, boolean firstIsAbs, boolean lastIsAbs) {
        AreaReference ar = new AreaReference(ref);
        confirmCell(ar.getFirstCell(), 0, firstCol, true, firstIsAbs);
        confirmCell(ar.getLastCell(), 0xFFFF, lastCol, true, lastIsAbs);
    }
View Full Code Here
38
39
40
41
42
43
44
45
  private int field_1_index_extern_sheet;


  public Area3DPtg(String arearef, int externIdx) {
    super(new AreaReference(arearef));
    setExternSheetIndex(externIdx);
  }
View Full Code Here
620
621
622
623
624
625
626
627
628
629
630
        ptg = new RefPtg(cr);
      } else {
        ptg = new Ref3DPtg(cr, extIx);
      }
    } else {
      AreaReference areaRef = createAreaRef(part1, part2);

      if (sheetIden == null) {
        ptg = new AreaPtg(areaRef);
      } else {
        ptg = new Area3DPtg(areaRef, extIx);
View Full Code Here
642
643
644
645
646
647
648
      return AreaReference.getWholeRow(part1.getRep(), part2.getRep());
    }
    if (part1.isColumn()) {
      return AreaReference.getWholeColumn(part1.getRep(), part2.getRep());
    }
    return new AreaReference(part1.getCellReference(), part2.getCellReference());
  }
View Full Code Here
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
        assertEquals(2, wb.getNumberOfNames());

        HSSFName name1 = wb.getNameAt(0);
        assertEquals("a", name1.getNameName());
        assertEquals("Sheet1!$A$1", name1.getRefersToFormula());
        new AreaReference(name1.getRefersToFormula());
        assertTrue("Successfully constructed first reference", true);

        HSSFName name2 = wb.getNameAt(1);
        assertEquals("b", name2.getNameName());
        assertEquals("Sheet1!#REF!", name2.getRefersToFormula());
        assertTrue(name2.isDeleted());
        try {
            new AreaReference(name2.getRefersToFormula());
            fail("attempt to supply an invalid reference to AreaReference constructor results in exception");
        } catch (IllegalArgumentException e) { // TODO - use a stronger typed exception for this condition
            // expected during successful test
        }
    }
View Full Code Here
449
450
451
452
453
454
455
456
457
458
459
460
461
462
        int namedCellIdx = wb.getNameIndex(cellName);
        Name aNamedCell = wb.getNameAt(namedCellIdx);
        assertNotNull(aNamedCell);

        // retrieve the cell at the named range and test its contents
        AreaReference aref = new AreaReference(aNamedCell.getRefersToFormula());
        assertTrue("Should be exactly 1 cell in the named cell :'" +cellName+"'", aref.isSingleCell());

        CellReference cref = aref.getFirstCell();
        assertNotNull(cref);
        Sheet s = wb.getSheet(cref.getSheetName());
        assertNotNull(s);
        Row r = sheet.getRow(cref.getRow());
        Cell c = r.getCell(cref.getCol());
View Full Code Here
620
621
622
623
624
625
626
627
628
629
630
        ptg = new RefPtg(cr);
      } else {
        ptg = new Ref3DPtg(cr, extIx);
      }
    } else {
      AreaReference areaRef = createAreaRef(part1, part2);

      if (sheetIden == null) {
        ptg = new AreaPtg(areaRef);
      } else {
        ptg = new Area3DPtg(areaRef, extIx);
View Full Code Here
642
643
644
645
646
647
648
      return AreaReference.getWholeRow(part1.getRep(), part2.getRep());
    }
    if (part1.isColumn()) {
      return AreaReference.getWholeColumn(part1.getRep(), part2.getRep());
    }
    return new AreaReference(part1.getCellReference(), part2.getCellReference());
  }
View Full Code Here
38
39
40
41
42
43
44
45
  private int field_1_index_extern_sheet;


  public Area3DPtg(String arearef, int externIdx) {
    super(new AreaReference(arearef));
    setExternSheetIndex(externIdx);
  }
View Full Code Here
TOP

Related Classes of org.apache.poi.ss.util.AreaReference

  • com.haulmont.yarg.formatters.impl.xls.Area
  • com.haulmont.yarg.formatters.impl.xls.HSSFRangeHelper
  • com.haulmont.yarg.formatters.impl.XLSFormatter
  • org.apache.poi.hssf.record.formula.Area3DPtg
  • org.apache.poi.hssf.record.formula.AreaPtg
  • org.apache.poi.hssf.record.formula.AreaPtgBase
  • org.apache.poi.hssf.usermodel.TestHSSFName
  • org.apache.poi.hssf.usermodel.TestNamedRange
  • org.apache.poi.hssf.util.TestAreaReference
  • org.apache.poi.ss.formula.FormulaParser
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.