https://bugs.documentfoundation.org/show_bug.cgi?id=162439
Bug ID: 162439
Summary: EXACT doesn't work with numbers in array context
Product: LibreOffice
Version: 4.2.0.4 release
Hardware: All
URL: https://ask.libreoffice.org/t/match-1-exact-not-workin
g-with-numbers/71688
OS: All
Status: UNCONFIRMED
Keywords: bisected, regression
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: mikekagan...@hotmail.com
Created attachment 195805
--> https://bugs.documentfoundation.org/attachment.cgi?id=195805&action=edit
Formulas using EXACT
1. In a new spreadsheet, put number '1' to A1, number '2' to A2.
2. In B1, put this formula: =EXACT(1, A1)
3. In C1, put this _array_ formula: {=EXACT(1, A1:A2)}
B1 shows TRUE, as expected.
C1 and C2 both show FALSE; the expected is TRUE in C1.
Regression after commit 7333881bb7b04f7e4e2a28638024ae82a9c14e81 (Formula
tokens, formula cells and formula interpreters to use shared strings.,
2013-10-11).
Ref.:
https://ask.libreoffice.org/t/match-1-exact-not-working-with-numbers/71688
--
You are receiving this mail because:
You are the assignee for the bug.
