Bug 79687 - EDITING: Copying one cell with a relative reference to another sheet, It doesn't modify the reference as it should when it is copied one to one.
Summary: EDITING: Copying one cell with a relative reference to another sheet, It does...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.0.0.beta1
Hardware: Other Windows (All)
: high critical
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2014-06-05 15:47 UTC by m_a_riosv
Modified: 2014-06-09 21:08 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
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 m_a_riosv 2014-06-05 15:47:46 UTC 
Win7x64
Version: 4.3.0.0.beta1+Win-x86@42 Branch:libreoffice-4-3 Time:2014-06-04_12:58:42
Version: 4.4.0.0.alpha0+Win-x86@39, Branch:master, Time: 2014-06-04_04:27:18

Last working for me:
Version: 4.2.6.0.0+Win-x86@42, Branch:libreoffice-4-2, Time:2014-06-03_01:47:36


Steps:

Create a new spreadshseet.
Add a second sheet.
Enter in
Sheet1.A1:  =Sheet2.A1

Copy and paste in Sheet1.A2, result:
Sheet1.A2:  =Sheet2.A1
Copy and paste in Sheet1.B5, result:
Sheet1.B5:  =Sheet2.A1

C&P doesn't modify the reference as if it was an absolute reference.

Happens for me copying&pasting only one to one cell.
Comment 1 Jean-Baptiste Faure 2014-06-09 15:09:11 UTC 
Not reproducible for me with LO 4.3.0.0beta2+ under Ubuntu 14.04 x86-64.
Build ID: a442091e3a66b33ecbd461de3fe9afd7add5b107

In sheet1.A2 I get sheet2.A2 and in sheet1.B5 I get sheet2.B5

Please could you try again with LO 4.3.0.0 beta2 ?

Best regards. JBF
Comment 2 m_a_riosv 2014-06-09 21:08:23 UTC 
Hi Jean, thanks for review.

Works now for me with:
Win7x64
Version: 4.3.0.0.beta2+Win-x86@42, Branch:libreoffice-4-3,Time:2014-06-08_21:29:21
Version: 4.4.0.0.alpha0+Win-x86@39, Branch:master, Time: 2014-06-09_10:08:50

I guess fortunately a patch has resolved the issue.