Bug 86916 - Functions, that use data from separate data sheet, disappears in Libre Office Calc after modification of data on the source sheet.
Summary: Functions, that use data from separate data sheet, disappears in Libre Office...
Status: RESOLVED DUPLICATE of bug 79441
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2014-12-01 22:29 UTC by Dmtiry Knorre
Modified: 2014-12-06 19:51 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Sample file to test bug in action (11.83 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-12-01 22:29 UTC, Dmtiry Knorre

Note You need to log in before you can comment on or make changes to this bug.
Description Dmtiry Knorre 2014-12-01 22:29:52 UTC
Created attachment 110326 [details]
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. 

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

Then I drugged data on Sheet1 from cell A1 to cell A6. 

After this the function on Sheet2 appeared as:

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.
Comment 1 Tim Lloyd 2014-12-01 22:42:17 UTC
Hi Dmitry,

forgive my ignorance, I am not a heavy calc user...when you say drug (drag?) and drop how do you actually achieve this?

I tried to highlight a cell and use the mouse to drag to a separate cell but this did not work.

If you could enlighten me regarding keystrokes it would be appreciated (and add to my education)

Comment 2 Dmtiry Knorre 2014-12-01 22:53:04 UTC
Hello, Tim

Just try to drag selection of several cells (the bug will pertsit too). Or try to select two cells and then shrink the selection to a single cell. After this you will be able to drag and drop single cell. 

Comment 3 raal 2014-12-02 21:20:48 UTC
I can not confirm with Version:
Build ID: 90fe751ab381cf59e87b79d921b3773567774af2
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2014-11-27_06:13:34

i can not confirm with Version:
Build ID: 9e57326acebde972df22ea4368b5ce4822d51330
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-3, Time: 2014-11-27_12:21:59

Sheet2.a1 = Sheet1.A6+Sheet1.B1
It's fixed in 4.3 version of LO.
Comment 4 Jean-Baptiste Faure 2014-12-06 19:51:59 UTC
See https://bugs.freedesktop.org/show_bug.cgi?id=87010#c2

Duplicate of bug 79441.

Best regards. JBF

*** This bug has been marked as a duplicate of bug 79441 ***