[Libreoffice-bugs] [Bug 136518] Search did not find text given from vlookup
https://bugs.documentfoundation.org/show_bug.cgi?id=136518 --- Comment #6 from reikenb...@gmx.de --- (In reply to Ming Hua from comment #3) > (In reply to reikenberg from comment #2) > > This should be default for the normal search or give the option to switch to > > values too. > There is already an option. > > In the "Search and Replace" dialog, on the bottom right, there is a > drop-down list labelled "Search in:", and the options are: Formulas, Values, > and Notes. The default choice is Formulas. > > Changing it to Values make it possible to search for the VLOOKUP() results > in your example file for me. Does it work for you? Yes, i know this option for "Search and Replace", but the normal "Search" should find anything you can see. That is what you expect if you use the normal search function. -- 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 136518] Search did not find text given from vlookup
https://bugs.documentfoundation.org/show_bug.cgi?id=136518 --- Comment #5 from reikenb...@gmx.de --- Created attachment 165227 --> https://bugs.documentfoundation.org/attachment.cgi?id=165227=edit More detailed example Search via CTRL+f find the yellow hits but not the from vlookup in red CTRL+ALT+f has an option to set so you can find vlookup values to. Search via CTRL+f should be find anything you see in the sheet by default. This is what a normal user would expect. Specially if a formula like =“test“ is found, but vlookup is not. -- 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 136518] Search did not find text given from vlookup
https://bugs.documentfoundation.org/show_bug.cgi?id=136518 --- Comment #4 from Uwe Auer --- No repro using: Version: 6.0.7.3, Build ID: 1:6.0.7-0ubuntu0.18.04.10 CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3; Locale: de-DE (de_DE.UTF-8); Calc: group No repro using: Version: 7.0.1.2, Build ID: 7cbcfc562f6eb6708b5ff7d7397325de9e764452 CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5 Locale: en-US (en_US.UTF-8); UI: en-US, Calc: threaded No repro using: Version: 6.4.6.2,Build ID: 0ce51a4fd21bff07a5c061082cc82c5ed232f115 CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5; Locale: en-US (en_US.UTF-8); UI-Language: en-US, Calc: threaded Remark: Sample file uploaded by reporter doesn't use absolute addressing in VLOOKUP, hence the lookup range shifts due to copy of the formula. It reads =VLOOKUP(A1;H1:I3;2;0) for the first row while it should use absolute addressing at least for the row numbers and read =VLOOKUP(A1;H$1:I$3;2;0) to assure the same lookup array being referred. -- 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 136518] Search did not find text given from vlookup
https://bugs.documentfoundation.org/show_bug.cgi?id=136518 Ming Hua changed: What|Removed |Added CC||ming.v@qq.com Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO --- Comment #3 from Ming Hua --- (In reply to reikenberg from comment #2) > This should be default for the normal search or give the option to switch to > values too. There is already an option. In the "Search and Replace" dialog, on the bottom right, there is a drop-down list labelled "Search in:", and the options are: Formulas, Values, and Notes. The default choice is Formulas. Changing it to Values make it possible to search for the VLOOKUP() results in your example file for me. Does it work for you? -- 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 136518] Search did not find text given from vlookup
https://bugs.documentfoundation.org/show_bug.cgi?id=136518 --- Comment #2 from reikenb...@gmx.de --- Search and replace work if you turn on search "values". This should be default for the normal search or give the option to switch to values too. -- 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 136518] Search did not find text given from vlookup
https://bugs.documentfoundation.org/show_bug.cgi?id=136518 --- Comment #1 from reikenb...@gmx.de --- Created attachment 165201 --> https://bugs.documentfoundation.org/attachment.cgi?id=165201=edit Example -- 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