本文整理匯總了C#中NPOI.HSSF.UserModel.HSSFFormulaEvaluator.NotifySetFormula方法的典型用法代碼示例。如果您正苦於以下問題：C# HSSFFormulaEvaluator.NotifySetFormula方法的具體用法？C# HSSFFormulaEvaluator.NotifySetFormula怎麽用？C# HSSFFormulaEvaluator.NotifySetFormula使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類NPOI.HSSF.UserModel.HSSFFormulaEvaluator的用法示例。
在下文中一共展示了HSSFFormulaEvaluator.NotifySetFormula方法的1個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的C#代碼示例。
示例1: TestMissingArg
public void TestMissingArg()
{
HSSFWorkbook wb = new HSSFWorkbook();
ISheet sheet = wb.CreateSheet("Sheet1");
IRow row = sheet.CreateRow(0);
ICell cell = row.CreateCell(0);
cell.CellFormula = "1+IF(1,,)";
HSSFFormulaEvaluator fe = new HSSFFormulaEvaluator(wb);
CellValue cv;
try
{
cv = fe.Evaluate(cell);
}
catch (Exception)
{
throw new AssertionException("Missing arg result not being handled correctly.");
}
Assert.AreEqual(CellType.Numeric, cv.CellType);
// Adding blank to 1.0 gives 1.0
Assert.AreEqual(1.0, cv.NumberValue, 0.0);
// check with string operand
cell.CellFormula = "\"abc\"&IF(1,,)";
fe.NotifySetFormula(cell);
cv = fe.Evaluate(cell);
Assert.AreEqual(CellType.String, cv.CellType);
// Adding blank to "abc" gives "abc"
Assert.AreEqual("abc", cv.StringValue);
// check CHOOSE()
cell.CellFormula = "\"abc\"&CHOOSE(2,5,,9)";
fe.NotifySetFormula(cell);
cv = fe.Evaluate(cell);
Assert.AreEqual(CellType.String, cv.CellType);
// Adding blank to "abc" gives "abc"
Assert.AreEqual("abc", cv.StringValue);
}