Question about repeating dynamic formulas in Smart Markers

Aspose.Cells Product Family
1

I’m having a little trouble since installing Cells version 4.7.1.0 a few days ago.

I have a dyanmic repeating formula in a cell of an Excel template:
&=&=SUMIF(A:A, B{r}, C:C)

For many previous versions of Cells, this formula has worked correctly. Since last weekend when I upgraded my server to 4.7.1.0, the result of this formula is after merging data into the template now looks like:
=SUMIF(A:A, B164, ‘C’:‘C’)

Before version 4.7.1.0, the result looked like:
=SUMIF(A:A, B164, C:C)
where there are no apostrophes around the third set of parameters.

So now I’m getting apostrophes around the third parameter.

I would put together a sample project to demonstrate this, but it would be really complicated to extract out this part of the system, so unless it’s absolutely necessary, I’ll save this for later.

Thanks so much for looking into this.

Mike

2

Hi,

Thanks for providing us details.

Yes, we found the issue after an initial test, we will figure it out and get back to you soon.

Thank you.

3

Hi Mike,

Thank you for considering Aspose.

Please try the attached latest version of Aspose.Cells. We have fixed your mentioned issue.

Thank You & Best Regards,

4

Hi,

I wanted to try that link out but the file is not accessible. Would you kindly make it available for me again?

Thanks,

Mike

5

Hi Mike,

Well, it should be downloadable, please use your valid user credentials and then try downloading it.

Anyways, I have attached the latest version/fix for you here. Please let us know if you can download the version fine now.

Thank you.

6

This version is accessible, so I’ll give it a try. Thank you!

Mike

7

Ah, this looks to be a 32-bit only build. Any chance you’d have the same thing that would work on 64-bit?

8

Hi,

Please try the attached version compiled on .NET2.0 for 64-bit environment.

Thanks you.

9

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

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

Note: Just for your knowledge. In the new release v4.8.0, we have merged Aspose.Grid suite to Aspose.Cells for .NET msi installer as Aspose.Grid would be no longer offered as a separate product now. You need to install the installer (uninstall older one first if you have) and use only Aspose.Cells.dll library in your project for your need. You may also take advantage using Aspose.Cells Grid suite though.