[Libreoffice-bugs] [Bug 140365] VLOOKUP slow on accessing search matrix in other files
https://bugs.documentfoundation.org/show_bug.cgi?id=140365 Buovjaga changed: What|Removed |Added Ever confirmed|0 |1 OS|Windows (All) |All Keywords||perf CC||hoss...@libreoffice.org Status|UNCONFIRMED |NEW -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 140365] VLOOKUP slow on accessing search matrix in other files
https://bugs.documentfoundation.org/show_bug.cgi?id=140365 Buovjaga changed: What|Removed |Added CC||ilmari.lauhakangas@libreoff ||ice.org --- Comment #9 from Buovjaga --- Created attachment 178309 --> https://bugs.documentfoundation.org/attachment.cgi?id=178309=edit Perf flamegraph Tested by opening case2-file1.xls, editing links and pointing to case2-file2.xlsx. In N171, I modified the formula, so the first argument was H170. I filled down to N1223. It took about 9 secs stopwatch time. Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: 224369b351884e8315368cfc99620c42eb97ee15 CPU threads: 8; OS: Linux 5.16; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 140365] VLOOKUP slow on accessing search matrix in other files
https://bugs.documentfoundation.org/show_bug.cgi?id=140365 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Blocks||109329 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=109329 [Bug 109329] [META] VLookup function bugs and enhancements -- 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 140365] VLOOKUP slow on accessing search matrix in other files
https://bugs.documentfoundation.org/show_bug.cgi?id=140365 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 140365] VLOOKUP slow on accessing search matrix in other files
https://bugs.documentfoundation.org/show_bug.cgi?id=140365 --- Comment #8 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 140365] VLOOKUP slow on accessing search matrix in other files
https://bugs.documentfoundation.org/show_bug.cgi?id=140365 --- Comment #7 from Hagarius1988 --- (In reply to m.a.riosv from comment #6) > If I remember there is a difference with the option: > Menu/Tools/Options/LibreOffice calc/Calculate - Search criteria= and <> must > apply to whole cells. > With it unmarked vlookup should be slower. "Search criteria= and <> must apply to whole cells" is checked. -- 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 140365] VLOOKUP slow on accessing search matrix in other files
https://bugs.documentfoundation.org/show_bug.cgi?id=140365 m.a.riosv changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO CC||miguelangelrv@libreoffice.o ||rg --- Comment #6 from m.a.riosv --- If I remember there is a difference with the option: Menu/Tools/Options/LibreOffice calc/Calculate - Search criteria= and <> must apply to whole cells. With it unmarked vlookup should be slower. -- 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 140365] VLOOKUP slow on accessing search matrix in other files
https://bugs.documentfoundation.org/show_bug.cgi?id=140365 Hagarius1988 changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 --- Comment #5 from Hagarius1988 --- Files added. If you make any change in the formula in column 'N', 'O', 'P' and 'Q' and then copy down the formula for the entire column you can reproduce the duration differences between case 1 and case 2. -- 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 140365] VLOOKUP slow on accessing search matrix in other files
https://bugs.documentfoundation.org/show_bug.cgi?id=140365 --- Comment #4 from Hagarius1988 --- Created attachment 169704 --> https://bugs.documentfoundation.org/attachment.cgi?id=169704=edit File for Case2 - File 2 File for Case2 - File 2 Spreadshet with data search matrix for VLOOKUP from Case2-File 1 -- 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 140365] VLOOKUP slow on accessing search matrix in other files
https://bugs.documentfoundation.org/show_bug.cgi?id=140365 --- Comment #3 from Hagarius1988 --- Created attachment 169703 --> https://bugs.documentfoundation.org/attachment.cgi?id=169703=edit File for Case2 - File 1 File for Case2 - File 1 Main spreadsheet with VLOOKUP. -- 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 140365] VLOOKUP slow on accessing search matrix in other files
https://bugs.documentfoundation.org/show_bug.cgi?id=140365 --- Comment #2 from Hagarius1988 --- Created attachment 169702 --> https://bugs.documentfoundation.org/attachment.cgi?id=169702=edit File for Case1 File for Case1 VLOOKUP from main sheet with search matrix in sheet "deutsch". -- 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 140365] VLOOKUP slow on accessing search matrix in other files
https://bugs.documentfoundation.org/show_bug.cgi?id=140365 Xisco FaulĂ changed: What|Removed |Added CC||xiscofa...@libreoffice.org Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO --- Comment #1 from Xisco FaulĂ --- Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (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.) -- 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