[Libreoffice-bugs] [Bug 109329] New: [META] VLookup function bugs and enhancements

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 109329
           Summary: [META] VLookup function bugs and enhancements
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: philipz85 at hotmail.com
        Depends on: 105414, 107815, 109254, 79892, 83746, 106575, 107160,
                    107371, 108268
            Blocks: 108827


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=79892
[Bug 79892] Performance regression between 3.6 and later version, triple time
to do the calculations (win only)
https://bugs.documentfoundation.org/show_bug.cgi?id=83746
[Bug 83746] FILEOPEN: When opening an .xls with a 1-1M VLOOKUP range, the range
is truncated to 1-983040
https://bugs.documentfoundation.org/show_bug.cgi?id=105414
[Bug 105414] Blank cells formatted as numbers not treated as ZERO when pulled
via VLOOKUP to external file
https://bugs.documentfoundation.org/show_bug.cgi?id=106575
[Bug 106575] Correct VLOOKUP Formula - Incorrect Value shown. Shows correct
value if formula reapplied / changes made in other sheets
https://bugs.documentfoundation.org/show_bug.cgi?id=107160
[Bug 107160] VLOOKUP gets incorrect Value | Ctrl-Shift-F9 doesn't help
https://bugs.documentfoundation.org/show_bug.cgi?id=107371
[Bug 107371] Enhancement to Calc functions MATCH, HLOOKUP and VLOOKUP
https://bugs.documentfoundation.org/show_bug.cgi?id=107815
[Bug 107815] Semicolon changing to comma in VLOOKUP
https://bugs.documentfoundation.org/show_bug.cgi?id=108268
[Bug 108268] EDITING: Vlookup doesn't work
https://bugs.documentfoundation.org/show_bug.cgi?id=108827
[Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=109254
[Bug 109254] [FEATURE] VLOOKUP is using dynamic array when created with
Function Wizard
-- 
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/20170725/b1624db7/attachment.html>