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.