Hello and first let me say how awesome LibreOffice is compared to ooo.I've come across some strange behavior, whether or not I've found a bug I'd appreciate some advice for a workaround.
The behavior is this -- in calc, if you cut the data in a cell and paste it into another cell, field references in a protected sheet are changed.
I'd expect a protected sheet to stay fixed and not be subject to the effects of a cut on another sheet. I've tried relative and absolute field references (Sheet1.A1, $Sheet1.$A$1 and $Sheet1.$A1) with the same result, perhaps I'm not doing it right.
Steps to reproduce: On Sheet1 put data in fields A1, A2 On Sheet2 reference A1 and A2 in cells (e.g. =$Sheet1.$A$1, =$Sheet1.$A$2) Protect Sheet2 Cut the data in cell A1 Paste the data into A2 Cut the data in cell A2 Paste the data into A1 Both field references in Sheet2 will now reference Sheet1.A2. Any thoughts would be appreciated. -Brian -- 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