[Libreoffice-bugs] [Bug 124728] Function CHOOSE doesn't allow to create matrix

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Function CHOICE don't allow |Function CHOOSE doesn't
                   |create matrix               |allow to create matrix
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEEDINFO

--- Comment #3 from Eike Rathke <erack at redhat.com> ---
What is your actual problem and in which version?

  =CHOOSE({2,1},A1:A4,B1:B4)

as array formula produces a result matrix of

  1  a
  2  b
  3  c
  4  d

and

  =VLOOKUP(2,CHOOSE({2,1},A1:A4,B1:B4),2,0)

returns b. Note that the ',' separator in {2,1} is the actual Array column
separator defined under Tools -> Options -> Calc -> Formula, which differs for
different locales.

This in all versions since LibreOffice 5.3.7 (don't have earlier to test). You
didn't tell your version, but maybe you should just upgrade.

-- 
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/20190415/53d994bb/attachment.html>