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


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

Context


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.