Re: [No longer] Mysterious ' in Calc

2021-06-28 Thread Girvin Herr
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

Re: [No longer] Mysterious ' in Calc

2021-06-28 Thread Dave Fisher
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

Re: [No longer] Mysterious ' in Calc

2021-06-28 Thread Girvin Herr
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

Re: [No longer] Mysterious ' in Calc

2021-06-28 Thread Brian Barker
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 -

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 Brian Barker
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 ­

Re: Column number in footing

2021-06-28 Thread David Belina
This is from the OO help: The following routine returns the current insertion points location on a page in terms of lines and characters. The number of characters is meaningless if the insertion point is in a table. The link is  https://wiki.openoffice.org/wiki/Writer/API/View_cursor On June 2

Re: Mysterious ' in Calc

2021-06-28 Thread David Deeks
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

Re: Mysterious ' in Calc

2021-06-28 Thread Brian Barker
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

Re: Mysterious ' in Calc

2021-06-28 Thread Brian Barker
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

Column number in footing

2021-06-28 Thread Otto Stolz
Hello, in a OO-Writer document, how can I display the current column number (rather than the page number!) in the footing? I am using Apache OpenOffice 4.1.10, AOO4110m2(Build:9807). Perhaps I could use a formula like “currentpage+previouspage” (in a 2-column document), but then I do not know

Re: Mysterious ' in Calc

2021-06-28 Thread David Deeks
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

Re: Mysterious ' in Calc

2021-06-28 Thread Rory O'Farrell
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

Re: Mysterious ' in Calc

2021-06-28 Thread David Deeks
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

Re: Fwd: Esmat

2021-06-28 Thread Rory O'Farrell
On Mon, 28 Jun 2021 10:36:56 +0200 Camilla Berglund <1982cami...@gmail.com> wrote: > Can you please help me? > I wrote a document yesterday and without doing anything my computer just > quit all the programs and restarted. > When I opened the document again it was only a lot of this in my hol

Fwd: Esmat

2021-06-28 Thread Camilla Berglund
Can you please help me? I wrote a document yesterday and without doing anything my computer just quit all the programs and restarted. When I opened the document again it was only a lot of this in my hole doc. Can you please help me to get my ordinarie doc back? How will I do? Or can you do i