[Libreoffice-bugs] [Bug 136518] Search did not find text given from vlookup

[bugzilla-daemon at bugs.documentfoundation.org]

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

Ming Hua <ming.v.hua at qq.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |ming.v.hua at qq.com
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEEDINFO

--- Comment #3 from Ming Hua <ming.v.hua at qq.com> ---
(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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200906/dc21c684/attachment.htm>