Free Support Forum - aspose.com

Complex formula

One more problem, after entering 120 c3 should show #N/A

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)"; workbook.Save("test8.xls");

return;


This message was posted using Aspose.Live 2 Forum

Hi,

Thanks for pointing it out.

We will figure it out soon.

Thank you.

Please check http://www.aspose.com/Community/Forums/thread/110133/named-range-handling.aspx .