Description: Apologies if this has been requested already, since it's such a basic feature, but searched have yielded nothing relevant[1]. Consider this sheet: A1: foo A2: bar A3: ... ... A181: =A1 Searching for "foo" will only find A1, but not A181. Excel has had this option since I can remember (MS Office 2003): "Look in formulas/values/comments". In Calc, it appears impossible to look in anything but formulas. [1]: https://bugs.documentfoundation.org/buglist.cgi?quicksearch=calc%20look%20in%20values&list_id=870950 Steps to Reproduce: 1. Create a sheet where A1 contains "foo" and A2 is "=A1". 2. Add a comment to A2, "foo". 2. Search for "foo". Actual Results: Only A1 is found. Expected Results: A1 and A2 should be found, if the user wishes to search in values or comments, as opposed to searching only in formulas. Reproducible: Always User Profile Reset: No Additional Info: Basic feature in Excel.
Created attachment 147081 [details] Excel search feature: "Look in values"
with CTRL+H find and replace dialog there is a option for values and notes, so not only for formulas, idem like your attachment Version: 6.3.0.0.alpha0+ Build ID: 75dd5d2e734ad9e8265b1954c7496d1ba241079e CPU threads: 8; OS: Linux 4.19; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); UI-Language: en-US Calc: threaded
Hello Dan, You get this option expanding 'Other Options' in Search & Replace. Closing as RESOLVED NOTABUG