https://bugs.documentfoundation.org/show_bug.cgi?id=123477
Bug ID: 123477
Summary: Array formula with COLUMN() function evaluates to
#VALUE error
Product: LibreOffice
Version: 6.2.0.3 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 149305
--> https://bugs.documentfoundation.org/attachment.cgi?id=149305&action=edit
Example of bad evaluation of array formula containing COLUMN() function
The attached workbook has an example of an array formula that contains the
FIND() function which takes as one of its arguments the output of the OFFSET()
function which in turn takes the COLUMN() function as one of its arguments.
This formula used to return a number (the index of the search substring) in 5.4
but with 6.2, it returns #VALUE.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
