[libreoffice-users] Re: Calc: cell protection + cut & paste

Am 13.04.2012 22:36, miakoiv wrote:
> Yes, absolute references don't solve it.
> And I really do agree that there should be a way to control how these
> editing operations affect protected cells.
>
> One of the core fuctions of a speadsheet program (in my opinion) in that
> somebody skills can make a calculation sheet and other people can use it to
> fill needed data and do the calculations and get the needed data.

There is no need to complicate things just because the simple rules of a 
spreadsheet don't fit your current requirements.
Absolute/relative referencing has nothing to do with the protection 
state. The two features are completely independent from each other. 
There must not be any special meaning of absolute references for 
protected cells.
As a matter of course, the spreadsheet program keeps track of the 
references when you move around referenced cells. There are ways to 
work-around this behaviour (INDIRECT, INDEX, OFFSET).
What you may have in mind may be more like a database form. LibreOffice 
supports databases and database forms.


--
For unsubscribe instructions e-mail to: users+help@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