[libreoffice-users] Calc: cell protection + cut & paste

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+help@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