Spreadsheet -- Mutli-column header
1 Answer 8 Views
GVPraveen
Top achievements
Rank 1
GVPraveen asked on 15 Jul 2021, 09:54 AM

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.


1 Answer, 1 is accepted

Sort by
0
Veselin Tsvetanov
Telerik team
answered on 20 Jul 2021, 08:17 AM

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

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Asked by
GVPraveen
Top achievements
Rank 1
Answers by
Veselin Tsvetanov
Telerik team
Share this question
or