Re: [libreoffice-users] sort order

2017-03-12 Thread Michael D. Setzer II
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 wrong, but these seem to work as I see it.

Tried pasting the cells, and they look fine in the email I sent, but were 
totally 
screwed up by the list? Then tried taken a screen shot, but those emails 
never seemed to show up, and no message that they were rejected?

Put this file on one of my college ftp servers, so if someone takes a look and 
sees if it works or not, otherwise. I'll just stop messing with it. 



On 12 Mar 2017 at 18:20, Gary Collins wrote:

Date sent:  Sun, 12 Mar 2017 18:20:29 + (UTC)
From:   Gary Collins 
Send reply to:  Gary Collins 
To: , leleu 

Subject: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:
> 
>  Subject: Re: [libreoffice-users] sort order
>  To: users@global.libreoffice.org
>  Date: Sunday, 12 March, 2017, 18:07
>  
>  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 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' characters which are not taken into
>  account for sorting purposes. This new (ish) sort order lark
>  has been a right pain in the proverbials for me, generally
>  speaking. I'll now just scour the table in the hope of
>  finding something even better but at least there is
>  *something* that'll work
>  >
>  > Thanks,
>  > G.
>  >
>  
>  > On Sun, 12/3/17, Brian Barker 
>  wrote:
>  >
>  >   Subject: Re:
>  [libreoffice-users] sort order
>  >   To: users@global.libreoffice.org
>  >   Date: Sunday, 12 March, 2017,
>  5:51
>  >   
>  >   At 17:58 11/03/2017 +,
>  Gary
>  >   Collins wrote:
>  >   >I'd like to know if
>  there is a character, preferably
>  >   some sort of
>  >   >discrete punctuation
>  mark, that will come *after* z in
>  >   the sort
>  >   >order when using natural
>  sort. My problem is that i have
>  >   some codes
>  >   >beginning Aa which really
>  speaking should come after Z.
>  >   As a number
>  >   >of up to 3 digits follows
>  the letter(s) in each case, im
>  >   getting A#
>  >   >followed by Aa# then B#
>  which really wont do. I have to
>  >   use natural
>  >   >sort as i need eg A12 to
>  come after A3. Ive tried a few
>  >   punctuation
>  >   >characters and some
>  special characters but i cant find
>  >   one that
>  >   >works. Any light that can
>  be shed on this would be very
>  >   welcome
>  >   >indeed. I really dont
>  want to have to precede Aa with a
>  >   z if that
>  >   >can possibly be
>  avoided.
>  >   
>  >   These are not punctuation
>  marks, but a bit of
>  >   experimentation
>  >   suggests that any Greek
>  character, upper or lower case, will
>  >   serve.
>  >   
>  >   I trust this helps.
>  >   
>  >   Brian Barker
>  >   
>  >   
>  >   --
>  >   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 

Re: [libreoffice-users] regular expression for calc

2017-03-12 Thread Bruce Hohl
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 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 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 correct;
>> but if i have "X1" in cell Xn it returns 0, which is clearly wrong (at
>> least as far as my requirements are concerned). And yes, i do have regular
>> expressions enabled in Calc >  Calculate. My version is 5.2.2.2 x64 and im
>> using 64bit windows 7.
>>
>> G.
>>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> 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


Re: [libreoffice-users] sort order

2017-03-12 Thread Gary Collins
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-users] sort order
 To: users@global.libreoffice.org
 Date: Sunday, 12 March, 2017, 18:07
 
 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 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' characters which are not taken into
 account for sorting purposes. This new (ish) sort order lark
 has been a right pain in the proverbials for me, generally
 speaking. I'll now just scour the table in the hope of
 finding something even better but at least there is
 *something* that'll work
 >
 > Thanks,
 > G.
 >
 
 > On Sun, 12/3/17, Brian Barker 
 wrote:
 >
 >   Subject: Re:
 [libreoffice-users] sort order
 >   To: users@global.libreoffice.org
 >   Date: Sunday, 12 March, 2017,
 5:51
 >   
 >   At 17:58 11/03/2017 +,
 Gary
 >   Collins wrote:
 >   >I'd like to know if
 there is a character, preferably
 >   some sort of
 >   >discrete punctuation
 mark, that will come *after* z in
 >   the sort
 >   >order when using natural
 sort. My problem is that i have
 >   some codes
 >   >beginning Aa which really
 speaking should come after Z.
 >   As a number
 >   >of up to 3 digits follows
 the letter(s) in each case, im
 >   getting A#
 >   >followed by Aa# then B#
 which really wont do. I have to
 >   use natural
 >   >sort as i need eg A12 to
 come after A3. Ive tried a few
 >   punctuation
 >   >characters and some
 special characters but i cant find
 >   one that
 >   >works. Any light that can
 be shed on this would be very
 >   welcome
 >   >indeed. I really dont
 want to have to precede Aa with a
 >   z if that
 >   >can possibly be
 avoided.
 >   
 >   These are not punctuation
 marks, but a bit of
 >   experimentation
 >   suggests that any Greek
 character, upper or lower case, will
 >   serve.
 >   
 >   I trust this helps.
 >   
 >   Brian Barker
 >   
 >   
 >   --
 >   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


Re: [libreoffice-users] sort order

2017-03-12 Thread Gary Collins
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

On Sun, 12/3/17, Brian Barker  wrote:

 Subject: Re: [libreoffice-users] sort order
 To: users@global.libreoffice.org
 Date: Sunday, 12 March, 2017, 5:51
 
 At 17:58 11/03/2017 +, Gary
 Collins wrote:
 >I'd like to know if there is a character, preferably
 some sort of 
 >discrete punctuation mark, that will come *after* z in
 the sort 
 >order when using natural sort. My problem is that i have
 some codes 
 >beginning Aa which really speaking should come after Z.
 As a number 
 >of up to 3 digits follows the letter(s) in each case, im
 getting A# 
 >followed by Aa# then B# which really wont do. I have to
 use natural 
 >sort as i need eg A12 to come after A3. Ive tried a few
 punctuation 
 >characters and some special characters but i cant find
 one that 
 >works. Any light that can be shed on this would be very
 welcome 
 >indeed. I really dont want to have to precede Aa with a
 z if that 
 >can possibly be avoided.
 
 These are not punctuation marks, but a bit of
 experimentation 
 suggests that any Greek character, upper or lower case, will
 serve.
 
 I trust this helps.
 
 Brian Barker
 
 
 -- 
 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


Re: [libreoffice-users] sort order

2017-03-12 Thread leleu
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 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 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' characters which are not taken into account for sorting 
purposes. This new (ish) sort order lark has been a right pain in the 
proverbials for me, generally speaking. I'll now just scour the table 
in the hope of finding something even better but at least there is 
*something* that'll work


Thanks,
G.

On Sun, 12/3/17, Brian Barker  wrote:

  Subject: Re: [libreoffice-users] sort order
  To: users@global.libreoffice.org
  Date: Sunday, 12 March, 2017, 5:51
At 17:58 11/03/2017 +, Gary
  Collins wrote:
  >I'd like to know if there is a character, preferably
  some sort of
  >discrete punctuation mark, that will come *after* z in
  the sort
  >order when using natural sort. My problem is that i have
  some codes
  >beginning Aa which really speaking should come after Z.
  As a number
  >of up to 3 digits follows the letter(s) in each case, im
  getting A#
  >followed by Aa# then B# which really wont do. I have to
  use natural
  >sort as i need eg A12 to come after A3. Ive tried a few
  punctuation
  >characters and some special characters but i cant find
  one that
  >works. Any light that can be shed on this would be very
  welcome
  >indeed. I really dont want to have to precede Aa with a
  z if that
  >can possibly be avoided.
These are not punctuation marks, but a bit of
  experimentation
  suggests that any Greek character, upper or lower case, will
  serve.
I trust this helps.
Brian Barker
  --
  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


Re: [libreoffice-users] sort order

2017-03-12 Thread leleu

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 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' characters which are 
not taken into account for sorting purposes. This new (ish) sort order lark has 
been a right pain in the proverbials for me, generally speaking. I'll now just 
scour the table in the hope of finding something even better but at least there 
is *something* that'll work

Thanks,
G.

On Sun, 12/3/17, Brian Barker  wrote:

  Subject: Re: [libreoffice-users] sort order
  To: users@global.libreoffice.org
  Date: Sunday, 12 March, 2017, 5:51
  
  At 17:58 11/03/2017 +, Gary

  Collins wrote:
  >I'd like to know if there is a character, preferably
  some sort of
  >discrete punctuation mark, that will come *after* z in
  the sort
  >order when using natural sort. My problem is that i have
  some codes
  >beginning Aa which really speaking should come after Z.
  As a number
  >of up to 3 digits follows the letter(s) in each case, im
  getting A#
  >followed by Aa# then B# which really wont do. I have to
  use natural
  >sort as i need eg A12 to come after A3. Ive tried a few
  punctuation
  >characters and some special characters but i cant find
  one that
  >works. Any light that can be shed on this would be very
  welcome
  >indeed. I really dont want to have to precede Aa with a
  z if that
  >can possibly be avoided.
  
  These are not punctuation marks, but a bit of

  experimentation
  suggests that any Greek character, upper or lower case, will
  serve.
  
  I trust this helps.
  
  Brian Barker
  
  
  --

  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


Re: [libreoffice-users] sort order

2017-03-12 Thread Gary Collins
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' characters which are 
not taken into account for sorting purposes. This new (ish) sort order lark has 
been a right pain in the proverbials for me, generally speaking. I'll now just 
scour the table in the hope of finding something even better but at least there 
is *something* that'll work

Thanks,
G.

On Sun, 12/3/17, Brian Barker  wrote:

 Subject: Re: [libreoffice-users] sort order
 To: users@global.libreoffice.org
 Date: Sunday, 12 March, 2017, 5:51
 
 At 17:58 11/03/2017 +, Gary
 Collins wrote:
 >I'd like to know if there is a character, preferably
 some sort of 
 >discrete punctuation mark, that will come *after* z in
 the sort 
 >order when using natural sort. My problem is that i have
 some codes 
 >beginning Aa which really speaking should come after Z.
 As a number 
 >of up to 3 digits follows the letter(s) in each case, im
 getting A# 
 >followed by Aa# then B# which really wont do. I have to
 use natural 
 >sort as i need eg A12 to come after A3. Ive tried a few
 punctuation 
 >characters and some special characters but i cant find
 one that 
 >works. Any light that can be shed on this would be very
 welcome 
 >indeed. I really dont want to have to precede Aa with a
 z if that 
 >can possibly be avoided.
 
 These are not punctuation marks, but a bit of
 experimentation 
 suggests that any Greek character, upper or lower case, will
 serve.
 
 I trust this helps.
 
 Brian Barker
 
 
 -- 
 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


Re: [libreoffice-users] regular expression for calc

2017-03-12 Thread Regina Henschel

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 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 correct; but if i have 
"X1" in cell Xn it returns 0, which is clearly wrong (at least as far as my requirements are 
concerned). And yes, i do have regular expressions enabled in Calc >  Calculate. My version is 5.2.2.2 x64 
and im using 64bit windows 7.

G.



--
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


Re: [libreoffice-users] regular expression for calc

2017-03-12 Thread Gary Collins
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 correct; but if i have 
"X1" in cell Xn it returns 0, which is clearly wrong (at least as far as my 
requirements are concerned). And yes, i do have regular expressions enabled in 
Calc >  Calculate. My version is 5.2.2.2 x64 and im using 64bit windows 7.

G.

On Sun, 12/3/17, Brian Barker  wrote:

 Subject: Re: [libreoffice-users] regular expression for calc
 To: users@global.libreoffice.org
 Date: Sunday, 12 March, 2017, 5:51
 
 At 15:45 11/03/2017 +, Gary
 Collins wrote:
 >I have a column each row of which contains a sequence of
 one or more 
 >codes separated by a space. In case it will make a
 difference each 
 >code consists of a letter (occasionally 2 letters)
 followed by a 
 >number of up to 3 digits (and occasionally ends with a
 letter) eg X1 
 >Aa12 D7a etc.
 >
 >I want to obtain a regular expression for COUNTIF that
 will enable 
 >me to find out how many times a particular code,
 contained in 
 >another cell, occurs in the column. I was thinking that
 \b to detect 
 >the word boundaries should help but i cant quite get it
 to work; im 
 >not sure if this is because it is assuming a word
 boundary between 
 >the letter and the number or if it is simply my
 incompetence as 
 >usual. Does anyone have an idea what may be the best way
 to achieve this?
 
 Try
 =COUNTIF(range;"\b"&"\b")
 - where "range" represents the column of data and Xn
 represents the 
 cell containing the code to be counted. Remember that you
 need to 
 have Tools | Options... | LibreOffice Calc | Calculate |
 Enable 
 regular expressions in formulae ticked (which is the case by
 default).
 
 I trust this helps.
 
 Brian Barker
 
 
 -- 
 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