Package org.zkoss.poi.ss.usermodel

Examples of org.zkoss.poi.ss.usermodel.CellValue


    assertEquals(15, row7.getCell(4).getNumericCellValue(), 0.0000000000000001); //E7: 15
    assertEquals(16, row7.getCell(5).getNumericCellValue(), 0.0000000000000001); //F7: 16
   
    //A1: =SUM(C4:F7);
    Cell cellA1 = row1.getCell(0);
    CellValue valueA1 = _evaluator.evaluate(cellA1);
    assertEquals(136, valueA1.getNumberValue(), 0.0000000000000001);
    assertEquals(Cell.CELL_TYPE_NUMERIC, valueA1.getCellType());
    testToFormulaString(cellA1, "SUM(C4:F7)");
 
    //move up from C3:F4 to C1:F2
    BookHelper.moveRange(sheet1, 2, 2, 3, 5, -2, 0);
    _evaluator.notifySetFormula(cellA1);
    Row row2 = sheet1.getRow(1);
    assertEquals(1, row2.getCell(2).getNumericCellValue(), 0.0000000000000001); //C2: 1
    assertEquals(2, row2.getCell(3).getNumericCellValue(), 0.0000000000000001); //D2: 2
    assertEquals(3, row2.getCell(4).getNumericCellValue(), 0.0000000000000001); //E2: 3
    assertEquals(4, row2.getCell(5).getNumericCellValue(), 0.0000000000000001); //F2: 4

    assertEquals(5, row5.getCell(2).getNumericCellValue(), 0.0000000000000001); //C5: 5
    assertEquals(6, row5.getCell(3).getNumericCellValue(), 0.0000000000000001); //D5: 6
    assertEquals(7, row5.getCell(4).getNumericCellValue(), 0.0000000000000001); //E5: 7
    assertEquals(8, row5.getCell(5).getNumericCellValue(), 0.0000000000000001); //F5: 8
   
    assertEquals(9, row6.getCell(2).getNumericCellValue(), 0.0000000000000001); //C6: 9
    assertEquals(10, row6.getCell(3).getNumericCellValue(), 0.0000000000000001); //D6: 10
    assertEquals(11, row6.getCell(4).getNumericCellValue(), 0.0000000000000001); //E6: 11
    assertEquals(12, row6.getCell(5).getNumericCellValue(), 0.0000000000000001); //F6: 12
   
    assertEquals(13, row7.getCell(2).getNumericCellValue(), 0.0000000000000001); //C7: 13
    assertEquals(14, row7.getCell(3).getNumericCellValue(), 0.0000000000000001); //D7: 14
    assertEquals(15, row7.getCell(4).getNumericCellValue(), 0.0000000000000001); //E7: 15
    assertEquals(16, row7.getCell(5).getNumericCellValue(), 0.0000000000000001); //F7: 16
   
    //A1: =SUM(C4:F7) -> =SUM(C2:F7)
    cellA1 = row1.getCell(0);
    valueA1 = _evaluator.evaluate(cellA1);
    assertEquals(136, valueA1.getNumberValue(), 0.0000000000000001);
    assertEquals(Cell.CELL_TYPE_NUMERIC, valueA1.getCellType());
    testToFormulaString(cellA1, "SUM(C2:F7)");
  }
View Full Code Here


    assertEquals(15, row7.getCell(4).getNumericCellValue(), 0.0000000000000001); //E7: 15
    assertEquals(16, row7.getCell(5).getNumericCellValue(), 0.0000000000000001); //F7: 16
   
    //A1: =SUM(C4:F7);
    Cell cellA1 = row1.getCell(0);
    CellValue valueA1 = _evaluator.evaluate(cellA1);
    assertEquals(136, valueA1.getNumberValue(), 0.0000000000000001);
    assertEquals(Cell.CELL_TYPE_NUMERIC, valueA1.getCellType());
    testToFormulaString(cellA1, "SUM(C4:F7)");
 
    //move left from C6:F8 to C2:F4
    BookHelper.moveRange(sheet1, 5, 2, 7, 5, -4, 0);
    _evaluator.notifySetFormula(cellA1);
   
    assertNull(row4.getCell(2));
    assertNull(row4.getCell(3));
    assertNull(row4.getCell(4));
    assertNull(row4.getCell(5));

    assertEquals(5, row5.getCell(2).getNumericCellValue(), 0.0000000000000001); //C5: 5
    assertEquals(6, row5.getCell(3).getNumericCellValue(), 0.0000000000000001); //D5: 6
    assertEquals(7, row5.getCell(4).getNumericCellValue(), 0.0000000000000001); //E5: 7
    assertEquals(8, row5.getCell(5).getNumericCellValue(), 0.0000000000000001); //F5: 8
   
    Row row2 = sheet1.getRow(1);
    assertEquals(9, row2.getCell(2).getNumericCellValue(), 0.0000000000000001); //C6: 9
    assertEquals(10, row2.getCell(3).getNumericCellValue(), 0.0000000000000001); //D6: 10
    assertEquals(11, row2.getCell(4).getNumericCellValue(), 0.0000000000000001); //E6: 11
    assertEquals(12, row2.getCell(5).getNumericCellValue(), 0.0000000000000001); //F6: 12
   
    Row row3 = sheet1.getRow(2);
    assertEquals(13, row3.getCell(2).getNumericCellValue(), 0.0000000000000001); //C7: 13
    assertEquals(14, row3.getCell(3).getNumericCellValue(), 0.0000000000000001); //D7: 14
    assertEquals(15, row3.getCell(4).getNumericCellValue(), 0.0000000000000001); //E7: 15
    assertEquals(16, row3.getCell(5).getNumericCellValue(), 0.0000000000000001); //F7: 16
   
    //A1: =SUM(C4:F7) -> =SUM(C2:F5)
    cellA1 = row1.getCell(0);
    valueA1 = _evaluator.evaluate(cellA1);
    assertEquals(126, valueA1.getNumberValue(), 0.0000000000000001);
    assertEquals(Cell.CELL_TYPE_NUMERIC, valueA1.getCellType());
    testToFormulaString(cellA1, "SUM(C2:F5)");
  }
View Full Code Here

    assertEquals(15, row7.getCell(4).getNumericCellValue(), 0.0000000000000001); //E7: 15
    assertEquals(16, row7.getCell(5).getNumericCellValue(), 0.0000000000000001); //F7: 16
   
    //A1: =SUM(C4:F7);
    Cell cellA1 = row1.getCell(0);
    CellValue valueA1 = _evaluator.evaluate(cellA1);
    assertEquals(136, valueA1.getNumberValue(), 0.0000000000000001);
    assertEquals(Cell.CELL_TYPE_NUMERIC, valueA1.getCellType());
    testToFormulaString(cellA1, "SUM(C4:F7)");
 
    //move left from C3:F5 to C5:F7
    BookHelper.moveRange(sheet1, 2, 2, 4, 5, 2, 0);
    _evaluator.notifySetFormula(cellA1);
   
    assertEquals(1, row6.getCell(2).getNumericCellValue(), 0.0000000000000001); //C4: 1
    assertEquals(2, row6.getCell(3).getNumericCellValue(), 0.0000000000000001); //D4: 2
    assertEquals(3, row6.getCell(4).getNumericCellValue(), 0.0000000000000001); //E4: 3
    assertEquals(4, row6.getCell(5).getNumericCellValue(), 0.0000000000000001); //F4: 4

    assertEquals(5, row7.getCell(2).getNumericCellValue(), 0.0000000000000001); //C5: 5
    assertEquals(6, row7.getCell(3).getNumericCellValue(), 0.0000000000000001); //D5: 6
    assertEquals(7, row7.getCell(4).getNumericCellValue(), 0.0000000000000001); //E5: 7
    assertEquals(8, row7.getCell(5).getNumericCellValue(), 0.0000000000000001); //F5: 8
   
    assertNull(row4.getCell(2));
    assertNull(row4.getCell(3));
    assertNull(row4.getCell(4));
    assertNull(row4.getCell(5));
   
    assertNull(row5.getCell(2));
    assertNull(row5.getCell(3));
    assertNull(row5.getCell(4));
    assertNull(row5.getCell(5));
   
    //A1: =SUM(C4:F7) -> =SUM(C6:F7)
    cellA1 = row1.getCell(0);
    valueA1 = _evaluator.evaluate(cellA1);
    assertEquals(36, valueA1.getNumberValue(), 0.0000000000000001);
    assertEquals(Cell.CELL_TYPE_NUMERIC, valueA1.getCellType());
    testToFormulaString(cellA1, "SUM(C6:F7)");
  }
View Full Code Here

    assertEquals(15, row7.getCell(4).getNumericCellValue(), 0.0000000000000001); //E7: 15
    assertEquals(16, row7.getCell(5).getNumericCellValue(), 0.0000000000000001); //F7: 16
   
    //A1: =SUM(C4:F7);
    Cell cellA1 = row1.getCell(0);
    CellValue valueA1 = _evaluator.evaluate(cellA1);
    assertEquals(136, valueA1.getNumberValue(), 0.0000000000000001);
    assertEquals(Cell.CELL_TYPE_NUMERIC, valueA1.getCellType());
    testToFormulaString(cellA1, "SUM(C4:F7)");
 
    //move left from C6:F6 to C7:F7
    BookHelper.moveRange(sheet1, 5, 2, 5, 5, 1, 0);
    _evaluator.notifySetFormula(cellA1);
   
    assertEquals(1, row4.getCell(2).getNumericCellValue(), 0.0000000000000001); //C4: 1
    assertEquals(2, row4.getCell(3).getNumericCellValue(), 0.0000000000000001); //D4: 2
    assertEquals(3, row4.getCell(4).getNumericCellValue(), 0.0000000000000001); //E4: 3
    assertEquals(4, row4.getCell(5).getNumericCellValue(), 0.0000000000000001); //F4: 4

    assertEquals(5, row5.getCell(2).getNumericCellValue(), 0.0000000000000001); //C5: 5
    assertEquals(6, row5.getCell(3).getNumericCellValue(), 0.0000000000000001); //D5: 6
    assertEquals(7, row5.getCell(4).getNumericCellValue(), 0.0000000000000001); //E5: 7
    assertEquals(8, row5.getCell(5).getNumericCellValue(), 0.0000000000000001); //F5: 8
   
    assertEquals(9, row7.getCell(2).getNumericCellValue(), 0.0000000000000001); //C6: 9
    assertEquals(10, row7.getCell(3).getNumericCellValue(), 0.0000000000000001); //D6: 10
    assertEquals(11, row7.getCell(4).getNumericCellValue(), 0.0000000000000001); //E6: 11
    assertEquals(12, row7.getCell(5).getNumericCellValue(), 0.0000000000000001); //F6: 12
   
    assertNull(row6.getCell(2));
    assertNull(row6.getCell(3));
    assertNull(row6.getCell(4));
    assertNull(row6.getCell(5));
   
    //A1: =SUM(C4:F7) -> =SUM(C4:F7) //no change
    cellA1 = row1.getCell(0);
    valueA1 = _evaluator.evaluate(cellA1);
    assertEquals(78, valueA1.getNumberValue(), 0.0000000000000001);
    assertEquals(Cell.CELL_TYPE_NUMERIC, valueA1.getCellType());
    testToFormulaString(cellA1, "SUM(C4:F7)");
  }
View Full Code Here

    assertEquals(15, row7.getCell(4).getNumericCellValue(), 0.0000000000000001); //E7: 15
    assertEquals(16, row7.getCell(5).getNumericCellValue(), 0.0000000000000001); //F7: 16
   
    //A1: =SUM(C4:F7);
    Cell cellA1 = row1.getCell(0);
    CellValue valueA1 = _evaluator.evaluate(cellA1);
    assertEquals(136, valueA1.getNumberValue(), 0.0000000000000001);
    assertEquals(Cell.CELL_TYPE_NUMERIC, valueA1.getCellType());
    testToFormulaString(cellA1, "SUM(C4:F7)");
 
    //move left from C7:F9 to C5:F7
    BookHelper.moveRange(sheet1, 6, 2, 8, 5, -2, 0);
    _evaluator.notifySetFormula(cellA1);

    assertEquals(1, row4.getCell(2).getNumericCellValue(), 0.0000000000000001); //C4: 1
    assertEquals(2, row4.getCell(3).getNumericCellValue(), 0.0000000000000001); //D4: 2
    assertEquals(3, row4.getCell(4).getNumericCellValue(), 0.0000000000000001); //E4: 3
    assertEquals(4, row4.getCell(5).getNumericCellValue(), 0.0000000000000001); //F4: 4

    assertEquals(13, row5.getCell(2).getNumericCellValue(), 0.0000000000000001); //C5: 13
    assertEquals(14, row5.getCell(3).getNumericCellValue(), 0.0000000000000001); //D5: 14
    assertEquals(15, row5.getCell(4).getNumericCellValue(), 0.0000000000000001); //E5: 15
    assertEquals(16, row5.getCell(5).getNumericCellValue(), 0.0000000000000001); //F5: 16
   
    assertNull(row6.getCell(2));
    assertNull(row6.getCell(3));
    assertNull(row6.getCell(4));
    assertNull(row6.getCell(5));
   
    assertNull(row7.getCell(2));
    assertNull(row7.getCell(3));
    assertNull(row7.getCell(4));
    assertNull(row7.getCell(5));
   
    //A1: =SUM(C4:F7) -> =SUM(B4:E7)
    cellA1 = row1.getCell(0);
    valueA1 = _evaluator.evaluate(cellA1);
    assertEquals(68, valueA1.getNumberValue(), 0.0000000000000001);
    assertEquals(Cell.CELL_TYPE_NUMERIC, valueA1.getCellType());
    testToFormulaString(cellA1, "SUM(C4:F5)");
  }
View Full Code Here

    assertEquals(15, row7.getCell(4).getNumericCellValue(), 0.0000000000000001); //E7: 15
    assertEquals(16, row7.getCell(5).getNumericCellValue(), 0.0000000000000001); //F7: 16
   
    //A1: =SUM(C4:F7);
    Cell cellA1 = row1.getCell(0);
    CellValue valueA1 = _evaluator.evaluate(cellA1);
    assertEquals(136, valueA1.getNumberValue(), 0.0000000000000001);
    assertEquals(Cell.CELL_TYPE_NUMERIC, valueA1.getCellType());
    testToFormulaString(cellA1, "SUM(C4:F7)");
 
    //move left from B2:G8 to C3:H9
    BookHelper.moveRange(sheet1, 1, 1, 7, 6, 1, 1);
    _evaluator.notifySetFormula(cellA1);

    assertNull(row5.getCell(2));
    assertEquals(1, row5.getCell(3).getNumericCellValue(), 0.0000000000000001); //D4: 1
    assertEquals(2, row5.getCell(4).getNumericCellValue(), 0.0000000000000001); //E4: 2
    assertEquals(3, row5.getCell(5).getNumericCellValue(), 0.0000000000000001); //F4: 3
    assertEquals(4, row5.getCell(6).getNumericCellValue(), 0.0000000000000001); //G4: 4

    assertNull(row6.getCell(2));
    assertEquals(5, row6.getCell(3).getNumericCellValue(), 0.0000000000000001); //D4: 5
    assertEquals(6, row6.getCell(4).getNumericCellValue(), 0.0000000000000001); //E4: 6
    assertEquals(7, row6.getCell(5).getNumericCellValue(), 0.0000000000000001); //F4: 7
    assertEquals(8, row6.getCell(6).getNumericCellValue(), 0.0000000000000001); //G4: 8
   
    assertNull(row7.getCell(2));
    assertEquals(9, row7.getCell(3).getNumericCellValue(), 0.0000000000000001); //D4: 9
    assertEquals(10, row7.getCell(4).getNumericCellValue(), 0.0000000000000001); //E4: 10
    assertEquals(11, row7.getCell(5).getNumericCellValue(), 0.0000000000000001); //F4: 11
    assertEquals(12, row7.getCell(6).getNumericCellValue(), 0.0000000000000001); //G4: 12
   
    Row row8 = sheet1.getRow(7);
    assertNull(row8.getCell(2));
    assertEquals(13, row8.getCell(3).getNumericCellValue(), 0.0000000000000001); //D4: 13
    assertEquals(14, row8.getCell(4).getNumericCellValue(), 0.0000000000000001); //E4: 14
    assertEquals(15, row8.getCell(5).getNumericCellValue(), 0.0000000000000001); //F4: 15
    assertEquals(16, row8.getCell(6).getNumericCellValue(), 0.0000000000000001); //G4: 16
   
    assertNull(row4.getCell(2));
    assertNull(row4.getCell(3));
    assertNull(row4.getCell(4));
    assertNull(row4.getCell(5));
   
    //A1: =SUM(C4:F7) -> =SUM(B4:E7)
    cellA1 = row1.getCell(0);
    valueA1 = _evaluator.evaluate(cellA1);
    assertEquals(136, valueA1.getNumberValue(), 0.0000000000000001);
    assertEquals(Cell.CELL_TYPE_NUMERIC, valueA1.getCellType());
    testToFormulaString(cellA1, "SUM(D5:G8)");
  }
View Full Code Here

    assertEquals(15, row7.getCell(4).getNumericCellValue(), 0.0000000000000001); //E7: 15
    assertEquals(16, row7.getCell(5).getNumericCellValue(), 0.0000000000000001); //F7: 16
   
    //A1: =SUM(C4:F7);
    Cell cellA1 = row1.getCell(0);
    CellValue valueA1 = _evaluator.evaluate(cellA1);
    assertEquals(136, valueA1.getNumberValue(), 0.0000000000000001);
    assertEquals(Cell.CELL_TYPE_NUMERIC, valueA1.getCellType());
    testToFormulaString(cellA1, "SUM(C4:F7)");
 
    //move left from B2:G8 to C3:H9
    BookHelper.moveRange(sheet1, 1, 1, 7, 6, 1, -1);
    _evaluator.notifySetFormula(cellA1);

    assertNull(row5.getCell(5));
    assertEquals(1, row5.getCell(1).getNumericCellValue(), 0.0000000000000001); //D4: 1
    assertEquals(2, row5.getCell(2).getNumericCellValue(), 0.0000000000000001); //E4: 2
    assertEquals(3, row5.getCell(3).getNumericCellValue(), 0.0000000000000001); //F4: 3
    assertEquals(4, row5.getCell(4).getNumericCellValue(), 0.0000000000000001); //G4: 4

    assertNull(row6.getCell(5));
    assertEquals(5, row6.getCell(1).getNumericCellValue(), 0.0000000000000001); //D4: 5
    assertEquals(6, row6.getCell(2).getNumericCellValue(), 0.0000000000000001); //E4: 6
    assertEquals(7, row6.getCell(3).getNumericCellValue(), 0.0000000000000001); //F4: 7
    assertEquals(8, row6.getCell(4).getNumericCellValue(), 0.0000000000000001); //G4: 8
   
    assertNull(row7.getCell(5));
    assertEquals(9, row7.getCell(1).getNumericCellValue(), 0.0000000000000001); //D4: 9
    assertEquals(10, row7.getCell(2).getNumericCellValue(), 0.0000000000000001); //E4: 10
    assertEquals(11, row7.getCell(3).getNumericCellValue(), 0.0000000000000001); //F4: 11
    assertEquals(12, row7.getCell(4).getNumericCellValue(), 0.0000000000000001); //G4: 12
   
    Row row8 = sheet1.getRow(7);
    assertNull(row8.getCell(5));
    assertEquals(13, row8.getCell(1).getNumericCellValue(), 0.0000000000000001); //D4: 13
    assertEquals(14, row8.getCell(2).getNumericCellValue(), 0.0000000000000001); //E4: 14
    assertEquals(15, row8.getCell(3).getNumericCellValue(), 0.0000000000000001); //F4: 15
    assertEquals(16, row8.getCell(4).getNumericCellValue(), 0.0000000000000001); //G4: 16
   
    assertNull(row4.getCell(2));
    assertNull(row4.getCell(3));
    assertNull(row4.getCell(4));
    assertNull(row4.getCell(5));
   
    //A1: =SUM(C4:F7) -> =SUM(B5:E8)
    cellA1 = row1.getCell(0);
    valueA1 = _evaluator.evaluate(cellA1);
    assertEquals(136, valueA1.getNumberValue(), 0.0000000000000001);
    assertEquals(Cell.CELL_TYPE_NUMERIC, valueA1.getCellType());
    testToFormulaString(cellA1, "SUM(B5:E8)");
  }
View Full Code Here

    assertEquals(15, row7.getCell(4).getNumericCellValue(), 0.0000000000000001); //E7: 15
    assertEquals(16, row7.getCell(5).getNumericCellValue(), 0.0000000000000001); //F7: 16
   
    //A1: =SUM(C4:F7);
    Cell cellA1 = row1.getCell(0);
    CellValue valueA1 = _evaluator.evaluate(cellA1);
    assertEquals(136, valueA1.getNumberValue(), 0.0000000000000001);
    assertEquals(Cell.CELL_TYPE_NUMERIC, valueA1.getCellType());
    testToFormulaString(cellA1, "SUM(C4:F7)");
 
    //move left from B3:G8 to C2:H7
    BookHelper.moveRange(sheet1, 2, 1, 7, 6, -1, 1);
    _evaluator.notifySetFormula(cellA1);

    Row row3 = sheet1.getRow(2);
    assertNull(row3.getCell(2));
    assertEquals(1, row3.getCell(3).getNumericCellValue(), 0.0000000000000001); //D4: 1
    assertEquals(2, row3.getCell(4).getNumericCellValue(), 0.0000000000000001); //E4: 2
    assertEquals(3, row3.getCell(5).getNumericCellValue(), 0.0000000000000001); //F4: 3
    assertEquals(4, row3.getCell(6).getNumericCellValue(), 0.0000000000000001); //G4: 4

    assertNull(row6.getCell(2));
    assertEquals(5, row4.getCell(3).getNumericCellValue(), 0.0000000000000001); //D4: 5
    assertEquals(6, row4.getCell(4).getNumericCellValue(), 0.0000000000000001); //E4: 6
    assertEquals(7, row4.getCell(5).getNumericCellValue(), 0.0000000000000001); //F4: 7
    assertEquals(8, row4.getCell(6).getNumericCellValue(), 0.0000000000000001); //G4: 8
   
    assertNull(row7.getCell(2));
    assertEquals(9, row5.getCell(3).getNumericCellValue(), 0.0000000000000001); //D4: 9
    assertEquals(10, row5.getCell(4).getNumericCellValue(), 0.0000000000000001); //E4: 10
    assertEquals(11, row5.getCell(5).getNumericCellValue(), 0.0000000000000001); //F4: 11
    assertEquals(12, row5.getCell(6).getNumericCellValue(), 0.0000000000000001); //G4: 12
   
    assertNull(row6.getCell(2));
    assertEquals(13, row6.getCell(3).getNumericCellValue(), 0.0000000000000001); //D4: 13
    assertEquals(14, row6.getCell(4).getNumericCellValue(), 0.0000000000000001); //E4: 14
    assertEquals(15, row6.getCell(5).getNumericCellValue(), 0.0000000000000001); //F4: 15
    assertEquals(16, row6.getCell(6).getNumericCellValue(), 0.0000000000000001); //G4: 16
   
    assertNull(row7.getCell(2));
    assertNull(row7.getCell(3));
    assertNull(row7.getCell(4));
    assertNull(row7.getCell(5));
   
    //A1: =SUM(C4:F7) -> =SUM(D3:G6)
    cellA1 = row1.getCell(0);
    valueA1 = _evaluator.evaluate(cellA1);
    assertEquals(136, valueA1.getNumberValue(), 0.0000000000000001);
    assertEquals(Cell.CELL_TYPE_NUMERIC, valueA1.getCellType());
    testToFormulaString(cellA1, "SUM(D3:G6)");
  }
View Full Code Here

    assertEquals(15, row7.getCell(4).getNumericCellValue(), 0.0000000000000001); //E7: 15
    assertEquals(16, row7.getCell(5).getNumericCellValue(), 0.0000000000000001); //F7: 16
   
    //A1: =SUM(C4:F7);
    Cell cellA1 = row1.getCell(0);
    CellValue valueA1 = _evaluator.evaluate(cellA1);
    assertEquals(136, valueA1.getNumberValue(), 0.0000000000000001);
    assertEquals(Cell.CELL_TYPE_NUMERIC, valueA1.getCellType());
    testToFormulaString(cellA1, "SUM(C4:F7)");
 
    //move left from B3:G8 to C2:H7
    BookHelper.moveRange(sheet1, 2, 1, 7, 6, -1, -1);
    _evaluator.notifySetFormula(cellA1);

    Row row3 = sheet1.getRow(2);
    assertNull(row3.getCell(5));
    assertEquals(1, row3.getCell(1).getNumericCellValue(), 0.0000000000000001); //D4: 1
    assertEquals(2, row3.getCell(2).getNumericCellValue(), 0.0000000000000001); //E4: 2
    assertEquals(3, row3.getCell(3).getNumericCellValue(), 0.0000000000000001); //F4: 3
    assertEquals(4, row3.getCell(4).getNumericCellValue(), 0.0000000000000001); //G4: 4

    assertNull(row6.getCell(5));
    assertEquals(5, row4.getCell(1).getNumericCellValue(), 0.0000000000000001); //D4: 5
    assertEquals(6, row4.getCell(2).getNumericCellValue(), 0.0000000000000001); //E4: 6
    assertEquals(7, row4.getCell(3).getNumericCellValue(), 0.0000000000000001); //F4: 7
    assertEquals(8, row4.getCell(4).getNumericCellValue(), 0.0000000000000001); //G4: 8
   
    assertNull(row7.getCell(5));
    assertEquals(9, row5.getCell(1).getNumericCellValue(), 0.0000000000000001); //D4: 9
    assertEquals(10, row5.getCell(2).getNumericCellValue(), 0.0000000000000001); //E4: 10
    assertEquals(11, row5.getCell(3).getNumericCellValue(), 0.0000000000000001); //F4: 11
    assertEquals(12, row5.getCell(4).getNumericCellValue(), 0.0000000000000001); //G4: 12
   
    assertNull(row6.getCell(5));
    assertEquals(13, row6.getCell(1).getNumericCellValue(), 0.0000000000000001); //D4: 13
    assertEquals(14, row6.getCell(2).getNumericCellValue(), 0.0000000000000001); //E4: 14
    assertEquals(15, row6.getCell(3).getNumericCellValue(), 0.0000000000000001); //F4: 15
    assertEquals(16, row6.getCell(4).getNumericCellValue(), 0.0000000000000001); //G4: 16
   
    assertNull(row7.getCell(2));
    assertNull(row7.getCell(3));
    assertNull(row7.getCell(4));
    assertNull(row7.getCell(5));
   
    //A1: =SUM(C4:F7) -> =SUM(B3:E6)
    cellA1 = row1.getCell(0);
    valueA1 = _evaluator.evaluate(cellA1);
    assertEquals(136, valueA1.getNumberValue(), 0.0000000000000001);
    assertEquals(Cell.CELL_TYPE_NUMERIC, valueA1.getCellType());
    testToFormulaString(cellA1, "SUM(B3:E6)");
  }
View Full Code Here

    assertEquals(15, row7.getCell(4).getNumericCellValue(), 0.0000000000000001); //E7: 15
    assertEquals(16, row7.getCell(5).getNumericCellValue(), 0.0000000000000001); //F7: 16
   
    //A1: =SUM(C4:F7);
    Cell cellA1 = row1.getCell(0);
    CellValue valueA1 = _evaluator.evaluate(cellA1);
    assertEquals(136, valueA1.getNumberValue(), 0.0000000000000001);
    assertEquals(Cell.CELL_TYPE_NUMERIC, valueA1.getCellType());
    testToFormulaString(cellA1, "SUM(C4:F7)");
 
    //move left from D6:G8 to E7:H9
    BookHelper.moveRange(sheet1, 5, 3, 7, 6, 1, 1);
    _evaluator.notifySetFormula(cellA1);

    assertEquals(1, row4.getCell(2).getNumericCellValue(), 0.0000000000000001); //C4: 1
    assertEquals(2, row4.getCell(3).getNumericCellValue(), 0.0000000000000001); //D4: 2
    assertEquals(3, row4.getCell(4).getNumericCellValue(), 0.0000000000000001); //E4: 3
    assertEquals(4, row4.getCell(5).getNumericCellValue(), 0.0000000000000001); //F4: 4

    assertEquals(5, row5.getCell(2).getNumericCellValue(), 0.0000000000000001); //C5: 5
    assertEquals(6, row5.getCell(3).getNumericCellValue(), 0.0000000000000001); //D5: 6
    assertEquals(7, row5.getCell(4).getNumericCellValue(), 0.0000000000000001); //E5: 7
    assertEquals(8, row5.getCell(5).getNumericCellValue(), 0.0000000000000001); //F5: 8
   
    assertEquals(9, row6.getCell(2).getNumericCellValue(), 0.0000000000000001); //C6: 9
    assertNull(row6.getCell(3));
    assertNull(row6.getCell(4));
    assertNull(row6.getCell(5));
   
    assertEquals(13, row7.getCell(2).getNumericCellValue(), 0.0000000000000001); //C7: 13
    assertNull(row7.getCell(3));
   
    assertEquals(10, row7.getCell(4).getNumericCellValue(), 0.0000000000000001); //D6: 10
    assertEquals(11, row7.getCell(5).getNumericCellValue(), 0.0000000000000001); //E6: 11
    assertEquals(12, row7.getCell(6).getNumericCellValue(), 0.0000000000000001); //F6: 12
   
    Row row8 = sheet1.getRow(7);
    assertNull(row8.getCell(2));
    assertNull(row8.getCell(3));
    assertEquals(14, row8.getCell(4).getNumericCellValue(), 0.0000000000000001); //D7: 14
    assertEquals(15, row8.getCell(5).getNumericCellValue(), 0.0000000000000001); //E7: 15
    assertEquals(16, row8.getCell(6).getNumericCellValue(), 0.0000000000000001); //F7: 16
   
    //A1: =SUM(C4:F7) -> =SUM(C4:F7) //no change
    cellA1 = row1.getCell(0);
    valueA1 = _evaluator.evaluate(cellA1);
    assertEquals(79, valueA1.getNumberValue(), 0.0000000000000001);
    assertEquals(Cell.CELL_TYPE_NUMERIC, valueA1.getCellType());
    testToFormulaString(cellA1, "SUM(C4:F7)");
  }
View Full Code Here

TOP

Related Classes of org.zkoss.poi.ss.usermodel.CellValue

Copyright © 2018 www.massapicom. 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.