Accessing Spreadsheet native function e.g. "getName()" on the client side

14 views
Skip to first unread message

Eric Thibeault

unread,
Nov 4, 2024, 2:57:27 AMNov 4
to Google Apps Script Community
using Google.script.run with all the withSuccessHandler and other bits, I am able to acess the data (txt and numbers, no date or function in cells) on the client side. 

logging Object.keys(spreadhseetpassed) gives me a list of native functions like GetName.  however trying to use these fucntions on the client side results in "undefiened".  Am I missing something? it looks like the key is passed but not its content i.e. teh fucntion itself.

I am simply trying to use these builtin "spresheet" fucntions on the client side to access sheets by name, named range by name, ect...  

 

George Ghanem

unread,
Nov 4, 2024, 2:51:24 PMNov 4
to google-apps-sc...@googlegroups.com

The Spreadsheet methods are server side methods only. You can not use them on the client side. I suspect the object is passed only for transfer to some other server side function, not to be used on the client side.


--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/1fab4494-4ccd-4ae6-8227-f0a35fb0acc9n%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages