Adding Column Header Tooltips and Collapsible columns based on Groups

Question

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 · Answer

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 · Answer

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

Shamini Kiruba Sobers · Answer

Hi Jatin, 

Thanks for the update. We are glad that the provided information helped you. 

Regards, 
Shamini

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