Re: This is the email that appears on all these emails I have

2018-06-01 Thread Brian Barker
At 19:31 01/06/2018 +, Chester Campbell wrote: So what everyone is telling me is that I can not UNSUBSCRIBE from this email list! You have now been advised twice, by two separate people, how to proceed. Brian Barker -

Re: Sorting and column labels [was: Alternate Row Shading]

2018-06-01 Thread WA.TWORSX via AOL
On 6/1/2018 11:41 AM, Brian Barker wrote: [...] Yup. On the Options tab of the Sort dialogue, you will see "Range contains column labels". If this is ticked, the top row of the block of values (for sorting rows, or leftmost column for sorting columns) will be teated as labels - in other w

Re: This is the email that appears on all these emails I have

2018-06-01 Thread Chester Campbell
So what everyone is telling me is that I can not UNSUBSCRIBE from this email list! On Wednesday, May 30, 2018, 4:24:02 PM PDT, Wade Smart wrote: You email is: ches...@yahoo.com.invald I dont know how .invalid gets on the end but, it might have something to do with why you cant unsub. -

Re; Sorting and Column Labels [WAS: Re: Alternate Row Shading]

2018-06-01 Thread WA.TWORSX via AOL
On 6/1/2018 11:26 AM, Russell Munk wrote: WA.TWORSX via AOL wrote on 6/1/2018 9:00 AM: [...] Thee remains a problem, however.  When attempting to sort with extended selection data contained within B2:C14: G L A L C O D F F N L S N V O A Q S S Q S

Re: Number of Rows which can be declared to be in a Header for Sorting in Calc

2018-06-01 Thread Brian Barker
At 12:47 01/06/2018 -0400, Tom Panfil wrote: For years I've desired the capability to declare a multi-row header in Calc for purposes of sorting. I'm wondering why. Do others think that this would be useful? Probably not. Thoughts: o If your column headers need to be multi-row merely beca

Number of Rows which can be declared to be in a Header for Sorting in Calc

2018-06-01 Thread Tom Panfil
Hello OpenOffice Users, For years I've desired the capability to declare a multi-row header in Calc for purposes of sorting.  Do others think that this would be useful?   If there is great desire for it perhaps it can be requested as a new capability. Your thoughts and comments are solicited

Re: Pasting spreadsheet data [was: Alternate Row Shading]

2018-06-01 Thread Brian Barker
At 11:04 01/06/2018 -0400, Vince Bonly wrote: Go figure: If I copy/paste empty cells from CALC into my email client (Mozilla Thunderbird), it is removed; but if data is present within the cells, that is not removed? When you copy something, a lot of incidental information is included. You can

Re: Sorting and column labels [was: Alternate Row Shading]

2018-06-01 Thread Brian Barker
At 11:00 01/06/2018 -0400, Vince Bonly wrote: TNX again Brian; your suggestion worked perfectly. Good-oh! There remains a problem, however. When attempting to sort with extended selection data contained within B2:C14: G L A L C O [...] the data within B2;C2 is not being in

Re: Alternate Row Shading

2018-06-01 Thread Russell Munk
WA.TWORSX via AOL wrote on 6/1/2018 9:00 AM: [...] Thee remains a problem, however.  When attempting to sort with extended selection data contained within B2:C14: G L A L C O D F F N L S N V O A Q S S Q S W V X W D the data within B2;C2 is

Re: Alternate Row Shading

2018-06-01 Thread WA.TWORSX via AOL
Go figure: If I copy/paste empty cells from CALC into my email client (Mozilla Thunderbird), it is removed; but if data is present within the cells, that is not removed?

Re: Alternate Row Shading

2018-06-01 Thread WA.TWORSX via AOL
On 5/31/2018 1:06 PM, Brian Barker wrote: At 12:32 31/05/2018 -0400, Vince Bonly wrote: I find that often the template files available from https://www.vertex42.com/ make use of alternate row shading, and I would like to also. Example (copied from a CALC spreadsheet): If you included an ima