如何通过悬停或点击谷歌电子表格中的单元格来运行自定义函数? [英] How to run custom function by hovering or clicking on cell in google spreadsheet?
问题描述
我需要帮助来制作一张桌子,其中有一个单元格作为产品缩略图,通过悬停或点击这个小图片,我想以产品的大图形显示出来。
(现在它可以作为超链接使用,但还不够)
我知道我们有几种方法现在运行功能:自定义电子表格功能中的 有什么办法可以触发像悬停或点击单元格的事件吗? 我有一些想法是正确的现在: 我知道这是一个类似的问题:此和这是,但它们已经很老了,谷歌自2014年12月11日起开始进行API更新。
I need help to make a table which will have a cells as product thumbnails and by hovering or clicking on this small image, I want to show the pop up with big image of product.
(Right now it works as hyperlink, but it is not enough)
I know we have a few ways how to run function right now:
- from a custom spreadsheet function
- from a trigger (from spreadsheet like on open, on edit or on form submit, or Time driven)
- from a custom menu (which must be created by e.g. on open)
- from a custom user interface (which must be created by e.g. on open)
- from a drawing or chart
- from the script editor
Is there any way how we can trigger event like hover or click on cell in table?
I have a few ideas right now :
- Some how place big image in comment or note in cell.
- Make a custom function which will return image/chart/drawing as a value and apply function for this image/chart/drawing. But seems we should have much more easy way to do it =)
I know this is a similar question as: This and This but they are old and google has made an API update since December 11, 2014.
- Add an Image ( Insert > Image ) to your sheet.
- Resize and Move it to fit your needs.
- Click the drop-down symbol in the upper right corner of the image.
- Select 'Assign Script'
- Enter the name of the script you wish to run.
这篇关于如何通过悬停或点击谷歌电子表格中的单元格来运行自定义函数?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!