Thanks again Brian. I’ll change the columns to text as you suggest.
The spreadsheet is saved as .ods. Perhaps as I think it originated as a .xls
this explains the problem of rows reverting to wrong size. At some point, if
‘life’ doesn’t get in the way, I may have a go at re-building a .ods versi
On 6/28/21 4:55 PM, Dave Fisher wrote:
Sent from my iPhone
On Jun 28, 2021, at 4:45 PM, Girvin Herr wrote:
On 6/28/21 3:36 PM, 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.
That's not my
Sent from my iPhone
> On Jun 28, 2021, at 4:45 PM, Girvin Herr wrote:
>
>
>> On 6/28/21 3:36 PM, 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.
>>
>>
>
>> That's not my experience or, I
On 6/28/21 3:36 PM, 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.
That's not my experience or, I imagine, anyone else's.
Brian et al.,
Your imagination is wrong. I have seen it. I just saw
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
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 -
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
At 15:35 28/06/2021 +0100, David Deeks wrote:
Thanks for this Brian - feeling suitably
admonished here for not being specific enough
particularly as I spent my working life designing computer business systems!
Oh, I was not trying to be critical.
I don't require them to be numbers per se
Thanks for this Brian - feeling suitably admonished here for not being specific
enough – particularly as I spent my working life designing computer business
systems!
I don’t require them to be numbers per se – as explained in my first email I
need to be able to sort them, but should have made i
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 indicate a small range thus e.g. 2-3, 3-4, or
an either/or thus e.g. 2/3, 3/4.
In both cases they show the cor
At 17:22 27/06/2021 -0700, Chuck Spalding wrote:
On Sun, Jun 27, 2021 at 3:46 PM Brian Barker wrote:
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
Thanks for the very fast response Rory(!), but I already realised this and
‘Text’ is one of the formats I tried, with the same result? I am also mystified
as to why it always shows the correct result in the ‘text to columns’ overlay
screen, but not in the spreadsheet cells?
David
> On 28 Jun 2
On Mon, 28 Jun 2021 11:30:28 +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 indicate a small range thus e.g. 2-3, 3-4, or an either/or thus
> e.g. 2/3, 3/4.
>
> In both ca
Thanks very much Brian - almost completely sorted!
I have a few exceptions where the contents of the field are not simple numbers.
They indicate a small range thus e.g. 2-3, 3-4, or an either/or thus e.g. 2/3,
3/4.
In both cases they show the correct result 2-3 or 2/3 in the text to columns
ov
Brian,
Thank you for enlightening us to this useful information! I'm sure there
are many other features of OpenOffice that I haven't yet "discovered".
Chuck
On Sun, Jun 27, 2021 at 3:46 PM Brian Barker
wrote:
> At 22:49 27/06/2021 +0100, David Deeks wrote:
> >I have discovered that I have some
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 ' preceding them - whilst appearing in the b
Hi there all you helpful people!
Can’t believe how much I’ve learned since ‘joining’ you lot (!), but am stuck
with this one.
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 a
16 matches
Mail list logo
