Re: [libreoffice-users] Calc - allow users to format cells on protected sheets

On 2013-07-18 8:17 PM, Errol Goetsch <errol@xe4.org> wrote:
> PS In this example, the trigger value is transparent when the cell is
> unlocked (the user can see the conditional formatting formula), but you
> can make the trigger refer offsheet to a value the user can't see.
> Hope this helps

Thanks for trying, but no, it doesn't.

Libreoffice has exactly two options under 'Allow all users of this sheet to:

[ ] Select protected cells
[ ] Select unprotected cells

Excel has a whopping 15:

[ ] Select locked cells
[ ] Select unlocked cells
[ ] Format cells
[ ] Format columns
[ ] Format rows
[ ] Insert columns
[ ] Insert rows
[ ] Insert hyperlinks
[ ] Delete columns
[ ] Delete rows
[ ] Sort
[ ] Use Autofilter
[ ] Use PivotTable reports
[ ] Edit objects
[ ] Edit scenarios

We have always maintained all of our internal documents and templates in 
ODF format (since we started using Openoffice at version 1.0), and I'm 
trying to avoid changing the format of this file to .xls and start using 
Excel to edit it, because doing so will open the door to converting 
*all* of our internal documents and templates to excel/word format.

This particular spreadsheet is a Master spreadsheet where we put all of 
our Sales numbers, and the boss wants the person assigned to update the 
sheet to start changing the BG color of the most recent changes.

The problem is, the MAIN sheet that everyone looks at, references 
numbers that are entered on their Managers 'Team' sheet, and must be 
locked to prevent accidental deletion of the content.

Crap.

--
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