[Libreoffice-bugs] [Bug 127982] New: An array with VLOOKUP formula gives blanks in 6.3, where it used to work as in Excel previously

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=127982

            Bug ID: 127982
           Summary: An array with VLOOKUP formula gives blanks in 6.3,
                    where it used to work as in Excel previously
           Product: LibreOffice
           Version: 6.3.2.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: bibisectRequest, regression
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mikekaganski at hotmail.com

Created attachment 154776
  --> https://bugs.documentfoundation.org/attachment.cgi?id=154776&action=edit
A sample with failing array formula

The attachment has array formulas in D6, E6, and J6. They should give the same
results; but in 6.3, only the one in J6 works (giving the list of items that
constitute an order# given in E2), while the other two gives blanks. It works
in Excel 2016, and in 6.1.5.2, bit fails in 6.3.2.2.

Tested to fail with Version: 6.3.2.2 (x64)
Build ID: 98b30e735bda24bc04ab42594c85f7fd8be07b9c
CPU threads: 12; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded

and to work with Version: 6.1.5.2 (x64)
Build ID: 90f8dcf33c87b3705e78202e3df5142b201bd805
CPU threads: 12; OS: Windows 10.0; UI render: GL; 
Locale: en-US (ru_RU); Calc: group threaded

-- 
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/20191006/39039424/attachment.html>