Script not pushing changes to Spreadsheet

[Breanna Krywko]

I've written a script that should generate a chart on a spreadsheet inside of a shared drive, but the only thing I can get to happen on the sheets side is a yes/no prompt, deleting/creating a tab in my spreadsheet, and pasting formatting from another tab. I have lines like copyValuesToRange, setFormula, and mergeAcross, and they do absolutely nothing. There's no error returned, and everything appears to run smoothly on the script side.

On top of this, I'm not able to see the formatting change until the debugger has stopped, which makes debugging significantly more cumbersome. (Side note: I am also affected by this issue, adding to my debugger frustration.)

This is my first GAS script, I'm more used to VBA. I have to think that there's some permissions I need to set, but I am not sure where they are or what I need to change. Is anyone experiencing the same thing or know how to fix it?

[2morow never comes]

Hi,

Did you try to catch error?

--
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/759fa3cd-522d-41d0-9ac7-cbf0bd7596dc%40googlegroups.com.

[Loren Traughber]

I’m a front-end guy in a back-end world and I’m so lost!

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAA%3DxZROF2eow1By7s-t73OC--WHxG2yQ72mMpx52wzOYi5Enrw%40mail.gmail.com.

[Breanna Krywko]

What do you mean? The script appears to run normally, but I can't see any changes to my spreadsheet. I don't think there are any errors to catch.

On Tuesday, May 12, 2020 at 2:06:00 AM UTC-4, 2morow never comes wrote:

Hi,

Did you try to catch error?

On Tue, May 12, 2020, 4:43 AM Breanna Krywko <kryw...@kettering.edu> wrote:

I've written a script that should generate a chart on a spreadsheet inside of a shared drive, but the only thing I can get to happen on the sheets side is a yes/no prompt, deleting/creating a tab in my spreadsheet, and pasting formatting from another tab. I have lines like copyValuesToRange, setFormula, and mergeAcross, and they do absolutely nothing. There's no error returned, and everything appears to run smoothly on the script side.

On top of this, I'm not able to see the formatting change until the debugger has stopped, which makes debugging significantly more cumbersome. (Side note: I am also affected by this issue, adding to my debugger frustration.)

This is my first GAS script, I'm more used to VBA. I have to think that there's some permissions I need to set, but I am not sure where they are or what I need to change. Is anyone experiencing the same thing or know how to fix it?

--
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-community+unsub...@googlegroups.com.