Hi :) Top marks to Mark Bourne. Good work there :) Glad the problem got solved! Congrats, thanks and regards from Tom :)
On 20 December 2014 at 19:38, WEDLOCO <e...@wedloco.co.uk> wrote: > 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 < > libreoffice-ml.mbou...@spamgourmet.com> 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. > >> e...@wedloco.co.uk > >> > >> www.wedloco.co.uk > >> DIY Invitations & Stationery > >> 0131 478 9175 > >> > >> > >> > >> > >> On 20 Dec 2014, at 18:11, Mark Bourne < > libreoffice-ml.mbou...@spamgourmet.com> 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: users+unsubscr...@global.libreoffice.org > > 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: users+unsubscr...@global.libreoffice.org > 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: users+unsubscr...@global.libreoffice.org 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