Ah Mark - you have solved it! I was looking for an amount of 13.50 and entered 13.50 (which I thought was logical) - search not found. Now I have tried entering 13.5 and it finds it! Must remember not to add the 0.
"If you search for "9876.50", it DOES NOT find anything - which is probably not what you'd expect (I'd have expected it to find that cell containing 9876.5)” Absolutely - so I am not a complete Numpty! (a Scottish word). Thank you so much, to Tom and all others who have tried to help. Kind regards, Evie. On 20 Dec 2014, at 18:57, Mark Bourne <[email protected]> wrote: > I'm not sure I understand what you mean by "the full amount/value"? Are you > able to give an example of what you're entering in Find, and the values in > some cells in your sheet which you'd expect that to find? > > A more concrete example showing what I was trying to describe... If you have > a sheet displaying the following values: > 9876.00 > 9876.50 > 9876.54 > The actual values of the cells are: > 9876 > 9876.5 > 9876.54 > (they're just displayed with two decimal places because of the formatting > applied to the cells) > > If you search for "9876.54", it finds the cell containing 9876.54; so far so > good. > > If you search for "9876.5", it finds the cell containing 9876.5, and also the > cell containing 9876.54; also fine, but probably not very helpful in your > case. > > If you search for "9876.50", it DOES NOT find anything - which is probably > not what you'd expect (I'd have expected it to find that cell containing > 9876.5). > > To find cells displaying "9876.50" but not other values (such as 9876.54), it > seems you need to use the Find & Replace dialog, search for "9876.5", and > select the "Entire cells" option. This may present other problems, for > example it wouldn't find a value 9876.501, even though that would be > displayed as "9876.50". > > Mark. > > > WEDLOCO wrote: >> 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
