We have SQL Server 2008 R2 and using rendering extension directly to export the excel output. Facing excel exporting issue with the Aspose.Cells, Currently the version used is Aspose.Cells for Reporting Services 1.8.0
The issues we are facing are related to formatting and performance.
1. Formatting issue :- After exporting the report using excel option of Aspose Cells
We observe that the extra rows are added above each group, extra empty columns are added and the formatting of dash (-) in the amount fields is replaced by “-” (inverted commas are added). This particular output when exported using Excel option provided by SQL Server 2008 R2 works fine with no formatting issue.
2. Performance:- The Aspose Cell excel export takes almost 5-7 times more time to export the output as compared to excel option provided by SQL Server 2008 R2. Secondly, we need to use “Subscription” to generate the output when using Aspose Cell Excel option
We tried using new version released for Aspose.Cells (Aspose.Cells for Reporting Services1.9.0) by installing locally but it did not solve the above issue.
Need to fix this issue as soon as possible as we are about to go production this friday.