This is a migrated thread and some comments may be shown as answers.

Grouping workaround

3 Answers 22 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Adrian
Top achievements
Rank 1
Adrian asked on 28 Mar 2013, 08:51 PM
I know that grouping is currently not supported, but I was wondering if there is any suggested workaround for it...Currently, we are using a radgridview (which supports grouping) that we are exporting to excel. I have been able to use the spreadsheet control to handle the export, and that works great, the only piece missing is the group headers. The only thing I could think to do is loop through the spreadsheet and insert rows with the appropriate header when applicable (since it is exported sorted correctly). This works also, but it takes a lot of time. 

Are there any other ways to accomplish this?

Any suggestions would be greatly appreciated.

Thanks!!

3 Answers, 1 is accepted

Sort by
0
Iva Toteva
Telerik team
answered on 02 Apr 2013, 10:29 AM
Hello Adrian,

RadSpreadsheet does not support grouping yet. We have this feature in our roadmap and once implemented, we will also make sure to extend the export and import from/to XLSX, so that such documents can be correctly persisted.

In the meantime, the only possible workaround would be to manually insert a row with the content of your heading. Unfortunately, there is no faster way to achieve the same look.

Let us know if you have other questions.

Greetings,
Iva Toteva
the Telerik team

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

0
René
Top achievements
Rank 1
answered on 29 Nov 2013, 03:49 PM
Hi Iva, 

Thanks for the answer. I'm also interested in the grouping feature. Can you say something when it can be expected?

Thanks a lot,
René

0
Petya
Telerik team
answered on 03 Dec 2013, 03:10 PM
Hi René,

Thank you for your interest in RadSpreadsheet!

Unfortunately we are still unable to comment on a particular time-frame for the grouping feature. Generally our roadmap is greatly influenced by the demand for particular features, so your feedback in this regard is greatly appreciated.

Let us know should you have any other comments or questions.

Regards,
Petya
Telerik
TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for SILVERLIGHT.
Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
Sign up for Free application insights >>
Tags
Spreadsheet
Asked by
Adrian
Top achievements
Rank 1
Answers by
Iva Toteva
Telerik team
René
Top achievements
Rank 1
Petya
Telerik team
Share this question
or