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

2019-10-07 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127982 --- Comment #4 from m.a.riosv --- An array like {=IFERROR(INDEX($B$2:$B$16;SMALL(IF($E$2=A2:A16;ROW(B2:B16)-1;);ROW()-5));"")} works, so seems the issue is with a string inside the SMALL function. Doing a test, with a SMALL array if s

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

2019-10-07 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127982 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o

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

2019-10-06 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127982 Oliver Brinzing changed: What|Removed |Added CC||er...@redhat.com,

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

2019-10-06 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127982 Oliver Brinzing changed: What|Removed |Added Status|UNCONFIRMED |NEW CC|