Ask Your Question

Revision history [back]

Protect template spreadsheet?

I have a blank template for a Calc spreadsheet that I want others to be able to use and save new documents from, but I want to prevent them from saving over the original spreadsheet.

I could do this in Microsoft Excel by setting a "password to modify", meaning it would effectively open as a "read only" file, which they could edit, but only save using the Save As... function (not just "Save"). I know how to have a Calc spreadsheet open as "read only", but in Calc you cannot input anything in or edit a read only document as you can with Excel. The only way to do it is to enable editing mode by inputting the password, which means you can now save over the original, defeating the point.

Is there any other way I can do this?

Many thanks.