Re: ATTN Brian Barker? - cell reformatting - have hit a snag!

2022-07-07 Thread David Deeks
022, at 03:57, Brian Barker > wrote: > > At 23:15 05/07/2022 +0100, David Deeks wrote: >> Sorry Brian, I was just being courteous - I thought if I included everyone >> with my follow-up query it would look like I was doubting your expertise! > > Oh, it's

Re: ATTN Brian Barker? - cell reformatting - have hit a snag!

2022-07-05 Thread David Deeks
> On 5 Jul 2022, at 21:39, Brian Barker > wrote: > > At 17:26 04/07/2022 +0100, David Deeks wrote: >> ATTN Brian Barker? > > I trust others are permitted to offer assistance? Sorry Brian, I was just being courteous - I thought if I included everyone with my follo

Re: Calc data sorting problem - cell formatting appears same but mustn't be?

2022-07-01 Thread David Deeks
Well Brian, here you go again - yes, ’twas indeed you last time! Thanks so much. A bit late tonight now for an oldie to try out your suggestions, but will certainly aim to do so tomorrow! All best David > On 1 Jul 2022, at 21:25, Brian Barker > wrote: > > At 19:20 01/07/2022

Re: [No longer] Mysterious ' in Calc

2021-06-29 Thread David Deeks
version from scratch! All best David > On 28 Jun 2021, at 23:36, Brian Barker > wrote: > > At 22:55 28/06/2021 +0100, David Deeks wrote: >> Thanks very much for your explanation re the Text to Columns facility Brian. > > No probs! > >> To answer your question

Re: Mysterious ' in Calc

2021-06-28 Thread David Deeks
Thanks very much for your explanation re the Text to Columns facility Brian. To answer your question … For many years I have done reviews for a music magazine and the values are quality ratings (1-5 ’stars’) for vinyl records and cds - three columns denoting Music Quality, Sound Quality, and (f

Re: Mysterious ' in Calc

2021-06-28 Thread David Deeks
David > On 28 Jun 2021, at 13:49, Brian Barker > wrote: > > At 11:30 28/06/2021 +0100, David Deeks wrote: >> Thanks very much Brian - almost completely sorted! >> >> I have a few exceptions where the contents of the field are not simple >> numbers. They indi

Re: Mysterious ' in Calc

2021-06-28 Thread David Deeks
Jun 2021, at 11:37, Rory O'Farrell wrote: > > On Mon, 28 Jun 2021 11:30:28 +0100 > David Deeks mailto:prof.david.de...@gmail.com>> > wrote: > >> Thanks very much Brian - almost completely sorted! >> >> I have a few exceptions where the contents of the

Re: Mysterious ' in Calc

2021-06-28 Thread David Deeks
gt; At 22:49 27/06/2021 +0100, David Deeks wrote: >> I have discovered that I have some part-columns of figures in Calc that do >> not sort properly, and have identified that, unlike other numbers in the >> same columns, they all appear in the "input line" with a '

Mysterious ' in Calc

2021-06-27 Thread David Deeks
without success. See attached screenshot from my MacBook showing one of the fields highlighted, and how it appears in the ‘input line’ and cell format window. Can anyone help get rid of the rogue ‘ ? Thanks! David Deeks - To

Re: Another spreadsheet formatting query

2020-06-10 Thread David Deeks
Sorry, here’s attachment ! ... > On 10 Jun 2020, at 22:53, Prof wrote: > > Having had my cell colours query sorted so quickly by you very helpful > people, I’m gonna push my luck because I have discovered another one! > > I am finding that apparently random rows do not set themselves to my sel

Re: Text/background colours on spreadsheet

2020-06-10 Thread David Deeks
Calc Guide as to how to do this. > > Dan > > On 6/10/20 06:35, David Deeks wrote: > > Hi all > > > > I am editing a previously created spreadsheet that uses a variety of > colours for background and text. I need to add more cells that use the same > colours. If I

Text/background colours on spreadsheet

2020-06-10 Thread David Deeks
Hi all I am editing a previously created spreadsheet that uses a variety of colours for background and text. I need to add more cells that use the same colours. If I select an existing cell, is there a way of identifying the previously used colours? At the moment I’m selecting all colours that

Re: Numbers automatically advance in spreadsheet columns

2020-04-28 Thread David Deeks
light the cell and drag down the column. The problem is > that > > in each line the numbers always increase by 1. This is useful of course > > sometimes, but not always! I have tried all formats, including text etc, > > and feel as though I’ve looked through every menu - but can

Re: Numbers automatically advance in spreadsheet columns

2020-04-27 Thread David Deeks
Brian, Alan Thanks so much for your very prompt replies - problem solved! Well pleased I discovered the group! All best David > On 27 Apr 2020, at 18:25, Brian Barker > wrote: > > At 18:08 27/04/2020 +0100, David Deeks wrote: >> I have been an Open Office user for ma

Numbers automatically advance in spreadsheet columns

2020-04-27 Thread David Deeks
looked through every menu - but cannot find how to stop it doing this. I am sure there must be a way? Thanks David Deeks - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h