https://bugs.freedesktop.org/show_bug.cgi?id=86916
Bug ID: 86916
Summary: Functions, that use data from separate data sheet,
disappears in Libre Office Calc after modification of
data on the source sheet.
Product: LibreOffice
Version: 4.2.7.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 110326
--> https://bugs.freedesktop.org/attachment.cgi?id=110326&action=edit
Sample file to test bug in action
Libre Office Calc
Functions are loosing the reference on adjusted Sheet after modification of
data on that Sheet. This problem make almost impossible to use functions for
inter-sheet calculations.
Example:
I have two sheets in my spreadsheet document. One sheet "Sheet1" whith raw
numerical data, another sheet "Sheet2" with functions, that use the data from
Sheet1.
I wrote function in cell A2 of Sheet2
=Sheet1.A2+Sheet1.B2
Then I drugged data on Sheet1 from cell A1 to cell A6.
After this the function on Sheet2 appeared as:
=A2+B2
Attachment is the file from example before modification of Sheet1. To see bug
in action you need just to check the original function on Sheet2; drug and drop
the cell data on Sheet1 and then again check Sheet2 functions.
--
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
