Re: Auto Correct question

[Brian Barker]

At 00:11 28/05/2017 +, Kimberly Wise wrote:
I am working on a spreadsheet that needs to have certain wording. 
Specifically I am trying to put in the phrase RTsCars without the 
hyphen but with the capitalization. Every time I put it in the T 
becomes lowercase. I need it to be uppercase. Is there a way to 
format the cells to NOT auto correct to RtsCars and allow it to be RTsCars?


There is more than one way to do this, and it is worth knowing about 
all of them. The simple answer to your question, as you've expressed 
it, is to remove the tick from Tools | AutoCorrect Options... | 
Options | Correct TWo INitial CApitals. But you can keep the 
advantage of that facility whilst still solving your problem in other ways.


o You can bypass the automatic correction by typing ="RTsCars" 
(exactly like that) into a cell. That creates a formula with the 
appropriate value and display, which may be enough. If you want just 
the text itself, you can copy what is in the cell and paste it back 
over itself using Paste Special... and ensuring that Formulae is 
*not* ticked. This is much easier than it sounds - especially if you 
use Ctrl+C and Ctrl+Shift+V.


o Why type such an entry more than once? If you have designed your 
spreadsheet sensibly, you are likely to be entering this text into 
cells in a single column, or perhaps in a few specific columns. 
Select the column header and go to Data | Validity... | Criteria. For 
Allow, choose List. Ensure "Show selection list" is ticked. Enter 
possible values into the Entries box. Note that - conveniently - the 
automatic correction does not apply here. Now when you select a cell 
in the column, you will see a down-arrow button to the right of the 
cell; click this and you will be offered the selection list: no need 
to type the text again and no problem with automatic correction.


o Even without using Data | Validity, you can reuse values already in 
the same column. Select the new cell. Press Ctrl+D (or right-click | 
Selection List...) to display a list of values already in the column. 
Click your choice to enter it again.


Entering the same value many times into any document is a recipe for 
error, so techniques such as the above, although they may seem extra 
work, will repay dividends.


I trust this helps.

Brian Barker


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: pagination

[Leslie Fink]

Thank you for your response to my inquiry.

> On May 28, 2017, at 7:22 AM, Martin Groenescheij  
> wrote:
> 
> 
> 
> On 28/05/17 2:52 AM, Leslie Fink wrote:
>> I work on a Mac and recently upgraded from 10.5 to 10.11 (operating system - 
>> Le Capitain). I was using Microsoft Word for Mac but the learning curve was 
>> proving very difficult and time-consuming. It was suggested I install Apache 
>> Open Office. I create  large documents for clients, and previously I was set 
>> up for autofill pagination. No page 1, but automatically page 2, 3 and so 
>> on. This has disappeared.
>> 
>> Can you please tell me how I can set up this automatic pagination ? It’s 
>> always been in the header, centre, at the top of the page.
> 
> Go to Insert -> Header once the Header is inserted place your mouse inside 
> the Header and go to Insert -> Fields -> Page Number
> If you double click the page number it opens a menu where you can set the 
> number format, at the bottom you see a field to set the Offset
> f you set this to -1 it start numbering page two as 1 etc.
> 
>> 
>> I look forward to your response. I’ve got deadlines to meet.
>> 
>> Leslie Fink
>> 
>> 705 294 5200
>> 
>> lesliejf...@gmail.com
>> -
>> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: users-h...@openoffice.apache.org
>> 
>> 
> 


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: pagination

[Girvin Herr]

On 05/28/2017 04:22 AM, Martin Groenescheij wrote:



On 28/05/17 2:52 AM, Leslie Fink wrote:
I work on a Mac and recently upgraded from 10.5 to 10.11 (operating 
system - Le Capitain). I was using Microsoft Word for Mac but the 
learning curve was proving very difficult and time-consuming. It was 
suggested I install Apache Open Office. I create  large documents for 
clients, and previously I was set up for autofill pagination. No page 
1, but automatically page 2, 3 and so on. This has disappeared.


Can you please tell me how I can set up this automatic pagination ? 
It’s always been in the header, centre, at the top of the page.


Go to Insert -> Header once the Header is inserted place your mouse 
inside the Header and go to Insert -> Fields -> Page Number
If you double click the page number it opens a menu where you can set 
the number format, at the bottom you see a field to set the Offset

f you set this to -1 it start numbering page two as 1 etc.


Martin,
AOO 4.1.3; Slackware Linux 14.2.
I don't use a Mac, but when I use your process, and I change anything in 
the popup menu and return, the page number disappears and only the grey 
field indicator remains.  Bug?

Girvin Herr


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: pagination

[Rory O'Farrell]

> > On 28/05/17 2:52 AM, Leslie Fink wrote:
> >> I work on a Mac and recently upgraded from 10.5 to 10.11 (operating system 
> >> - Le Capitain). I was using Microsoft Word for Mac but the learning curve 
> >> was proving very difficult and time-consuming. It was suggested I install 
> >> Apache Open Office. I create  large documents for clients, and previously 
> >> I was set up for autofill pagination. No page 1, but automatically page 2, 
> >> 3 and so on. This has disappeared.
> >> 
> >> Can you please tell me how I can set up this automatic pagination ? It’s 
> >> always been in the header, centre, at the top of the page.
> >> 
> >> I look forward to your response. I’ve got deadlines to meet.
> >> 
> >> Leslie Fink
> >> 
> >> 705 294 5200
> >> 
> >> lesliejf...@gmail.com

Pagination in Writer is covered in this Tutorial:
https://forum.openoffice.org/en/forum/viewtopic.php?f=71=1221

-- 
Rory O'Farrell 

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Pagination

[Brian Barker]

At 14:38 28/05/2017 -0700, Girvin Herr wrote:

On 05/28/2017 04:22 AM, Martin Groenescheij wrote:
Go to Insert -> Header once the Header is inserted place your mouse 
inside the Header and go to Insert -> Fields -> Page Number. If you 
double click the page number it opens a menu where you can set the 
number format, at the bottom you see a field to set the Offset. If 
you set this to -1 it start numbering page two as 1 etc.


Martin,
AOO 4.1.3; Slackware Linux 14.2.
I don't use a Mac, but when I use your process, and I change 
anything in the popup menu and return, the page number disappears 
and only the grey field indicator remains. Bug?


If you set the offset to -1 as suggested, the second page - if you 
get that far - should display page number 1, as claimed. The first 
page still has the field, but does indeed show no page number. But 
what would you have it do? Surely you don't want a page zero? I don't 
see that as a bug.


If you want page numbers to show as greater values than their natural 
sequence, you will want to set a positive offset. If you do that, 
early page numbers show as expected, but no number is shown where the 
offset page number would be greater than the actual number of pages 
in the document. For example, if you have five pages and use an 
offset of (plus) 2, the pages are numbered 3, 4, and 5 - as expected 
- but the last two pages are not numbered at all. You might consider 
that a bug.


A more reliable way to have page numbers offset positively is to use 
"Change page number" when inserting a manual page break - as you 
would often wish to do anyway after a front page or after multiple 
pages of front matter. You can restart numbering at any positive, 
non-zero value, and the problem described above does not occur: page 
numbers can appear that exceed the actual number of pages in the document.


(Interesting though this is, it is actually tangential to the 
original query, which was just about suppressing the number on the 
first page but having page numbering thereafter following the actual 
page number - so starting with "2" on page two.)


Brian Barker  



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

RE: Hilfe bei standard draw Fenster

[Jan-Christian Wienandt]

Moin,

 

spät, aber es kommt eine Antwort.

 

Das angehängte Bild ist blockiert, in dieser Liste sind keine Anhänge
erlaubt.

Bitte das Bild / die Hardcopy an meine private Mail- Adresse schicken.

 

Gruß

Jan

Re: Fehler beim Speichern

[Günter Feierabend]

Hallo Manuela,

> Am 27.05.2017 um 13:34 schrieb manuela kamps :
> 
> Hallo!Ich benötige dringend Hilfe. Bei meinen Tabellenkalkulationen erscheint 
> seit gestern immer der Fehler: "Fehler beim Speichern: Schreibfehler. Datei 
> konnte nicht geschrieben werden"Vorgestern funktionierte noch alles 
> einwandfrei. Ich habe keine Einstellung oder sonst irgendetwas am Pc 
> geändert.Ich nutze Open Office 4.1.3 und Windows 10 (64 bit).Bitte Hilfe, da 
> die Tabellen sehr groß sind und viele Formeln enthalten und dringnd benötigt 
> werden.Vielen Dank im Vorraus. 
> P.S. Ich kann kein Englisch.

Versuche mal, die Datei unter einem anderen Namen zu speichern. Vielleicht 
hilft’s - danach löschst Du die (dann wohl defekte) alte Datei.

Gruß
Günter


-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org