public void TestBlankCellChangedToValueCell()
{
TestCases.CultureShim.SetCurrentCulture("en-US");
MySheet ms = new MySheet();
ms.SetCellFormula("A1", "B1+2.2");
ms.SetCellValue("B1", 1.5);
ms.ClearAllCachedResultValues();
ms.ClearCell("B1");
ms.GetAndClearLog();
ConfirmEvaluate(ms, "A1", 2.2);
ConfirmLog(ms, new String[] {
"start A1 B1+2.2",
"end A1 2.2",
});
ms.SetCellValue("B1", 0.4);
ConfirmLog(ms, new String[] {
"changeFromBlank B1 0.4",
"clear A1",
});
ConfirmEvaluate(ms, "A1", 2.6);
ConfirmLog(ms, new String[] {
"start A1 B1+2.2",
"hit B1 0.4",
"end A1 2.6",
});
}
public void TestBlankCellChangedToValueCell()
{
System.Threading.Thread.CurrentThread.CurrentCulture = System.Globalization.CultureInfo.CreateSpecificCulture("en-US");
MySheet ms = new MySheet();
ms.SetCellFormula("A1", "B1+2.2");
ms.SetCellValue("B1", 1.5);
ms.ClearAllCachedResultValues();
ms.ClearCell("B1");
ms.GetAndClearLog();
ConfirmEvaluate(ms, "A1", 2.2);
ConfirmLog(ms, new String[] {
"start A1 B1+2.2",
"end A1 2.2",
});
ms.SetCellValue("B1", 0.4);
ConfirmLog(ms, new String[] {
"changeFromBlank B1 0.4",
"clear A1",
});
ConfirmEvaluate(ms, "A1", 2.6);
ConfirmLog(ms, new String[] {
"start A1 B1+2.2",
"hit B1 0.4",
"end A1 2.6",
});
}