[Libreoffice-bugs] [Bug 126370] New: calc: vslookup 0 is not false

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 126370
           Summary: calc: vslookup 0 is not false
           Product: LibreOffice
           Version: 6.2.5.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: ToddAndMargo at zoho.com

Description:
VSLOOKUP: "0" is not false

Steps to Reproduce:
https://help.libreoffice.org/Calc/Spreadsheet_Functions#Syntax_2

"Enter the Boolean value FALSE or zero if the first column is not sorted in
ascending order."

"FALSE()" works but "0" does not.  "0" still expects the first to be sorted.

And by the way that is "FALSE()" not "FALSE".

Please correct either the program or the documentation, which ever is incorrect

Actual Results:
see above

Expected Results:
see above


Reproducible: Always


User Profile Reset: No



Additional Info:

-- 
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/20190713/ff2658e2/attachment.html>