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: [email protected]
          Reporter: [email protected]

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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to