https://bugs.freedesktop.org/show_bug.cgi?id=85538
Bug ID: 85538
Summary: copying sheet to new document causes #REF! error if
cells have reference to other sheets
Product: LibreOffice
Version: 4.3.2.1 rc
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: blocker
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 108543
--> https://bugs.freedesktop.org/attachment.cgi?id=108543&action=edit
simple test ods file
For example, if Sheet2.A1 has reference to Sheet1.A1, copying Sheet2 to a new
document will cause #REF! error.
Steps to reproduce:
1. Open the attached test ods file;
2. Copy sheet 2, "to document: new document"
Current behaviour: #REF! error in new document
Excepted: should show value "1", or "='/path/to/sheet 1'.A1" (this the way MS
Excel behavious)
This bug makes it impossible to copy sheet. (99% of the spreadsheet people use
have reference between sheets.
OS: Win7 X86
Version: 4.3.2.1
Build ID: f9b3ad49d92181b0a1fe7e76f785a2c2cd0847d3
Still the same in vesion 4.3.2.2
P.S.: it seems that in the new document, Calc is trying to reference to the
sheet before the copied sheet 2, but faild because that sheet does not exist.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
