Re: [libreoffice-users] Search key working intermittently for values

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.mbourne@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.
> > evie@wedloco.co.uk
> >
> > www.wedloco.co.uk
> > DIY Invitations & Stationery
> > 0131 478 9175
> >
> >
> >
> >
> > On 20 Dec 2014, at 18:11, Mark Bourne <libreoffice-ml.mbourne@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+unsubscribe@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+unsubscribe@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