Pivot Tables

Do you know of any issues with ASPOSE.Cells and Pivot tables? We are using the Aspose.Cells dll version 4.5.0.3. We are having an issue that is giving us an error that says “The PivotTable field name is not valid. To create a PivotTable report, you must use data that is organized as a list with labeled columns. If you are changing the name of a PivotTable field, you must type a new name for the field.” It seems we see this error randomly throughout our environments, and we end up messing with our template and the error temporarily goes away.

Here’s what we are doing… We have a template where we put our columns with smart markers for the data. We then create a pivot table by selecting the columns and the smart markers. We set up our pivot table how we want and set it up so that the pivot table refreshes when the document is opened. We then get our datatables from the database, set the datasources and then use the process method. We then save the designer in Excel 2003 format. If we save the document to our desktop before opening it, then everything works correctly. If we open it from the browser we get the above error. The data does not change between the two scenarios; therefore we think ASPOSE is causing the problem.

Hi,

Well, we are not not very sure about the error you are getting, could you try our latest version: http://www.aspose.com/community/files/51/file-format-components/aspose.cells-for-.net-and-java/entry167012.aspx and let us know if it works fine.

If you still find the issue, we appreciate if you could create a simulation project (with code), template excel file, created excel file etc., zip the project and post us here, we will check your issue soon.

Also, for your info, there is only one known issue regarding pivot tables, but it can be fixed by using SaveType.OpenInBrowser instead of SaveType.OpenInExcel, please check the doc topic: http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/pivot-table-issue.html

Thank you.