https://bugs.freedesktop.org/show_bug.cgi?id=57822
Priority: medium
Bug ID: 57822
Assignee: [email protected]
Summary: EDITING: Cells across sheets become strangely linked
corrupting spreadsheet
Severity: blocker
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 3.6.3.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 70944
--> https://bugs.freedesktop.org/attachment.cgi?id=70944&action=edit
Minimal example to reproduce bug
Caveat: this is hard to explain. Please try steps to reproduce or attached
sample file. I think this might be similar to bug 51748.
It seems that if you put a reference to a cell in one sheet in a cell on
another sheet then other cells around also become mysteriously linked. However
you cannot see these links in the content of the cells, but they behave like
they are linked.
It's hard to explain but it's a nightmare because you end up corrupting your
whole file and by the time you realise what's happened you've overwritten lots
of cells on different sheets. I cannot use an application with this behaviour
as I cannot trust it not to lose my work.
Steps to reproduce (the values below are arbitrary):
* Create new spreadsheet
* Enter value 50 in Sheet1.A1
* Enter value 60 in Sheet2.A1
* Enter "=Sheet2.A1" in Sheet1.A2
* Enter value "ss" in Sheet2.B1
* Change back to Sheet1 and you'll find that the value "ss" has been copied to
Sheet1.B1. Why?!
Thanks,
Ian.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
