Can I somehow dock the searchbox (ctrl +f) or crea

2019-08-30 16:24发布

问题:

I have been searching for a while now but I cannot find an answer to the following question; Is it possible to dock or show the searchbox from Google Sheets somewhere so that it is always visible? I have some experience with Google Apps Script so any solution from that perspective is also fine!

Ps. I can't use a sidebar.

Regards

回答1:

Everything that you can do to the Google Sheets UI via Google Apps Script is documented in Extending Google Sheets.

You have no control over Google's UI components, such as the Search & Replace dialog.

You could implement your own search dialog, and display it as a modeless dialog that would always be visible. If you've already looked into sidebar and found that didn't work for you, just replace your call to showSidebar() with showModelessDialog().