Re: [libreoffice-users] regular expression for calc

Hi Brian I wish i could say it did help but unfortunately not. It works with the whole cell contents but doesnt seem to pick out a word within the cell. For instance, one of my list has contents "X1 G43". Now if I have "X1 G43" in the cell Xn (using your example) i get count 1 returned which is

Re: [libreoffice-users] sort order

Thank you, yes it does. I got it to work with Greek iota which is about the least obtrusive. Strangely (to my mind) some less obtrusive characters with higher unicode *dont* work. Its a bit of a mystery whats going on, i can only surmise that there is somewhere a table of 'blacklisted'

Re: [libreoffice-users] regular expression for calc

Hi Gary, find the option "Search criteria = and <> must apply to whole cells" in Tools > Options > Calc > Calculate. Try it with disabled option. Kind regards Regina Gary Collins schrieb: Hi Brian I wish i could say it did help but unfortunately not. It works with the whole cell contents

Re: [libreoffice-users] sort order

for instance, see http://collation-charts.org/mysql60/mysql604.utf8_unicode_ci.european.html Je la 12/03/2017 19:07, leleu skribis : see https://en.wikipedia.org/wiki/Unicode_collation_algorithm now the problem is "where is the "collation algorithm" of calc ? An algorithm which obviously has

Re: [libreoffice-users] sort order

Got it! I can replace the ''A" in my "Aa" with Greek alpha (or with Russian 'A') and it works perfectly, with the minor exception that the non English characters look as if they have come from a different font. But I can live with that, I think it's the best solution possible. Thanks Gary

Re: [libreoffice-users] sort order

Wow, yes, that sounds the sort of thing. It would need to be customisable, I'm not sure that the sequence used for the transliteration of hieroglyphs would necesarily be catered for  Gary On Sun, 12/3/17, leleu wrote:

Re: [libreoffice-users] sort order

see https://en.wikipedia.org/wiki/Unicode_collation_algorithm now the problem is "where is the "collation algorithm" of calc ? An algorithm which obviously has to change according to the language. Je la 12/03/2017 18:50, Gary Collins skribis : Thank you, yes it does. I got it to work with

Re: [libreoffice-users] regular expression for calc

If the code you are looking for only occurs once per cell you could use find() or search() against each cells to determine if the code is present then countif() the results where greater than zero. On Sun, Mar 12, 2017 at 1:50 PM, Regina Henschel wrote: > Hi Gary, > >

Re: [libreoffice-users] sort order

ftp://fedora9gcc.dyndns.org/gary.zip Has 3 little spreadsheets. 8969 03-12-2017 03:27 FINDCODE.ods 14959 03-12-2017 05:04 casematch.ods 12025 03-13-2017 03:38 sortissue.ods That address some solutions I came up with playing with how I understood the issues, which might be