Bug 78086 - Moving cells breaks references in formulas
Summary: Moving cells breaks references in formulas
Status: RESOLVED DUPLICATE of bug 77647
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.3.3 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2014-04-29 16:33 UTC by pavelz
Modified: 2014-05-02 16:56 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Moving cells breaks references in fomulas - example (34.32 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-04-29 16:33 UTC, pavelz 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description pavelz 2014-04-29 16:33:11 UTC 
Created attachment 98183 [details]
Moving cells breaks references in fomulas - example

After moving cells (drag selected cells with left mouse and drop them with Alt key down), some references in formulas get broken.

See attachment with better description.
Comment 1 Jean-Baptiste Faure 2014-04-29 20:23:44 UTC 
Indeed, there is a problem when I try with LO 4.2.5.0.0+ and the master. In cell B9 I get the error Err:522 (circular reference) because the formula is =sum(B6:B12) instead of =sum(B9:B12) as I get in LO 4.1.6.

As it works in LO 4.1.6, set the status to NEW and the keyword regression.

Best regards. JBF
Comment 2 Kohei Yoshida 2014-05-02 00:54:14 UTC 
This doesn't happen with the master build.  Probably fixed with one of the bugs I fixed recently.
Comment 3 Kohei Yoshida 2014-05-02 00:59:07 UTC 
Bug 77647 may be it.
Comment 4 Kohei Yoshida 2014-05-02 01:06:44 UTC 

*** This bug has been marked as a duplicate of bug 77647 ***
Comment 5 Jean-Baptiste Faure 2014-05-02 05:54:58 UTC 
(In reply to comment #2)
> This doesn't happen with the master build.  Probably fixed with one of the
> bugs I fixed recently.

Sorry Kohei but I must disagree. I tried with LO 4.2.5.0.0+ containing the fix for bug 77647 (really fixed in 4.2.5) and the bug is still there.

Set status to reopened

Best regards. JBF
Comment 6 Kohei Yoshida 2014-05-02 16:03:15 UTC 
Fine. Then works for me.  Either way, I did try the latest from 4.2 branch and it does work correctly..  I suggest you do the same.
Comment 7 Kohei Yoshida 2014-05-02 16:26:36 UTC 
And make sure that your "Expand references when new columns/rows are inserted" option is off.  Because if you have that enabled, even in 4.1 this fails, and that's by design unfortunately.
Comment 8 Jean-Baptiste Faure 2014-05-02 16:56:04 UTC 
(In reply to comment #7)
> And make sure that your "Expand references when new columns/rows are
> inserted" option is off.  Because if you have that enabled, even in 4.1 this
> fails, and that's by design unfortunately.

Argh!!! You are right. :-) My "Expand references when new columns/rows are
> inserted" option was on. If I uncheck this option the bugdoc works as expected.
Thank you very much for the explanation .

Set back status to resolved duplicate of bug 77647

Best regards. JBF

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