We are evaluating the Aspose.Cells SSRS rendering extensions to give us the ability to export to Excel 2007 and I just ran into an issue that I am hoping you can help me out with.
The report was designed in SSRS 2008 and uses a Matrix to pivot the data.
Attached you will find the same report exported twice to Excel 2007 ( I have removed the data from the resulset). V1 was run with a resulset of 100,000 rows and V2 was only run with a resultset of 1,000 rows.
As you can on the version with 1,000 rows (V2), the pivoted headers display properly. On the V1 version those columns are unmerged and display as individual columns.
For some reason when I have a large resultset any column groupings become unmerged.
I am not sure if this has something to do with the trial version I downloaded. The dll version is 126.96.36.199.