Examples of org.apache.poi.hssf.usermodel.HSSFWorkbook.createName()

Class org.apache.poi.hssf.usermodel.HSSFWorkbook

Examples of org.apache.poi.hssf.usermodel.HSSFWorkbook.createName()

org.apache.poi.hssf.usermodel.HSSFWorkbook.createName()
creates a new named range and add it to the model @return named range high level

  }


  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 {

View Full Code Here


  /** 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);

View Full Code Here

  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);

View Full Code Here

      throw new AssertionFailedError("Identified bug 47312c - '"
          + leadingZeroCellRef + "' should parse as 'B1'.");
    }


    // create a defined name called 'B0' and try again
    Name n = wb.createName();
    n.setNameName("B0");
    n.setRefersToFormula("1+1");
    ptgs = HSSFFormulaParser.parse("B0", wb);
    confirmTokenClasses(ptgs, NamePtg.class);
  }

View Full Code Here

  }


  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 {

View Full Code Here

    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");


    confirmParseFormula(workbook);

View Full Code Here

    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.setReference("Sheet1!$B$3");
    if (name.getReference().equals("Sheet1!B3")) {
      throw new AssertionFailedError("Identified bug 46174");

View Full Code Here

    assertEquals("Sheet1!$B$3", name.getReference());
  }
  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");

View Full Code Here

    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");

View Full Code Here

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


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


    fp = HSSFFormulaEvaluator.getUnderlyingParser(workbook, "SUM(testName)");
    fp.parse();

View Full Code Here

0 1 2 3 4 5 6 7

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.