I am using Aspose to export my reports to Excel and PDF using excel template.
Hi Sandip,
Thanks for your posting and using Aspose.Cells.
Please download and try the latest version: Aspose.Cells
for .NET v7.7.2.5 it should fix your issue.
If your problem still occurs, then please provide us your template Excel file which you are converting to PDF. We will look into this issue and update you asap.
A1 |
A1 12345 |
A1 4567 |
123456 |
987654 |
123456 |
987654 |
A1 |
A1 4567 |
A1 12345 |
Hi Sandip,
Thanks for your using Aspose.Cells.
I have tested this issue with the following code using the latest version and it generated the correct pdf.
I have attached the output pdf file for your reference. Kindly provide us your sample code which you are using to convert the file to pdf.
C#
string filePath = @“F:\Shak-Data-RW\Downloads\Report_ForAsposePDFIssue.xlsx”;
Workbook workbook = new Workbook(filePath);
workbook.Save(filePath + “.out.pdf”);
Hi,
Hi Sandip,
Thanks for using Aspose.Cells.
This is not the issue with PDF but actually the sorting is not respected after pivot table refresh. The pivot table inside the template (Report_ForAsposePDFIssue.xlsx) is sorted by the Symbol column with respect to SecurityTypeOrder, but when the pivot table is refreshed, this sorting is changed. The Symbol column gets sorted alphabetically.
We have tested this issue with the following code using the latest version. I have also attached the output xlsx file for a reference. We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.
This issue has been logged as CELLSNET-42479.
C#
string filePath = @“F:\Shak-Data-RW\Downloads\Report_ForAsposePDFIssue.xlsx”;
Workbook workbook = new Workbook(filePath);
PivotTable pt = workbook.Worksheets[“ByIssuer”].PivotTables[0];
pt.RefreshData();
pt.CalculateData();
workbook.Save(filePath + “.out.xlsx”);
Hi Sandip,
Thanks for your posting and using Aspose.Cells.
Could you provide us some specification about SecurityTypeOrder? It will help us sort out this issue at our end.
SecurityTypeOrder is of type integer and has values like 1, 2,3, 4
Hi Sandip,
Thanks for providing us more information about SecurityTypeOrder.
We have logged your provided information in our database against this issue. Once, there is some fix or other update for you, we will let you know asap.
Hi Sandip,
Thanks for using Aspose.Cells.
SecurityTypeOrder is of type integer and has values like 1, 2,3, 4, but what is the rule?
In the example file, the values are A1, A1 12345 and so on, how to calculate the integer type?
Could you provide us more detail?
The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan
@spatil-1,
Please try our latest version/fix: Aspose.Cells for .NET v21.6.3 (attached)
Aspose.Cells21.6.3 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.6.3 For .Net4.0.Zip (5.5 MB)
Aspose.Cells21.6.3 For .NetStandard20.Zip (5.5 MB)
Your issue should be fixed in it.
Let us know your feedback.