Protected ranges on generated sheets

[jlumbroso]

The number one problem is that volunteers accidentally erase important metadata, in particular the title of the piece (A1) or the column names with the source.

This can be solved with a protected range.

• list_protected_range: https://docs.gspread.org/en/v5.3.0/api.html#gspread.spreadsheet.Spreadsheet.list_protected_ranges
• add_protected_range: https://docs.gspread.org/en/v5.3.0/api.html#gspread.worksheet.Worksheet.add_protected_range

I think there should be a protected range on the first row and first column of every sheet, the the user can't edit.

[jlumbroso]

The error reporting is very accurate and useful!

[josephlou5]

Yes, this is a great idea.

[josephlou5]

Closed with merge.

[josephlou5]

This feature currently doesn't work, since the protected ranges are using the editors of the sheet as the editors of the protected range, which has no effect with respect to volunteers not being able to edit parts of each sheet.

[josephlou5]

Closed with commit d3003f9160b2358a1744276cc9b90b835a801da5.