Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.