Package org.apache.poi.hssf.usermodel

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

295
296
297
298
299
300
301
302
303
304
305
        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);
View Full Code Here
868
869
870
871
872
873
874
875
876
877
878
  }

  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
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
  /** 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
1286
1287
1288
1289
1290
1291
1292
1293
1294
1295
1296
  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
1341
1342
1343
1344
1345
1346
1347
1348
1349
1350
1351
      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
40
41
42
43
44
45
46
47
48
49
50
        HSSFSheet sheet = wb.createSheet();
        wb.setSheetName(0, "Sheet1");
        HSSFRow row = sheet.createRow(0);
        HSSFCell cell = row.createCell((short)0);

        HSSFName hssfName = wb.createName();
        hssfName.setNameName("myFunc");
       
        cell.setCellFormula("myFunc()");
        String actualFormula=cell.getCellFormula();
        assertEquals("myFunc()", actualFormula);
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
    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
823
824
825
826
827
828
829
830
831
832
833
  }

  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
45
46
47
48
49
50
51
52
53
54
55
    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);
View Full Code Here
829
830
831
832
833
834
835
836
837
838
839
  }

  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
TOP
Copyright © 2018 www.massapi.com. 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.