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 wro
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,
>
> find the option "Search cri
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:
Subject: Re: [libreoffice-
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
-
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 to
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
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' character
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 but
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
