[Libreoffice-bugs] [Bug 126370] calc: vslookup 0 is not false
https://bugs.documentfoundation.org/show_bug.cgi?id=126370 Todd changed: What|Removed |Added Resolution|--- |NOTABUG Status|NEEDINFO|RESOLVED --- Comment #6 from Todd --- Oh you know what, I 1) created a special spreadsheet with the formulas in it and could not reproduce the issue, and 2) tried to reproduce the issue with the original corrected spreadsheet and also could not. I do believe what transpired what that they are using this spreadsheet directly from drop box and something got corrupted. (Bad idea to use drop box like that.) And the act of modifying the formula re-saved it correctly back to the spreadsheet and corrected the issue. So lets go ahead and close as INVALID. If it pops up again, I will get back. Thank you all for your assistance and patience with this issue. :-) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126370] calc: vslookup 0 is not false
https://bugs.documentfoundation.org/show_bug.cgi?id=126370 raal changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO CC||r...@post.cz -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126370] calc: vslookup 0 is not false
https://bugs.documentfoundation.org/show_bug.cgi?id=126370 QA Administrators changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126370] calc: vslookup 0 is not false
https://bugs.documentfoundation.org/show_bug.cgi?id=126370 --- Comment #5 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126370] calc: vslookup 0 is not false
https://bugs.documentfoundation.org/show_bug.cgi?id=126370 --- Comment #4 from Todd --- The document is full of private and proprietary information. Give me a little bit to recreate the document with Larry, Curry, and Moe as the principles. In the mean time, this is the offending formula: =VLOOKUP($A$7,$Pilots.$A$2:$Pilots.$B$21,MATCH($Pilots.B1,$Pilots.$A1:$Pilots.$B$1,0),FALSE()) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126370] calc: vslookup 0 is not false
https://bugs.documentfoundation.org/show_bug.cgi?id=126370 Oliver Brinzing changed: What|Removed |Added OS|Linux (All) |Windows (All) Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO --- Comment #3 from Oliver Brinzing --- (In reply to Todd from comment #2) > It was reported to me from a Windows user so can you please check with attached document or attach a sample document, as this makes it easier for us to verify the bug. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the issue is still present -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126370] calc: vslookup 0 is not false
https://bugs.documentfoundation.org/show_bug.cgi?id=126370 --- Comment #2 from Todd --- (In reply to Oliver Brinzing from comment #1) > Linux only problem? It was reported to me from a Windows user -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126370] calc: vslookup 0 is not false
https://bugs.documentfoundation.org/show_bug.cgi?id=126370 Oliver Brinzing changed: What|Removed |Added CC||oliver.brinz...@gmx.de --- Comment #1 from Oliver Brinzing --- Created attachment 152758 --> https://bugs.documentfoundation.org/attachment.cgi?id=152758=edit vlookup test case >"FALSE()" works but "0" does not. "0" still expects the first to be sorted. i can not confirm with: Version: 6.2.5.2 (x64) Build-ID: 1ec314fa52f458adc18c4f025c545a4e8b22c159 CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; VCL: win; Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE Calc: Linux only problem? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
