Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Google Sheets Formula Protection #10

Open
peter1357908 opened this issue Jul 17, 2023 · 4 comments
Open

Google Sheets Formula Protection #10

peter1357908 opened this issue Jul 17, 2023 · 4 comments
Assignees
@JellyfishSpot
Labels
enhancement New feature or request Google Sheets Google Sheets modification is necessary low priority Issues that are low priority

Comments

@peter1357908
Copy link
Member

peter1357908 commented Jul 17, 2023 •
edited
Loading

I noticed that editing parts of the sheet can unintentionally affect formulas elsewhere (this likely caused the formula deletion during our testing yesterday). Is there a way to ensure that this doesn't happen?

Relevant StackExchange here.
@peter1357908 peter1357908 added the enhancement New feature or request label Jul 17, 2023
@JellyfishSpot
Copy link
Collaborator

Could you describe the issue a bit more? Overwritting any data in the "Calc" sheet or "Leaderboard" sheet will result in reference errors as array formula can't replace any existing values. Was this caused by an invalid input in "Registry" or "Score Dump" or from shifting the rows and columns around?

@peter1357908
Copy link
Member Author

One scenario that I remember is:
I was testing the Google Sheets module by shifting the rows in the Registry to create empty rows in between filled rows, and suddenly the formula in both calc and leaderboard changed (and broke the sheet).

You can check out the broken sheet before I restored it in the version history (the broken version is on July 17, 3:39 AM).

Did you check out the StackExchange link? I think it proposed a potential fix by wrapping some formula with INDIRECT.

@peter1357908
Copy link
Member Author

By the way in a later meeting, let's go over things I updated/fixed in the "massive update" #11, like how I accounted for empty rows in the Registry sheet.

@JellyfishSpot
Copy link
Collaborator

Sounds good. I'll also look to see if using INDIRECT fixes these issues

@peter1357908 peter1357908 added the Google Sheets Google Sheets modification is necessary label Aug 2, 2023
@peter1357908 peter1357908 added the low priority Issues that are low priority label Aug 17, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@JellyfishSpot JellyfishSpot

Labels
enhancement New feature or request Google Sheets Google Sheets modification is necessary low priority Issues that are low priority
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@peter1357908 @JellyfishSpot