We use Aspose.Cells.GridDesktop v 184.108.40.2060.
We’ve just make a sample.
In a blank worksheet, i write value in 4 cells:
B1 --> 1
B2 --> 2
B3 --> 3
B4 --> 4
In B5, i put formula =SUM(B1:B4)
It return 1.
When i write B5 = SUM(B4:B1), it work fine.
An other problem. When I import an existing Excel File with formula in Griddesktop, formula doesn’t work.
For example, SUM(K79:K80) return #CIRCLE? or sometime #VALUE? or #DIV/0?.
Thanks for your reporting.
I have tested your issues with the latest version and I can notice the problem.
We have logged this issue in our database. Development team will look into this issue and fix the problems and we will let you know asap.
This issue has been logged as CELLSNET-40314.
But what is as soon as possible ?
1 week, 1 month …
Normally, it takes 2~3 working days, if the problem is simpler to resolve.
In case, if it is a complicated issue, it might take couple of weeks or months.
We have fixed this issue. Please download: Aspose.Cells for GridDesktop v220.127.116.112
We installed and tested the fix.
We noticed, that the "sumif" formula is still not calculating correctly.
Please find attached a simple excel-workbook for test.
In the worksheet months I use a sumif formula to calculate totals. (column total)
When I open the workbook with the actual version of the aspose.cells.griddesktop using ImportExcelFile(fileName) the totals are not calculated correctly. I also added a screenshot.
It seems to be a new feature. So I have logged a new feature request for this issue in our database.
Once, the issue is fixed or feature is available, we will let you know asap.
This issue has been logged as a New Feature Request with id: CELLSNET-40457
The issues you have found earlier (filed as CELLSNET-40314) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by aspose.notifier.
Using this update the SUMIF Formula now returns #VALUE? !
Please see attached test workbook + screenshot.
BTW: the workbook was saved with a german excel.
That did the trick!
Thank you and best regards