I attached a sample project and screenshots describing the issue. We need to get a pivot grid with a style as in the Required.xlsx file (in the execution folder). To achieve this we use the following code snippet:
Once we execute the code we get a file Result.xlsx. On the screenshot Issue.png you may see the issue. On a screenshot MyExtraAction.png - my actions to get a style similar to Required.xlsx. In other words using Aspose we cannot get a pivot table with ability to drag headers.
Could you please provide me a way to get a style like in the Required.xlsx file using Aspose.
Thank you for your efforts to compile a sample project for us. We have reviewed your project and have found out that one of your source code lines as below,
works fine if file is saved in XLS (Excel 2003) format but not with XLSX (Excel 2007/2010) format. So we have logged the issue under TicketID CELLSNET-26146. Soon we’ll get back to you on this.