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
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.
View this message in context:
Sent from the Users mailing list archive at Nabble.com.
For unsubscribe instructions e-mail to: firstname.lastname@example.org
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
- [libreoffice-users] Calc: cell protection + cut & paste · miakoiv
Impressum (Legal Info)
: 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