Hello, I made really nice project for my customer with Calc because we didn't want to use Excel, but now we are in trouble, because in Calc you can't protect the formulas in cells from cust + paste modifications.
Cells are protected and documentation says that when the cells are protected you are not able to modify the formula. But that's unfortunately not true. If a protected cell reads data from non protected cell and the user decides to cut + paste the information, the orginal formula in the protected cell will be modified. And that's a very bad behaviour in my opinion. It should prevent cut + paste, because to allowing to do the cut + paste requires modification of the formula and that should not be allowed since the cell is protected. It's totally impossible to tell customer to undo exact the same cut + paste that he/she just did. Especially they propably wont notice the mistake until it's too late. Does anyone have any usable solution for us? I'm are getting desperate here because I need to fix these errors every week. Is this a known bug or is this designed behaviour? I'm really keen to know because if this is a real feature, then we have no choice but to use something else here. Yours, Mikko Koivisto -- View this message in context: http://nabble.documentfoundation.org/Calc-cell-protection-cut-paste-tp3903414p3903414.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