Re: Splitting rows and columns

2014-08-28 Thread Martin Groenescheij
Place your cursor in the cell below / right of the row / column you want to freeze then go to Window --> Freeze On 29-8-2014 14:16, Rochelle wrote: I have a very complex spreadsheet on which to input much data. When working on a spreadsheet (calc) in AOO, how does one freeze the headers of the

Splitting rows and columns

2014-08-28 Thread Rochelle
I have a very complex spreadsheet on which to input much data. When working on a spreadsheet (calc) in AOO, how does one freeze the headers of the row or column so that one can scroll to up and down, or right and left and keep track of the correct title of that cell so appropriate data is entered?

Re: Need help with unlocking a very important document

2014-08-28 Thread jd1008
On 08/27/2014 09:57 PM, Yvonne Fisher wrote: I set up a password on a spreadsheet when saving; however, what I thought I saved is not unlocking the worksheet. How do I get around this? It is a very important that I do not loose this work. Yvonne Fisher It would help the list members a lot if

Re: [OT] why so many accidental subscriptions?

2014-08-28 Thread Alexandro Colorado
On Wed, Aug 27, 2014 at 1:46 PM, jonathon wrote: > On August 27, 2014 10:27:00 AM PDT, TN Patriot wrote: > > >If that's not clear enough, perhaps going back to school to learn reading > comprehension all over. > > The reading/comprehension skills of an individual with a fifth grade > education in

Re: [OT] why so many accidental subscriptions?

2014-08-28 Thread Brian Barker
At 13:20 28/08/2014 -0400, Felmon Davis wrote: On Thu, 28 Aug 2014, Brian Barker wrote: At 01:55 27/08/2014 -0400, Felmon Davis wrote: so according to this, people don't understand the idea of a "subscription" or "mailing list." alright. in addition, in their irritation, they fail to notice th

Re: [OT] why so many accidental subscriptions?

2014-08-28 Thread Felmon Davis
On Thu, 28 Aug 2014, Brian Barker wrote: At 01:55 27/08/2014 -0400, Felmon Davis wrote: so according to this, people don't understand the idea of a "subscription" or "mailing list." alright. in addition, in their irritation, they fail to notice the instructions for cancelling. If they don't

Re: [OT] why so many accidental subscriptions?

2014-08-28 Thread Brian Barker
At 01:55 27/08/2014 -0400, Felmon Davis wrote: so according to this, people don't understand the idea of a "subscription" or "mailing list." alright. in addition, in their irritation, they fail to notice the instructions for cancelling. If they don't understand the idea of a mailing list, sure

Re: [OT] why so many accidental subscriptions?

2014-08-28 Thread Brian Barker
At 12:27 27/08/2014 -0500, T N Patriot wrote: On Wed, 27 Aug 2014 03:29:47 -0500 Alexandro Colorado wrote: Another thing is that the instructions are not clear enough: To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org If that's not clear enough, perhaps going back to school to le

Re: Disabling autocomplete in Calc

2014-08-28 Thread Luis Iglesias
Sorry, I answer myself. I found the solution in https://forum.openoffice.org/ Tools -> Cell content -> Autoinput Spanish version: Herramientas -> Contenido de las celdas -> Entrada automática - Mensaje original - De: "Luis Iglesias" Para: users@openoffice.apache.org Enviados: Jue

Disabling autocomplete in Calc

2014-08-28 Thread Luis Iglesias
When you type text in a Calc cell, it tries to autocomplete cell content with the content of any cell in column that starts with the same text. Is it possible to disable that behavior? I couldn't find that option. Thanks in advance. -- Luis Iglesias Rejas Servizo de Administración Electrónic