Hi,
first I want to say, that I am really surprised about the speed improvements of the current release. After upgrading to q2/14 the speed of excel export was improved from about 14 minutes to approx. 45 seconds. Report size: 7000 rows, 40 columns
Furthermore I have one suggestions for the excel export and cross tables. Maybe you can realize them or maybe it is already planned.
When exporting to excel it will be good, if the groupings are also available in excel. I know that they are built up by merging the appropriate cells, but it will be better if you use the native excel function for this, that a user is able to collapse the rows in excel, too.
Regards
Karsten
first I want to say, that I am really surprised about the speed improvements of the current release. After upgrading to q2/14 the speed of excel export was improved from about 14 minutes to approx. 45 seconds. Report size: 7000 rows, 40 columns
Furthermore I have one suggestions for the excel export and cross tables. Maybe you can realize them or maybe it is already planned.
When exporting to excel it will be good, if the groupings are also available in excel. I know that they are built up by merging the appropriate cells, but it will be better if you use the native excel function for this, that a user is able to collapse the rows in excel, too.
Regards
Karsten
1 Answer, 1 is accepted
0
Hi Karsten,
Thank you for your feedback.
Our Excel rendering mechanism renders the latest saved state of the report without applying Excel groupings if there are toggle visibility actions in the report.
Having into account the Design Considerations for Excel Rendering , using the native Excel groups to provide collapse/expand functionality in Excel may not work for all scenarios. Adding the feature would require the whole Excel rendering mechanism to be changed.
Our suggestion is to export the report with all sections expanded. This can be ensured by exporting programmatically an instance of the report, where you have set the sections visibility as needed (after instantiating a report you have access to all items through its Items collection).
Regards,
Stef
Telerik
Thank you for your feedback.
Our Excel rendering mechanism renders the latest saved state of the report without applying Excel groupings if there are toggle visibility actions in the report.
Having into account the Design Considerations for Excel Rendering , using the native Excel groups to provide collapse/expand functionality in Excel may not work for all scenarios. Adding the feature would require the whole Excel rendering mechanism to be changed.
Our suggestion is to export the report with all sections expanded. This can be ensured by exporting programmatically an instance of the report, where you have set the sections visibility as needed (after instantiating a report you have access to all items through its Items collection).
Regards,
Stef
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.