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("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.setReference("A1:A2");


    ptgs = HSSFFormulaParser.parse("SUM(testName)", workbook);
    assertTrue("two tokens expected, got "+ptgs.length,ptgs.length == 2);
    assertEquals(NamePtg.class, ptgs[0].getClass());
    assertEquals(FuncVarPtg.class, ptgs[1].getClass());


    // Now make it a single cell
    name.setReference("C3");
    ptgs = HSSFFormulaParser.parse("SUM(testName)", workbook);
    assertTrue("two tokens expected, got "+ptgs.length,ptgs.length == 2);
    assertEquals(NamePtg.class, ptgs[0].getClass());
    assertEquals(FuncVarPtg.class, ptgs[1].getClass());
    
    // And make it non-contiguous
    name.setReference("A1:A2,C3");
    ptgs = HSSFFormulaParser.parse("SUM(testName)", workbook);
    assertTrue("two tokens expected, got "+ptgs.length,ptgs.length == 2);
    assertEquals(NamePtg.class, ptgs[0].getClass());
    assertEquals(FuncVarPtg.class, ptgs[1].getClass());
  }

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.setReference("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

    if (false) {
      // TODO - this code won't work until we can create user-defined functions directly with POI
      wb = new HSSFWorkbook();
      sheet = wb.createSheet();
      wb.setSheetName(0, "Sheet1");
      HSSFName hssfName = wb.createName();
      hssfName.setNameName("myFunc");
      
    } else {
      // This sample spreadsheet already has a VB function called 'myFunc'
      wb = HSSFTestDataSamples.openSampleWorkbook("testNames.xls");
      sheet = wb.getSheetAt(0);

View Full Code Here

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

        assertEquals(ref, nr.getAreaReference(wb));


        // 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.getReference());


        // Check the parsing of the reference into cells
        assertFalse(AreaReference.isContiguous(aNamedCell.getReference()));
        AreaReference[] arefs = AreaReference.generateContiguous(aNamedCell.getReference());
        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


    public static AreaReference getAreaForRange(HSSFWorkbook workbook, String rangeName) {
        int rangeNameIdx = workbook.getNameIndex(rangeName);
        if (rangeNameIdx == -1) return null;


        HSSFName aNamedRange = workbook.getNameAt(rangeNameIdx);
        return new AreaReference(aNamedRange.getReference());
    }

View Full Code Here

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


    public static HSSFSheet getTemplateSheetForRangeName(HSSFWorkbook workbook, String rangeName) {
        int rangeNameIdx = workbook.getNameIndex(rangeName);
        if (rangeNameIdx == -1) return null;


        HSSFName aNamedRange = workbook.getNameAt(rangeNameIdx);
        String sheetName = aNamedRange.getSheetName();
        return workbook.getSheet(sheetName);
    }

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

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.