示例#1
0
 private static void assertFormulaResult(CellValue cv, ICell cell)
 {
     double actualValue = cv.NumberValue;
     double expectedValue = cell.NumericCellValue; // cached formula result calculated by Excel
     Assert.AreEqual(CellType.Numeric, cv.CellType, "Invalid formula result: " + cv.ToString());
     Assert.AreEqual(expectedValue, actualValue, 1E-4); // should agree within 0.01%
 }