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 <[email protected]> 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 <[email protected]> > 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: [email protected] >> 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: [email protected] 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
