I am having an issue with Aspose Cells version 18.6.0 (Latest version 19.8 has the same issue).
I have this pivot table that groups by date column (per Month), the months I have are August and September but my PDF shows the incorrect months, PDF shows April and Jun and rows are not in the correct order either, no idea why it displays April and Jun, my data source does not have those months.
Please see the attached project with a sample app in order to duplicate issue.
Follow these easy steps:
- Unzip and run the attached project.
- Notice I included a sample excel file that was also generated by AsposeCells at some point in my application. The name of the sample file I attach in the same zip file is “SampleFile.xlsx”
- From the app, select this excel file, it gets converted to PDF, open the excel file and compare it with the generated PDF, they do not match at all. I call a bunch of “refresh” methods (you can see in the code) but the issue still there, generated pdf is different from the original excel file.
Is there a workaround for this issue? or am I missing something?
Sample Project.zip (322.0 KB)