https://bugs.freedesktop.org/show_bug.cgi?id=60366
Priority: medium
Bug ID: 60366
Assignee: [email protected]
Summary: EDITING: MATCH() function fails (err: 504) when
parameter 2 (LookupArray) is a single-cell named range
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 3.6.5.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 74289
--> https://bugs.freedesktop.org/attachment.cgi?id=74289&action=edit
ODS that shows the bug as described in "Steps to reproduce"
Problem description: MATCH() function fails (err: 504) when parameter 2
(LookupArray) is a single-cell range
Steps to reproduce:
1. Create a new workbook
2. Create a named range (CTRL+F3) with
* name = "range1"
* range = "$A$1"
* [other parameters: any]
3. In cell A1, insert character: a
4. In cell B1, insert formula: =MATCH("a";range1)
Current behavior:
Cell B1 shows "Err:504"
Expected behavior:
Cell B1 shows "1"
Additional information:
5. Create a named range (CTRL+F3) with
* name = "range2"
* range = "$A$1:$A$1"
* [other parameters: any]
6. In cell B2, insert formula "=MATCH("a";range2)"
=> displays "1", as expected
It might be worth noting that:
MATCH("a";A1) => Err:504 (expected: 1)
MATCH("a";A1:A1) => 1 (as expected)
Same behaviour seen on:
- v4.0.0.3 (Build ID: 7545bee9c2a0782548772a21bc84a9dcc583b89
- v3.6.5.2 (Build ID: 5b93205)
- v3.5.4.2 (Version ID 350m1(Build:2))
Operating System: Ubuntu
Version: 3.6.5.2 release
--
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
