Package org.apache.poi.hssf.usermodel

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

1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
   */
  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
View Full Code Here
112
113
114
115
116
117
118
119
120
121
122
    }
  }

  public void testRangeUsingOffsetFunc_bug46948() {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFRow row = wb.createSheet("Sheet1").createRow(0);
    HSSFCell cellA1 = row.createCell(0);
    HSSFCell cellB1 = row.createCell(1);
    row.createCell(2).setCellValue(5.0); // C1
    row.createCell(3).setCellValue(7.0); // D1
    row.createCell(4).setCellValue(9.0); // E1
View Full Code Here
576
577
578
579
580
581
582
583
584
585
586
  /**
   * In 3.1, setting margins between creating first row and first cell caused an exception.
   */
  public void testSetMargins_bug45717() {
    HSSFWorkbook workbook = new HSSFWorkbook();
    HSSFSheet sheet = workbook.createSheet("Vorschauliste");
    HSSFRow row = sheet.createRow(0);

    sheet.setMargin(HSSFSheet.LeftMargin, 0.3);
    try {
      row.createCell(0);
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
    assertEquals(4.57353557, ((NumberEval)result).getNumberValue(), 0.00000001);
  }

  public void testEvaluate_bug_45732() {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet("Sheet1");
    HSSFCell cell = sheet.createRow(0).createCell(0);

    cell.setCellFormula("NPER(12,4500,100000,100000)");
    cell.setCellValue(15.0);
    assertEquals("NPER(12,4500,100000,100000)", cell.getCellFormula());
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
   * "INDEX() formula cannot contain its own location in the data array range"
   */
  public void testIndexFormula() {
   
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet("Sheet1");
   
    int colB = 1;
    sheet.createRow(0).createCell(colB).setCellValue(1);
    sheet.createRow(1).createCell(colB).setCellValue(2);
    sheet.createRow(2).createCell(colB).setCellValue(3);
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
   * Cell A1 has formula "=A1"
   */
  public void testSimpleCircularReference() {
   
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet("Sheet1");
   
    HSSFRow row = sheet.createRow(0);
    HSSFCell testCell = row.createCell(0);
    testCell.setCellFormula("A1");

View Full Code Here
105
106
107
108
109
110
111
112
113
114
115
   * A1=B1, B1=C1, C1=D1, D1=A1
   */
  public void testMultiLevelCircularReference() {
   
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet("Sheet1");
   
    HSSFRow row = sheet.createRow(0);
    row.createCell(0).setCellFormula("B1");
    row.createCell(1).setCellFormula("C1");
    row.createCell(2).setCellFormula("D1");
View Full Code Here
121
122
123
124
125
126
127
128
129
130
131
    confirmCycleErrorCode(cellValue);
  }
 
  public void testIntermediateCircularReferenceResults_bug46898() {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet("Sheet1");
   
    HSSFRow row = sheet.createRow(0);
   
    HSSFCell cellA1 = row.createCell(0);
    HSSFCell cellB1 = row.createCell(1);
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
    AreaEval ae = EvalFactory.createAreaEval("B2:B2", new ValueEval[] { new NumberEval(50), });
    confirm(ae, 0.5);
  }
  public void testInSpreadSheet() {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet("Sheet1");
    HSSFRow row = sheet.createRow(0);
    HSSFCell cell = row.createCell(0);
    cell.setCellFormula("B1%");
    row.createCell(1).setCellValue(50.0);
   
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
public final class TestCFRuleRecord extends TestCase
{
    public void testConstructors ()
    {
        HSSFWorkbook workbook = new HSSFWorkbook();
        HSSFSheet sheet = workbook.createSheet();

        CFRuleRecord rule1 = CFRuleRecord.create(sheet, "7");
        assertEquals(CFRuleRecord.CONDITION_TYPE_FORMULA, rule1.getConditionType());
        assertEquals(ComparisonOperator.NO_COMPARISON, rule1.getComparisonOperation());
        assertNotNull(rule1.getParsedExpression1());
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.