Hi Mark What I’m entering in Find is the full amount/value. The amount of 1234.12 is just to show the format I am using
Kind regards, Evie. [email protected] www.wedloco.co.uk DIY Invitations & Stationery 0131 478 9175 On 20 Dec 2014, at 18:11, Mark Bourne <[email protected]> wrote: > WEDLOCO wrote: >> Thanks Tom for your quick response and suggestion - and also all others who >> have contributed. >> >> Downloaded the Still version 4.2.8 but same thing is happening. Worked 1st >> time I entered a value in find >> and then when I changed the amount "Search key not found". I entered >> different amounts from different cells to test and it can find some values >> but not others??? >> >> They are all formatted as numbers e.g.: 1234.12. No formulas in cells. >> >> These are bank statements downloaded as .cvs files then changed to .ods >> files in Libra to check against receipts. >> >> Cheers. >> >> Evie. > > Briefly experimenting with this, it seems that if there is a value of 1234.1 > in a cell, it is found when searching for 1234.1 but not when searching for > 1234.10 - even if it is formatted to display two decimal places. Could that > be what you're seeing? > > Additionally, a cell containing 1234.12 is found by a search for either > 1234.12 or 1234.1, which makes it more difficult to find 1234.10 but not > 1234.12. It is possible though, by using Edit > Find and Replace, entering > "1234.1" as the search term, and selecting the "Entire cells" option; that > will then find a cell containing 1234.1 but not 1234.12. > > This does seem potentially confusing. If this is the problem you're seeing, > it may be worth filing an enhancement request > athttps://www.libreoffice.org/get-help/bug/. After filling in the details but > before submitting, check the list of "Related bug reports". If any of those > describe the same problem, it's better to add information there instead of > submitting a new report. > > Mark. > > -- > To unsubscribe e-mail to: [email protected] > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
