Expected different behavior of formula SUM

Aspose.Cells Product Family
1

Hello,

currently I try some basic formulas with version 7.4.1. For example, if I use code like this :

worksheet.Cells[0, 0].Value = 1;
worksheet.Cells[1, 0].Value = 1;
worksheet.Cells[2, 0].Value = 1;

worksheet.Cells[0, 1].Formula = "=SUM(A0:A3)";
worksheet.Cells[0, 2].Formula = "=SUM(A1:A3)";

On "=SUM(A0:A3)" I expect cell value like #VALUE!, because this formula is definitely wrong. But your application (or excel) transforms this formula to "=SUM(A3:A65536)". I'm a little confused on other basic formulas or more complex formulas.

Many Thanks

2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

After initial investigation, we found the problem with your sample code. We have logged this issue in our database. We will look into this issue and fix it.

Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-41499.

C#


Workbook workbook = new Workbook();

Worksheet worksheet = workbook.Worksheets[0];


worksheet.Cells[0, 0].Value = 1;

worksheet.Cells[1, 0].Value = 1;

worksheet.Cells[2, 0].Value = 1;


worksheet.Cells[0, 1].Formula = “=SUM(A0:A3)”;

worksheet.Cells[0, 2].Formula = “=SUM(A1:A3)”;


workbook.Save(“out.xlsx”);

3

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

We have fixed the issue.

Please download and try this fix: Aspose.Cells for .NET v7.4.1.4 and let us know your feedback.

4

Hi,

thank you for your effort - it works fine!

Greetings

5

Hi,

Thanks for your posting and using Aspose.Cells.

We are glad to know that your issue is fixed with the latest version. If you encounter any other issue, please feel free to post on our forums, we will be happy to help you more.

6

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

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