https://bugs.freedesktop.org/show_bug.cgi?id=72491
Priority: medium
Bug ID: 72491
Assignee: [email protected]
Summary: EDITING: "Insert> Names> Insert" inserts the range as
a formula, generating an error for multi-cell ranges
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.2.0.0.beta2
Component: Spreadsheet
Product: LibreOffice
Created attachment 90474
--> https://bugs.freedesktop.org/attachment.cgi?id=90474&action=edit
InsertNames.ods (spreadsheet with 2 names defined)
Hello
Platform: windows 7/64 & Version: 4.2.0.0.beta2
Build ID: 1a27be92e320f97c20d581a69ef1c8b99ea9885d
Same result with Version: 4.1.3.2
"Insert> Names> Insert> Paste (all)" inserts the range as a formula, generating
an error for multi-cell ranges.
For example if the range of a name is $Sheet1.$B$1:$B$3 it will be inserted as:
=$Sheet1.$B$1:$B$3
So the cell displays #VALUE.
Insert> Names> Insert is a documentation command. We don't expect the result
but the references.
Ranges must be inserted without the = ($Sheet1.$B$1:$B$3 for example)
Steps to reproduce:
1. Open the InsertNames.ods attached
2. Select A5
3. Insert> Names> Insert> Paste all
Actual result:
In B5: =$Sheet1.$A$1 (display A)
In B6: =$Sheet1.$B$1:$B$3 (display #VALUE)
Exected result:
In B5: $Sheet1.$A$1
In B6: $Sheet1.$B$1:$B$3
Regards
Pierre-Yves
--
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
