Adding Column Header Tooltips and Collapsible columns based on Groups

[Jatin Gundabathula]

Hi Team,

 I have a two requirements please help:

1. To add on Cell  hover tooltips for column headers. 

          I tried to go through the xlsIO documentation but no where found the details related to this. expectations is when user hovers the column headers cell the small help text notes should be visible.

2. Need a feature to have couple of columns should be collapsible like grouping of the column which are of same user defined category.

It would be great if you can provide working samples for above two requirements or any related information it would be helpful

Thanks in advance.

[Shamini Kiruba Sobers]

Hi Jatin, 

Please find the response for your queries in the below table. 

Query	Response
1. To add on Cell  hover tooltips for column headers.             I tried to go through the xlsIO documentation but no where found the details related to this. expectations is when user hovers the column headers cell the small help text notes should be visible.	You can add comments in Excel to give feedback about the content of a cell. By default, a comment can be seen only when you hover over the cell that contains the comment.    Kindly look into the following link to add comments in Excel cell using XlsIO.  https://help.syncfusion.com/file-formats/xlsio/migrate-from-office-automation-to-syncfusion-xlsio/add-comments-in-excel#xlsio  Please note that, when a cell has comment, a red triangle will be displayed in the upper-right corner of the cell and when you hover over the cell, the comment will be shown as in the below screenshots.  #Cell D2 has a note    #Enclosed note is shown when hovered over the cell
2. Need a feature to have couple of columns should be collapsible like grouping of the column which are of same user defined category.	Kindly look into the following link to group columns as per your requirement.  https://help.syncfusion.com/file-formats/xlsio/worksheet-rows-and-columns-manipulation?cs-save-lang=1&cs-lang=asp.net%20core#group-or-ungroup-rows-and-columns

You can download the working sample with the above two features from the following link. 

https://www.syncfusion.com/downloads/support/directtrac/general/ze/F152630-640717010 

Kindly let us know whether the solution helps. 

Regards, 

Shamini. 

[Jatin Gundabathula]

Thanks for information we have implemented this feature as suggested its working as expected. so we can close this thread.

[Shamini Kiruba Sobers]

Hi Jatin, 

Thanks for the update. We are glad that the provided information helped you. 

Regards, 

Shamini