How do I debug a real spreadsheet

[Luke Tych]

I want to hit breakpoints with actual data from an actual spreadsheet.

How?

[cbmserv...@gmail.com]

Luke,

 

You don’t debug a spreadsheet, you debug the script that runs behind the spreadsheet. If that is what you want to do, then click on Tools/Script Editor

 

That will show you the script code. You can then click on the line number to add/remove a breakpoint in a particular function. Then select the function you want to debug, click debug and it should stop at that breakpoint.

--
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 on the web visit https://groups.google.com/d/msgid/google-apps-script-community/1f0ae265-24a3-4f1e-abfc-a7a22642bd1en%40googlegroups.com.

[Chanel Greco]

Hey Luke

If you need some more guidance on debuging in general and using breakpoints in specific have a look at this video tutorial: https://youtu.be/L4V15ZxIjBQ