[libreoffice-users] Re: Enforcing Calc sheet protection

Am 15.04.2015 um 14:32 schrieb martin f krafft:
> Dear all,
>
> we've been pretty strict about locking our Calc sheets, turning cell
> protection on by default and selectively unlocking those cells that
> are meant to be edited.
>
> Every now and then, some protected cells have to be changed.
> Currently, the mode of operation is to unlock the sheet, edit, and
> then lock the sheet again, before saving.
>
> Unfortunately, that second-to-last step is often forgotten,
> resulting in us committing a version of a document with unlocked
> sheets.
>
> Is there a better way to approach this? Is there maybe a trick how
> to automatically protect all sheets on save, or to just temporarily
> unlock them?
>
> Thanks,

Hi,

There is a macro under "LibreOffice Macros">Tools>Misc>ProtectSheets
which can be used together with Tools>Customize>Events>"Save Document"

A database with an input form would save you a lot of trouble, but this
would require that you forget about spreadsheets and accept a more
professional approach.

Greetings,
Andreas


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted