Spreadsheet -- Mutli-column header

[GVPraveen]

Hi Team ,

Do kendo spreadsheet (Angular) support  Mutli-column header feature, could you please provide us with some help on the same earliest. 

Note: I have highlighted the Muti column header feature in sky blue color for your reference.

[Veselin Tsvetanov]

Hello,

You can configure a multi-column header in the Spreadsheet by passing the appropriate initial options for the widget. The following example demonstrates such a scenario:

https://demos.telerik.com/kendo-ui/spreadsheet/index

Note the value set for the first cell on the first row:

rows: [
                        {
                            height: 70,
                            cells: [
                                {
                                    index: 0, value: "Invoice #52 - 06/23/2015"...

And the mergedCells configuration:

mergedCells: [
  "A1:G1",
  "C15:E15"
],

In case the Sheet is bound to a DataSource, you should inject a custom header as shown in this article:

https://docs.telerik.com/kendo-ui/knowledge-base/spreadsheet-with-datasource-insert-header-and-footer

Note that you will need to merge the required cells to display the multi-column header properly. Keep in mind that this approach is not applicable if the data is edited and saved using the other DataSource transport methods (Update, Create, and Destroy). Such scenarios do not support the insertion of a custom header or footer.

Regards,
Veselin Tsvetanov
Progress Telerik