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+h...@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
