Examples of HSSFName

org.apache.poi.hssf.usermodel.HSSFName
Title: High Level Represantion of Named Range
REFERENCE:
@author Libin Roman (Vista Portal LDT. Developer)

Examples of org.apache.poi.hssf.usermodel.HSSFName

        assertEquals(ref, HSSFFormulaParser.toFormulaString(wb, nr.getNameDefinition()));


        // Check the high level definition
        int idx = wb.getNameIndex("test");
        assertEquals(0, idx);
        HSSFName aNamedCell = wb.getNameAt(idx);


        // Should have 2 references
        assertEquals(ref, aNamedCell.getRefersToFormula());


        // Check the parsing of the reference into cells
        assertFalse(AreaReference.isContiguous(aNamedCell.getRefersToFormula()));
        AreaReference[] arefs = AreaReference.generateContiguous(aNamedCell.getRefersToFormula());
        assertEquals(2, arefs.length);
        assertEquals(refA, arefs[0].formatAsString());
        assertEquals(refB, arefs[1].formatAsString());


        for(int i=0; i<arefs.length; i++) {

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFName

        assertEquals(ref, HSSFFormulaParser.toFormulaString(wb, nr.getNameDefinition()));


        // Check the high level definition
        int idx = wb.getNameIndex("test");
        assertEquals(0, idx);
        HSSFName aNamedCell = wb.getNameAt(idx);


        // Should have 2 references
        assertEquals(ref, aNamedCell.getRefersToFormula());


        // Check the parsing of the reference into cells
        assertFalse(AreaReference.isContiguous(aNamedCell.getRefersToFormula()));
        AreaReference[] arefs = AreaReference.generateContiguous(aNamedCell.getRefersToFormula());
        assertEquals(2, arefs.length);
        assertEquals(refA, arefs[0].formatAsString());
        assertEquals(refB, arefs[1].formatAsString());


        for(int i=0; i<arefs.length; i++) {

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFName

    TestcaseRecordInputStream.confirmRecordEncoding(NameRecord.sid, data, data2);
  }
  public void testFormulaRelAbs_bug46174() {
    // perhaps this testcase belongs on TestHSSFName
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFName name = wb.createName();
    wb.createSheet("Sheet1");
    name.setNameName("test");
    name.setRefersToFormula("Sheet1!$B$3");
    if (name.getRefersToFormula().equals("Sheet1!B3")) {
      throw new AssertionFailedError("Identified bug 46174");
    }
    assertEquals("Sheet1!$B$3", name.getRefersToFormula());
  }

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFName

    assertEquals("Sheet1!$B$3", name.getRefersToFormula());
  }
  public void testFormulaGeneral() {
    // perhaps this testcase belongs on TestHSSFName
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFName name = wb.createName();
    wb.createSheet("Sheet1");
    name.setNameName("test");
    name.setRefersToFormula("Sheet1!A1+Sheet1!A2");
    assertEquals("Sheet1!A1+Sheet1!A2", name.getRefersToFormula());
    name.setRefersToFormula("5*6");
    assertEquals("5*6", name.getRefersToFormula());
  }

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFName

    HSSFSheet s = workbook.createSheet("Foo");
    s.createRow(0).createCell(0).setCellValue(1.1);
    s.createRow(1).createCell(0).setCellValue(2.3);
    s.createRow(2).createCell(2).setCellValue(3.1);


    HSSFName name = workbook.createName();
    name.setNameName("testName");
    name.setRefersToFormula("A1:A2");


    confirmParseFormula(workbook);


    // Now make it a single cell
    name.setRefersToFormula("C3");
    confirmParseFormula(workbook);


    // And make it non-contiguous
    // using area unions
    name.setRefersToFormula("A1:A2,C3");


    confirmParseFormula(workbook);
  }

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFName

    /** bug 49725, defined names with underscore */
    public void testNamesWithUnderscore() {
        HSSFWorkbook wb = new HSSFWorkbook(); //or new XSSFWorkbook();
        HSSFSheet sheet = wb.createSheet("NamesWithUnderscore");


        HSSFName nm;


        nm = wb.createName();
        nm.setNameName("DA6_LEO_WBS_Number");
        nm.setRefersToFormula("33");


        nm = wb.createName();
        nm.setNameName("DA6_LEO_WBS_Name");
        nm.setRefersToFormula("33");


        nm = wb.createName();
        nm.setNameName("A1_");
        nm.setRefersToFormula("22");


        nm = wb.createName();
        nm.setNameName("_A1");
        nm.setRefersToFormula("11");


        nm = wb.createName();
        nm.setNameName("A_1");
        nm.setRefersToFormula("44");


        nm = wb.createName();
        nm.setNameName("A_1_");
        nm.setRefersToFormula("44");


        HSSFRow row = sheet.createRow(0);
        HSSFCell cell = row.createCell(0);


        cell.setCellFormula("DA6_LEO_WBS_Number*2");

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFName

  }


  public void testNamedRangeThatLooksLikeCell() {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet("Sheet1");
    HSSFName name = wb.createName();
    name.setRefersToFormula("Sheet1!B1");
    name.setNameName("pfy1");


    Ptg[] ptgs;
    try {
      ptgs = HSSFFormulaParser.parse("count(pfy1)", wb);
    } catch (IllegalArgumentException e) {

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFName


  /** Named ranges with backslashes, e.g. 'POI\\2009' */
  public void testBackSlashInNames() {
    HSSFWorkbook wb = new HSSFWorkbook();


    HSSFName name = wb.createName();
    name.setNameName("POI\\2009");
    name.setRefersToFormula("Sheet1!$A$1");


    HSSFSheet sheet = wb.createSheet();
    HSSFRow row = sheet.createRow(0);


    HSSFCell cell_C1 =  row.createCell(2);

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFName

  public void testParseComplexName() {


    // Mock up a spreadsheet to match the critical details of the sample
    HSSFWorkbook wb = new HSSFWorkbook();
    wb.createSheet("Sheet1");
    HSSFName definedName = wb.createName();
    definedName.setNameName("foo");
    definedName.setRefersToFormula("Sheet1!B2");


    // Set the complex flag - POI doesn't usually manipulate this flag
    NameRecord nameRec = TestHSSFName.getNameRecord(definedName);
    nameRec.setOptionFlag((short)0x10); // 0x10 -> complex

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFName

    TestcaseRecordInputStream.confirmRecordEncoding(NameRecord.sid, data, data2);
  }
  public void testFormulaRelAbs_bug46174() {
    // perhaps this testcase belongs on TestHSSFName
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFName name = wb.createName();
    wb.createSheet("Sheet1");
    name.setNameName("test");
    name.setRefersToFormula("Sheet1!$B$3");
    if (name.getRefersToFormula().equals("Sheet1!B3")) {
      throw new AssertionFailedError("Identified bug 46174");
    }
    assertEquals("Sheet1!$B$3", name.getRefersToFormula());
  }

View Full Code Here

0 1 2 3 4 5

TOP

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.