Inconsistent behaviour to Excel where using references to empty cells

G7 in excel gives me 60.17 and aspose gives me 0

Workbook workbook = new Workbook();
Worksheet orders = workbook.Worksheets[0];
orders.Name = "orders";
Range range = orders.Cells.CreateRange("A2", "A2");
range.Name = "OPENLEVEL";
orders.Cells["A2"].PutValue(60.17);
orders.Cells["G7"].Formula = "=ROUND(0.01*ROUNDDOWN(ROUND(MIN(OPENLEVEL,IF(60.19<MIN(IF(60.19<OPENLEVEL,OPENLEVEL,Z1),60.2945),60.19,Z1))/0.01,9),0),9)";
workbook.CalculateFormula();
object o = orders.Cells["G7"].Value;
Console.WriteLine(o);
workbook.Save("test8.xls");

Hi,

Thanks for providing us sample code.

Yes, we found the issue after an initial test, we will figure it out soon.

Thank you.

Hi,

We are working on your issue, hopefully we can provide a fix soon.

Thanks for your patience.

Hi,

Please try this fix.

We have fixed the bug of calculating formulas.

The issues you have found earlier (filed as 6786) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by Laurence.