how Telerik RadSpreadsheet can show grouping?

Question

I used RadSpreadsheet in wpf and made an excel like application, but there is a problem when I open excel files containing grouped cells.

excel showing grouped cells

telerik can't show grouping

How can I show grouping in telerik?

Answer 1

Grouping is not supported in the UI of RadSpreadsheet control (see Spreadsheet: Grouping (Outline) feature request).

Still, such documents can be created, imported and exported, as the feature is supported in the document model (Grouping | Telerik Document Processing), e.g.:

Workbook workbook = new Workbook(); 
Worksheet worksheet = workbook.Worksheets.Add(); 
worksheet.Columns[0].SetOutlineLevel(1); 
worksheet.Columns[1, 2].SetOutlineLevel(2); 
worksheet.Columns[3].SetOutlineLevel(1);