Free Support Forum - aspose.com

Problem with formula

We've run across another problem with the evaluation of formulas. Look at the cells Shares!B60:I60. They contain zeroes, but if you do the F2/Enter trick in Excel, they are recomputed to the correct values.

Thanks,
--Howard

Hi Howard,

Thanks for reporting.

After some initial test, we found the issue, we will figure it out soon.

Thank you.

Hi Howard,

Please try the fix (4.4.1.8) downloading from the thread: http://www.aspose.com/community/forums/thread/117073.aspx. And if you want to utilize the templte file (you attached in this thread), kindly reset those formulas of Shares!B60:I60. e.g., Select the cell(s), press F2 | Enter and then save the file. Aspose.Cells will read / calculate it fine and MS Excel will display the correct values.

Thank you.