Well, just to be clear - tried this with the example spreadsheet here with version 6.0.7 and 5.4.7 and using FIND does not do what the original poster is looking for. It seems the only way to find all of those values is by using FIND & REPLACE.
Now I'm not sure what 'FORMATTED DISPLAY' actually does. On Sun, Dec 30, 2018 at 10:58 AM Drew Jensen <drewjensen.in...@gmail.com> wrote: > @V Stuart > I thought that also - but that isn't working, as I just proved to myself, > with LO 6.2.0.1 RC1 (under Ubuntu 18.04.1) at least. > > On Sun, Dec 30, 2018 at 10:56 AM V Stuart Foote <vstuart.fo...@utsa.edu> > wrote: > >> @Johnny, >> >> Unless I am really misunderstanding, the "Formatted Display" check box >> will >> shift search results to match against the *values* as formatted to cell. >> A >> generalized implementation of the Find & Replace dialog's "Search in" >> listbox selection. >> >> Should give you your find results via the Find toolbar. >> >> >> >> >> >> -- >> Sent from: >> http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html >> >> -- >> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >> Problems? >> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette >> List archive: https://listarchives.libreoffice.org/global/users/ >> Privacy Policy: https://www.documentfoundation.org/privacy >> >> -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy