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

Depends on where you open it.  If I double-click an email attachment to 
open it, I can't make any changes at all (not even column width).  Once 
I save it to my hard drive, it becomes unprotected.

I think what the OP is referring to is that in Excel you can do whatever 
you want to a protected spreadsheet -- you just can't save the changes.  
Thus, you can do a lot of "what if" analysis but can't mess up someone 
else's work.

Dave


On 7/18/2013 11:44, Tom Davies wrote:
> Hi :)
> I think if you open an Excel spreadsheet that is supposedly "protected" in Calc then you bypass all 
> the password protections and stuff.
>
> My company's (well the place where i work, it's not really mine as such) finance lady was somewhat 
> horrified when i was easily able to fix a problem for her despite having no idea what the password 
> was.  I hadn't even realised the spreadsheet was supposedly protected!
> Regards from
> Tom:)
>
>
>
>
>
> > ________________________________
> > From: Tanstaafl <tanstaafl@libertytrek.org>
> > To: users@global.libreoffice.org
> > Sent: Thursday, 18 July 2013, 15:47
> > Subject: [libreoffice-users] Calc - allow users to format cells on protected sheets
> >
> >
> > Hello,
> >
> > Microsoft Excel has the ability to allow users to apply formatting
> > changes to protected cells when a sheet is protected.
> >
> > Is there any possible way to do this in Calc?
> >
> > Thanks
> >
> > --
> > 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


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