How to add tooltip for spreadsheet cell . and how to create a custom tooltip for cell

[chandan]

Adding tooltip to spreadsheet cell and also provide custom tooltip 

[Danail Vasilev]

Hello Chandan,

Generally, the spreadsheet shows tooltips on validation - http://demos.telerik.com/kendo-ui/spreadsheet/validation

You can, however, use the approach from the Show Tooltip for Column Records article to display a custom tooltip over the spreadsheet cells. For example:

$("#spreadsheet").kendoTooltip({
   filter: ".k-spreadsheet-cell",
   position: "right",
   content: function(e){
     return e.target.children().html();
   }
 }).data("kendoTooltip");

A fully runnable dojo is available here as well - http://dojo.telerik.com/IHoPo

Regards,
Danail Vasilev
Telerik by Progress

[G.K. Raju]

 I need to show the tooltip with different information than one displayed in the cell. Given sample provides only HTML cell element, but i need information like Index or range of the cell.

[Petar]

Hi G.K. Raju,

Currently the Spreadsheet is not supporting the desired functionality.

SpreadSheet is using a special strategy for re-using the currently visible DOM elements for displaying the cells. For example, if you scroll down a longer sheet, the already rendered DOM cells will be reused to show you the next values in the current sheet. This is why, it is currently not possible to retrieve the range based on the Tooltip target element. 

Regards,
Petar
Progress Telerik

[G.K. Raju]

Are you supporting this functionality now? Is there any way to customize the tool tip?

https://docs.telerik.com/kendo-ui/controls/data-management/spreadsheet/comments

In the above demo, I could add the comments in multiple line. Please check the attached image.

But the comment tooltip is displayed in single line as shown in the attached image.

May I know how to fix this issue?

[G.K. Raju]

Are you supporting this functionality now? Is there any way to customize the tool tip?

https://docs.telerik.com/kendo-ui/controls/data-management/spreadsheet/comments

In the above demo, I could add the comments in multiple line. Please check the attached image.

But the comment tooltip is displayed in single line as shown in the attached image.

May I know how to fix this issue?

[Neli]

I am afraid that currently displaying multiline comments is not supported. If you inspect the comment element, you will see that the entered text is wrapped in a <div> and that there are no new lines. 

If it is suitable for your scenario, you could use the '.k-spreadsheet-cell-comment' class and customize the comment appearance. For example, you could set width and wrap the content of the element. Such an approach is demonstrated in the Dojo linked here. 

If you think that such an enhancement would be a valuable addition to the suite, I would encourage you to log the idea in our official Feedback Portal:

- https://feedback.telerik.com/kendo-jquery-ui

I hope this helps.

Regards,

Neli