OFFSET function calculation issues

Aspose.Cells Product Family
1

Hello,

We’ve encountered some issues with Excel formula calculation, when performing Workbook.CalculateFormula(…), we’ve noticed some differences between Aspose calculation and Excel calculation.

The OFFSET function from the OffsetHeight.xlsx file seems to be calculated incorrectly by Aspose - #REF! instead of 4 (expected value from Excel).

Aspose.Cells version used is 7.3.0.5 .

Please investigate these issues and provide us some feedback.

Thanks in advance,
Mihai Andrei,
Sr. Software Engineer,
IBM Romania

2

Hi,


I can find the issue as you have mentioned. I have logged a ticket with an id: CELLSNET-40975. We will look into your issue to figure it out soon.

Thank you.
3

Hi,


Please try the new fix: Aspose.Cells for .NET v7.3.0.6

We have fixed your issue regarding OFFSET function now.

Thank you.

4

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

This message was posted using Notification2Forum from Downloads module by aspose.notifier.