Bug 97044 - Copying sheet inside the same document causes #REF! error if cells have reference to other sheets
Summary: Copying sheet inside the same document causes #REF! error if cells have refer...
Status: RESOLVED DUPLICATE of bug 85538
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-01-11 14:48 UTC by Renovatio
Modified: 2017-04-19 08:40 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Simple test (7.83 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-01-11 14:48 UTC, Renovatio 		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 Renovatio 2016-01-11 14:48:33 UTC 
Created attachment 121860 [details]
Simple test

For example, if Sheet2.A1 has reference to Sheet1.A1, copying Sheet2 to a new Sheet will cause #REF! error.


Steps to reproduce:
1. Open the attached test ods file;
2. Copy sheet 2, "to a new sheet", for example Sheet2_2

Current behaviour: #REF! error in new sheet
Excepted: should show value "1234" with formula "=Sheet1.A1"

Regards 
Ricardo Gaspar
Comment 1 Usama 2016-01-11 15:04:01 UTC 
Reproducible on Libreoffice 5.1.0.1 Ubuntu 15.04.
Comment 2 Timur 2016-01-11 16:57:53 UTC 
"Copying sheet inside the same document causes #REF! error if cells have reference to other sheets" but only "if that sheet is copied before source sheet and if reference is relative".

If the reference is absolute, =$Sheet1.$A$4, it's ok, and if the new sheet is copied after the source sheet, it's also ok.
REF here stands for something as =ThisNewSheetThatDidn'tExist.A4
So, this all makes sense, and I'm not sure it's a bug.
Comment 3 m_a_riosv 2016-01-11 23:03:19 UTC 

*** This bug has been marked as a duplicate of bug 86652 ***
Comment 4 Timur 2017-04-19 08:40:55 UTC 

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