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


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.


Mikko Koivisto

View this message in context:
Sent from the Users mailing list archive at

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.