[Libreoffice-bugs] [Bug 123477] New: Array formula with COLUMN() function evaluates to #VALUE error

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: ehorch at gmail.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190215/ae796167/attachment-0001.html>