Named range handling

Aspose.Cells Product Family
21

works, thank you

22

Object reference not set to an instance of an object.
Error in calculating cell C3 in Worksheet orders

License license = new License();

license.SetLicense("Aspose.Cells.lic");

Workbook workbook = new Workbook();

Worksheet orders = workbook.Worksheets[0];

Worksheet hidden = workbook.Worksheets.Add("hidden");

orders.Name = "orders";

orders.Cells.CreateRange("A1", "A1").Name = "OPENLEVEL";

orders.Cells["A1"].PutValue("enter 120 here");

orders.Cells["C3"].Formula = "=ROUND(0.005*ROUNDDOWN(ROUND(MIN(OPENLEVEL,MIN(IF(111.153687602964>OPENLEVEL,OPENLEVEL,NA()),IF(110.958687602964>OPENLEVEL,OPENLEVEL,NA())))/0.005,9),0),9)";

orders.Cells["A1"].PutValue(90);

workbook.CalculateFormula();

object v = orders.Cells["C3"].Value;

workbook.Save("test8.xls");

return;

23

In previous quick build, I only add support for parsing NA function. Please try this attached version, now calculating NA function is also supported.