SUM in GridDesktop Worksheet

Aspose.Cells Product Family
1

Hi,

We use Aspose.Cells.GridDesktop v 2.7.2.2000.
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?.

Regards Pascal.

2

Hi,

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.

3

Thanks,

But what is as soon as possible ?
1 week, 1 month …

Regards

4

Hi,

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.

5

Hi,

We have fixed this issue. Please download: Aspose.Cells for GridDesktop v2.7.3.2002

6

Hi!

We installed and tested the fix.

We noticed, that the "sumif" formula is still not calculating correctly.

Best regards

Christian Bauer

www.dox42.com

7

Hi,


Regarding “SUMIF” formula issue, kindly do create a sample winform application, zip it and pot it here to show the issue, we will check your issue soon.

Thank you.
8

Hi!

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.

Best regards

Christian Bauer

9

Hi,

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

10

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.
11

Hi

Using this update the SUMIF Formula now returns #VALUE? !

Please see attached test workbook + screenshot.

BTW: the workbook was saved with a german excel.

Best regards

Christian Bauer

www.dox42.com

12

Hi,


Please use the line when you import/load the file to GridDesktop:
this.gridDesktop1.ImportExcelFile(“e:\test2\SalesReportTest.xls”, false);


Thank you.
13

That did the trick!

Thank you and best regards

Christian Bauer