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

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