This is a migrated thread and some comments may be shown as answers.

On Hover

4 Answers 233 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Marc
Top achievements
Rank 1
Marc asked on 11 Jan 2017, 11:11 AM

Hi, is there any kind of on hover event, which can show the selected cell(s) value(s) in a small pop up?

Thanks!

Marc

4 Answers, 1 is accepted

Sort by
0
Accepted
Dimiter Topalov
Telerik team
answered on 13 Jan 2017, 07:55 AM
Hello Marc,

The closest to the desired functionality that I can currently suggest, is wrapping the Spreadsheet in a Tooltip, and using the class of the cells - "k-spreadsheet-cell" as a filter, then retrieving the content for the tooltip via jQuery/JavaScript, e.g.:

http://dojo.telerik.com/EzEYE/2

Unfortunately, there is no hover event that the Spreadsheet or its components (Sheet, Range) expose, and also the implementation of the widget is such that there is no correlation between the rendered DOM elements, and the selected state of the cell(s), which is why the desired functionality cannot be achieved.

If you have the time, please submit a feature request to our UserVoice portal:

http://kendoui-feedback.telerik.com/forums/127393-kendo-ui-feedback

...for any functionality that you think might improve the quality of our product. The most popular suggestions are considered for future versions of Kendo UI. Thank you in advance.

Regards,
Dimiter Topalov
Telerik by Progress
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
0
Marc
Top achievements
Rank 1
answered on 13 Jan 2017, 07:57 AM

Hi Dimiter

I completely understand why the spreadsheet acts like this - ours users are being a bit far fetched asking for the tooltip, but I thought I'd check before I tell them its not really possible!

0
Accepted
Dimiter Topalov
Telerik team
answered on 13 Jan 2017, 09:21 AM
Hi Marc,

After inspecting the task further, I came up with a solution, closer to the desired functionality. It involves using the Sheet's selection() method, and the resulting range's value() method to provide the content for the Tooltip.

In this scenario the tooltip content has to be refreshed (for example in the show event handler) so that it reflects the newly selected range from the spreadsheet:

http://dojo.telerik.com/EzEYE/4

I hope this helps, but please note that typically custom scenario implementations fall outside the scope of our support service, and in the scope of our Progress Professional Services:

https://www.progress.com/services

If you decide to benefit from what they have to offer in the future, please let me know, and I will arrange for someone from the team to contact you.

Regards,
Dimiter Topalov
Telerik by Progress
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
0
Marc
Top achievements
Rank 1
answered on 13 Jan 2017, 09:24 AM

Hi Dimiter,

This is a great solution and seems to work almost perfectly! The only downside is no tooltip is shown when only 1 cell is selected, but I will check this and work on it.

Thank you again!

Marc

Tags
Spreadsheet
Asked by
Marc
Top achievements
Rank 1
Answers by
Dimiter Topalov
Telerik team
Marc
Top achievements
Rank 1
Share this question
or