Free Support Forum - aspose.com

Name Error: Setting SUM formula when summing multiple sheets

Hello,

I have a strange problem with aspose when trying to set the formula below.

I am summing a cell across multiple sheets.

sheet1.Cells("N12").Formula = "=SUM(CALIFORNIA:MASSACHUSETTS!L12)"


The above code generates on the excel like this:

=SUM('CALIFORNIA:MASSACHUSETTS!L12')

Somehow, aspose is injecting a single qoute before CALIFORIA and after MASSACHUSETTS. This causes the excel to display a #NAME? error.

I'm generating an XLS file.

I'm using aspose 4.8.0.4

Thanks,
Tai

Hi,

After an initial test, I have found the issue as you have mentioned. We will figure it out soon.

Your issue has been logged into our issue tracking system with an issue id: CELLSNET-16990.

Thank you.

Here's more info for you.

In version 4.5.1.0, this feature was working fine.

Hi,

We have fixed your mentioned issue, please try the attached version.

Thank you.

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


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

While trying to keep the API as straightforward and clear as possible, we have decided to recognize and honor the common development practices of the platform; we have re-arranged API Structure/ Namespaces.

With this release, we have reorganized the API classes for Aspose.Cells component. This change has some major aspects that we follow. We have added new namespaces. The entire API (classes, interfaces, enumerations, structures etc.) were previously located in the Aspose.Cells namespace. Now, certain sets of API have been moved to their relative namespaces, which make the relationship of classes (with their members) and namespaces clear and simplified. It is to be noted here, we have not renamed existing API (classes, enumerations etc.) but, I am afraid you still need to make certain adjustments in your existing projects accordingly.

For complete reference, please see the product's API Reference.