CODEWITHSUNDEEP
google-apps-scriptgoogle-sheets
maxhugen
maxhugen

Reputation: 1944

Google Sheets Script: Cannot Add or Delete Project Properties

I use Project Properties in my attached script to store user settings. The existing properties work OK, they can be retrieved or updated as expected.

However, I cannot Delete obsolete properties, or add a new one, from File > Project Properties. No error messages appear.

When I click "Delete", the property is removed from the list, so it looks like it worked, but when I reopen the properties, they are still there.

Similarly, when I "Add new", it appears to work OK (no err msg), but is not there when I reopen the properties.

Does anyone know if this is some sort of corruption - and if so, how I should go about fixing it?

Upvotes: 0

Views: 343

Answers (1)

Diego
Diego

Reputation: 9571

This is a known bug with the properties UI. Update your properties programmatically using the Properties class instead.

I've been unable to reliably reproduce the issue, but I have had it happen to me on several occasions.

Upvotes: 2

Related Questions