public void IfGettingCachedFormulaTypeShouldNotThrowErrorIfCellTypeIsNumeric()
{
_objectToTest = new SXSSFCell(null, CellType.Formula);
_objectToTest.SetCellFormula("SUM(C4:E4)");
Assert.AreEqual(CellType.Numeric, _objectToTest.CachedFormulaResultType);
}
public void TestEvaluateSimple()
{
SXSSFWorkbook wb = new SXSSFWorkbook(5);
SXSSFSheet s = wb.CreateSheet() as SXSSFSheet;
IFormulaEvaluator eval = wb.GetCreationHelper().CreateFormulaEvaluator();
SXSSFCell c = s.CreateRow(0).CreateCell(0) as SXSSFCell;
c.CellFormula = (/*setter*/ "1+2");
Assert.AreEqual(0, (int)c.NumericCellValue);
eval.EvaluateFormulaCell(c);
Assert.AreEqual(3, (int)c.NumericCellValue);
c = s.CreateRow(1).CreateCell(0) as SXSSFCell;
c.CellFormula = (/*setter*/ "CONCATENATE(\"hello\",\" \",\"world\")");
eval.EvaluateFormulaCell(c);
Assert.AreEqual("hello world", c.StringCellValue);
}
public void TestEvaluateRefInsideWindow()
{
SXSSFWorkbook wb = new SXSSFWorkbook(5);
SXSSFSheet s = wb.CreateSheet() as SXSSFSheet;
IFormulaEvaluator eval = wb.GetCreationHelper().CreateFormulaEvaluator();
SXSSFCell c = s.CreateRow(0).CreateCell(0) as SXSSFCell;
c.SetCellValue(1.5);
c = s.CreateRow(1).CreateCell(0) as SXSSFCell;
c.CellFormula = (/*setter*/ "A1*2");
Assert.AreEqual(0, (int)c.NumericCellValue);
eval.EvaluateFormulaCell(c);
Assert.AreEqual(3, (int)c.NumericCellValue);
wb.Close();
}
public void IfSettingCellFormulaShouldReturnSetForCellTypeFormula()
{
_objectToTest = new SXSSFCell(null, CellType.Formula);
_objectToTest.CellFormula = "SUM(C4:E4)";
Assert.AreEqual("SUM(C4:E4)", _objectToTest.CellFormula);
}
public void IfGettingCellFormulaShouldReturnFormulaValueIfValidCellType()
{
_objectToTest = new SXSSFCell(null, CellType.Formula);
_objectToTest.SetCellFormula("SUM(C4:E4)");
Assert.AreEqual("SUM(C4:E4)", _objectToTest.CellFormula);
}
public void IfCellTypeIsFormulaBooleanCellValueShouldReturnTrueIfValidBooleanFormulaValue()
{
_objectToTest = new SXSSFCell(null, CellType.Formula);
Assert.IsFalse(_objectToTest.BooleanCellValue);
}
public void IfCellTypeIsBlankBooleanCellValueShouldReturnFalse()
{
_objectToTest = new SXSSFCell(null, CellType.Blank);
Assert.IsFalse(_objectToTest.BooleanCellValue);
}
public void IfSettingFormulaValueWithNullShouldChangeToBlankCell()
{
_objectToTest = new SXSSFCell(null, CellType.Formula);
_objectToTest.SetCellFormula(null);
Assert.AreEqual(CellType.Blank, _objectToTest.CellType);
}
public void IfSettingCellErrorValueAndIsFormulaErrorShouldSetFormulaErrorValue()
{
_objectToTest = new SXSSFCell(null, CellType.Numeric);
_objectToTest.SetCellErrorValue(FormulaError.DIV0.Code);
Assert.AreEqual((byte)7, _objectToTest.ErrorCellValue);
}
public void IfSettingFormulaValueShouldSetFormulaValue()
{
_objectToTest = new SXSSFCell(null, CellType.Formula);
_objectToTest.SetCellFormula("SUM(C4:E4)");
Assert.AreEqual("SUM(C4:E4)", _objectToTest.CellFormula);
}
public void IfSettingCellErrorValueShouldSetValue()
{
_objectToTest = new SXSSFCell(null, CellType.Error);
_objectToTest.SetCellErrorValue((byte)(0x00));
Assert.AreEqual((byte)0x00, _objectToTest.ErrorCellValue);
}
public void IfCellTypeIsNumericCellValueShouldReturnValue()
{
_objectToTest = new SXSSFCell(null, CellType.Formula);
_objectToTest.SetCellValue(9);
Assert.AreEqual(9, _objectToTest.NumericCellValue);
}
public void IfCellTypeIsFormulaNumericCellValueShouldReturnPreEvaluatedFormulaValue()
{
_objectToTest = new SXSSFCell(null, CellType.Formula);
_objectToTest.SetCellFormula("SUM(C4:E4)");
Assert.AreEqual(0.0, _objectToTest.NumericCellValue);
}
public void IfCellTypeIsBlankNumericCellValueShouldReturnZero()
{
_objectToTest = new SXSSFCell(null, CellType.Blank);
Assert.AreEqual(0.0, _objectToTest.NumericCellValue);
}
public void IfSettingNullCellFormulaShouldReturnSetCellTypeToBlank()
{
_objectToTest = new SXSSFCell(null, CellType.Formula);
_objectToTest.CellFormula = null;
Assert.AreEqual(CellType.Blank, _objectToTest.CellType);
}
