| Summary: | Copying sheet inside the same document causes #REF! error if cells have reference to other sheets | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Renovatio <rjbgaspar> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | normal | CC: | miguelangelrv, timur |
| Priority: | medium | ||
| Version: | Inherited From OOo | ||
| Hardware: | All | ||
| OS: | All | ||
| See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=85538 | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | Simple test | ||
Reproducible on Libreoffice 5.1.0.1 Ubuntu 15.04. "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. *** This bug has been marked as a duplicate of bug 86652 *** |
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