Bug 79687

Summary:	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.
Product:	LibreOffice	Reporter:	m_a_riosv <miguelangelrv>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	critical	CC:	jbfaure
Priority:	high	Keywords:	regression
Version:	4.3.0.0.beta1
Hardware:	Other
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:

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.