Complex formula

Aspose.Cells Product Family
1

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
2

Hi,

Thanks for pointing it out.

We will figure it out soon.

Thank you.

3

Please check <A href="https://forum.aspose.com/t/93751 .