It is not trivial to add finer control on how protection of cells deals with formula-changing cut-paste and other move/insert/delete operations involving cells that protected formulas depend on. For starters, there needs to be a way to communicate the enhanced conditions on protected cells via the ODF format. There is no such provision at the moment.
It is possible to handle this with configuration parameters carried in ODF. Unfortunately, that is intensely implementation-specific and frowned upon for something this deep into interpretation of the format. Either way, there remains the problem of having this work in interchange among enough other products that the feature is safe to rely on outside of a situation where all users can be required to use the same software. Interoperability with use of Excel is often a significant factor for many users, especially once Excel supports OpenFormula in its handling of .ods files (something expected eventually although I have no idea when). It might be worthwhile to review what the flavors of protection are in .xlsx and in Excel 2010. There might be an avenue there to something that could be done compatibly in ODF, digging into ISO OOXML for how it is done at the format level. I'm curious to know if the finer-grain options that are available there are helpful in your use case. Can you take a look? - Dennis PS: There is still a problem with the protection lock passwords not being portably-supported between Office formats and ODF formats, although there are ways to make that work better. Presently, the protection is simply turned off when transferring in either direction between formats. -----Original Message----- From: miakoiv [mailto:miak...@mbnet.fi] Sent: Friday, April 13, 2012 13:36 To: users@global.libreoffice.org Subject: [libreoffice-users] Re: Calc: cell protection + cut & paste > -----Original Message----- > From: Dennis E. Hamilton [mailto:dennis.hamil...@acm.org] > Sent: Thursday, April 12, 2012 11:15 > To: 'users@global.libreoffice.org' > Subject: RE: [libreoffice-users] Re: Calc: cell protection + cut & paste > > I spoke too soon. Absolute references don't solve this problem, because > even those are updated when moves happen, such as the cut and paste in the > demonstration example. There actually needs to be a way to block cutting > and other operations that relocate cells if formulas are to be protected > from movement of their operands. > It looks like a bigger issue might be whether it is possible to prevent > editing operations (cut especially but also row-column insertions and > deletions) in a sheet with protections turned on. All while still > allowing data entry into unprotected cells. 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. In excel you build your own UI to enter data and with VB you can do a lot of things. But in my opinion that's just overkill for most of the cases. Somebody said that it's an expected (and maybe even wanted?) behaviour, but I just can't understand it. I wish I could do the coding needed, but unfortunately I'm not skilled enough. I think that with a small improvement LibreOffice could be a lot better tool without too complicated things (like Excels UI + VB) I hope somebody, who could do something about this, finds this interesting and needed. :) Mikko -- View this message in context: http://nabble.documentfoundation.org/Calc-cell-protection-cut-paste-tp3903414p3908930.html Sent from the Users mailing list archive at Nabble.com. -- 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 -- 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