https://bugs.freedesktop.org/show_bug.cgi?id=88179
Bug ID: 88179
Summary: Can't create reference for an other spreadseet's named
cell
Product: LibreOffice
Version: 4.3.5.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 111929
--> https://bugs.freedesktop.org/attachment.cgi?id=111929&action=edit
the result of test steps
I create a cell reference an other spreadsheet:
"='file:///C:/toReference.ods'#$namedCell.C7"
If I change the tab and cell reference to its name, like this:
"='file:///C:/toReference.ods'#toReference"
the cell display #NAME? error, and the cell formula change to:
"='file:///C:/toReference.ods'#file:///C:/toReference.ods"
Steps to reproduce:
1. Create a new spreadseet
2. Rename the first tab to "namedCell"
3. Enter "referenced data" string into C7 cell on namedCell tab
4. Add "toReferenceCell" name to C7 cell
5. Save the spreadseet as "toReference.ods"
6. Create an other spreadseet
7. Rename the first tab to "referencig"
8. Type "=" into B3 cell on referencig tab then click to C7 cell on namedCell
tab in toReference.ods spreadseet.
9. Press Enter
10. The value of B3 cell will be: "='file:///C:/toReference.ods'#$namedCell.C7"
11. edit the value of B3 cell: chage the "$namedCell.C7" to "toReferenceCell"
12. Press Enter
Current behavior:
B3 cell display "#NAME?" error and the formula change to:
"='file:///C:/toReference.ods'#file:///C:/toReference.ods"
Expected behavior:
B3 cell display "toReferenceCell" string and the formula remain:
"='file:///C:/toReference.ods'#toReferenceCell"
--
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
