Pivot Table cell truncated

Aspose.Cells Product Family
1

Hello,

We have an application where users can download data from a grid, add Pivot tables that work off of the downloaded data and then re-upload the spreadsheet with the new Pivot table. Users can then download the new spreadsheet with updated data and the Pivot table will automatically update when refreshed (either automatically or when manually refreshed). However, whenever users refresh the Pivot table any cell in the Pivot table with more than 255 characters is truncated to 255. This happens whether the Pivot table is set to automatically update or whether a user manually updates the Pivot table. Our code does not touch the Pivot table, we only update/download the grid data. So, we’re trying to determine if this is a problem with the Aspose code or whether this an issue in Excel itself. Note that this happens in Excel 2007/2010 and we have a sample application that we can send you if needed.

Thanks.
2

Hi,

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

The max length of the string parameter is 255 in MS-Excel, may be this is causing the issue.

However, please provide us your sample project replicating this issue with the latest version: Aspose.Cells
for .NET v7.3.5.1.

We will look into your issue in detail and help/advise you asap.


3

Thanks for the feedback. It seems that the issue may be fixed in the latest version of Aspose.Cells. We are still testing but will let you know if it does not work.

4

Hi,


Good to know that your issue seems to be fixed by the latest version/fix.
And, yes, sure, we can wait for your feedback once you have done with your checking.

Thank you.
5
shawnt34:
Thanks for the feedback. It seems that the issue may be fixed in the latest version of Aspose.Cells. We are still testing but will let you know if it does not work.

Hi,

Thanks for providing us your feedback.

We have already fixed such issues, so we think, you should not encounter this issue anymore. Please keep us updated. We will be glad to help you further.

Besides, we also recommend you to download and give a try to latest offline demos of Aspose.Cells which you can find from theses links. These demos will help you get familiar with Aspose.Cells API(s) quickly.

These demos can work with Visual Studio 2005, 2008 or 2010. Please read the readme.txt file before running the demos.