Re: Format problem
eric wrote: I have been using Open Office 4.1.3 for many years---No problems Recently,when I open a new document and start typing, every word and line are underlined with a red squiggly line. I can find no way to get rid of it---It prints out too! Hope you may help Regards Eric Friedland Eric; This is a sympton of corruption in the user profile forOpen Office. To fix this see the following how to on the wike: https://wiki.openoffice.org/wiki/Documentation/How_Tos/Handling_the_OpenOffice.org_User_Profile#Moving_User_Settings. It will tell you where the profile is, and how to reset it. Regards Keith N. McKenna - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Format for Header & Footer
Darn. Sometimes I get in a hurry and miss a step: https://wiki.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Getting_Started/Creating_headers_and_footers On December 19, 2020 at 3:04:34 PM, Keith N. McKenna (keith.mcke...@comcast.net) wrote: On Sat, 19 Dec 2020 10:28:35 -0700, David Belina wrote: > Open Office has a Wiki and I did a web search and found this page that > has how to do header’s and footers (about the third topic on the page). > If your custom header or footer was done in OpenOffice you might be > able to copy and paste the text but I think other attributes will need > to be viewed and manually revised. > David, it seems that you neglected to include the link in your reply Regards Keith > > On December 19, 2020 at 7:55:24 AM, D DUB (negocioz...@gmail.com) wrote: > > Hello, > > If I wanted to install a predesigned header and footer to Apache Open > Office what format should it be? > Can you also send me some instructions on how to do it? > > Thank you, > > David W > - > 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: Format for Header & Footer
On Sat, 19 Dec 2020 10:28:35 -0700, David Belina wrote: > Open Office has a Wiki and I did a web search and found this page that > has how to do header’s and footers (about the third topic on the page). > If your custom header or footer was done in OpenOffice you might be > able to copy and paste the text but I think other attributes will need > to be viewed and manually revised. > David, it seems that you neglected to include the link in your reply Regards Keith > > On December 19, 2020 at 7:55:24 AM, D DUB (negocioz...@gmail.com) wrote: > > Hello, > > If I wanted to install a predesigned header and footer to Apache Open > Office what format should it be? > Can you also send me some instructions on how to do it? > > Thank you, > > David W > - > 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: Format for Header & Footer
Create a template On Sat, 19 Dec 2020, at 14:48, D DUB wrote: > Hello, > > If I wanted to install a predesigned header and footer to Apache Open > Office what format should it be? > Can you also send me some instructions on how to do it? > > Thank you, > > David W > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > > -- Best Regards Robin - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Format for Header & Footer
Open Office has a Wiki and I did a web search and found this page that has how to do header’s and footers (about the third topic on the page). If your custom header or footer was done in OpenOffice you might be able to copy and paste the text but I think other attributes will need to be viewed and manually revised. On December 19, 2020 at 7:55:24 AM, D DUB (negocioz...@gmail.com) wrote: Hello, If I wanted to install a predesigned header and footer to Apache Open Office what format should it be? Can you also send me some instructions on how to do it? Thank you, David W - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: format for a website
TNX Brian. That works for me! Regards, Vince Sent from my iPad > On Apr 25, 2020, at 09:45, Brian Barker > wrote: > > At 09:27 25/04/2020 -0400, Vince Bonly wrote: >> Within a Calc sheet there exists, say, www.domain.com in plain text format, >> (or email.addr...@isp.net). How is this converted to a hotlink so when >> clicked my browser opens to that website (or my email client opens a compose >> window) ? > > Easy way: > o Position the cursor in the cell immediately after the relevant text. > o Press the spacebar. > o Backspace over the space to delete it. > > More generally: > o Select not the entire cell but the required text within that cell. > o Insert | Hyperlink. > o Etc. > > 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: format for a website
At 09:27 25/04/2020 -0400, Vince Bonly wrote: Within a Calc sheet there exists, say, www.domain.com in plain text format, (or email.addr...@isp.net). How is this converted to a hotlink so when clicked my browser opens to that website (or my email client opens a compose window) ? Easy way: o Position the cursor in the cell immediately after the relevant text. o Press the spacebar. o Backspace over the space to delete it. More generally: o Select not the entire cell but the required text within that cell. o Insert | Hyperlink. o Etc. 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: Format
Go to Format | Page, select the Page tab and set the desired size. It is helpful to include which component of AOO you are asking about; fortunately the above advice is the same for Writer, Calc, Impress and Draw. Since you are not subscribed to this list you may not see all the replies to your query. To subscribe to Apache OpenOffice mailing lists go to http://openoffice.apache.org/mailing-lists.html As a courtesy I have sent a copy of this reply to you as well as to the mailing list. Do Not reply to me personally but just to the list at - replies to my personal email address will be ignored. On 6/1/20 2:08 pm, Kinsey Webb wrote: I need the page format to be 5.5 x 8.5. Can you please give me directions on how to do this please? Cheers -- David Robley Any fool can criticize, condemn, & complain. And most do. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: format changes mysteriously.
On Thu, 1 Mar 2018, Brian Barker wrote: At 00:51 01/03/2018 -0500, Felmon Davis wrote: using AO 4.1.5; for some reason when I type a something on a new line and end it with ':' that is, with the colon, the format of the line changes from my default to 'Heading 3'. That's supposed to happen - but when you type Ctrl+3, not Shift+: . A few thoughts: o Go to Tools | Customise... | Keyboard. o Under Category, open the Styles entry and select Paragraph. o Under Function, select "Heading 3". o What does it say under Keys? It should be Ctrl+3; is it something else? o Go to Tools | Customise... | Keyboard. o Under Category, select Format. o Under Function, select Apply. o What does it say under Keys? It should be nothing; is it something else? o If Shift+: is being interpreted as Ctrl+3, is there something seriously wrong with your keyboard driver? Or keyboard? What happens if you type Shift+: in another application? But I'm guessing ... I trust this helps. so I had a hypothesis which didn't pan out: thought it might correlate with copying and pasting from the browser or from other people's documents (I get several docs from people I have to comment on). however, I clearly get the effect on opening a new document. so it passed all your tests. I don't have many other apps to try but nothing like this occurs in Kate or in Kword (hmm..., interesting, never looked at this before!) or even in Calc from the AO suite. I forgot to play with this on my office computer but I think not it doesn't happen there. I forgot to fetch that default.ott and try it here; will fetch it next time I'm at that machine. (also Linux, Debian; I believe same version of AO.) will keep scratching. f. -- Felmon Davis - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: format changes mysteriously.
On Thu, 1 Mar 2018, Brian Barker wrote: At 00:51 01/03/2018 -0500, Felmon Davis wrote: using AO 4.1.5; for some reason when I type a something on a new line and end it with ':' that is, with the colon, the format of the line changes from my default to 'Heading 3'. That's supposed to happen - but when you type Ctrl+3, not Shift+: . A few thoughts: o Go to Tools | Customise... | Keyboard. o Under Category, open the Styles entry and select Paragraph. o Under Function, select "Heading 3". o What does it say under Keys? It should be Ctrl+3; is it something else? o Go to Tools | Customise... | Keyboard. o Under Category, select Format. o Under Function, select Apply. o What does it say under Keys? It should be nothing; is it something else? o If Shift+: is being interpreted as Ctrl+3, is there something seriously wrong with your keyboard driver? Or keyboard? What happens if you type Shift+: in another application? But I'm guessing ... I trust this helps. seems I spoke (wrote) too soon. the problem is not extinct. I have to make some more observations. I am beginning to see a pattern. more later. f. -- Felmon Davis - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: format changes mysteriously.
On Thu, 1 Mar 2018, Brian Barker wrote: At 00:51 01/03/2018 -0500, Felmon Davis wrote: using AO 4.1.5; for some reason when I type a something on a new line and end it with ':' that is, with the colon, the format of the line changes from my default to 'Heading 3'. That's supposed to happen - but when you type Ctrl+3, not Shift+: . A few thoughts: o Go to Tools | Customise... | Keyboard. o Under Category, open the Styles entry and select Paragraph. o Under Function, select "Heading 3". o What does it say under Keys? It should be Ctrl+3; is it something else? o Go to Tools | Customise... | Keyboard. o Under Category, select Format. o Under Function, select Apply. o What does it say under Keys? It should be nothing; is it something else? o If Shift+: is being interpreted as Ctrl+3, is there something seriously wrong with your keyboard driver? Or keyboard? What happens if you type Shift+: in another application? But I'm guessing ... I trust this helps. I had, I recall, rooted around in those settings but it was good to have another look. all these settings look 'kosher'. the problem has cleared up though. here is my hypothesis but I don't know if it makes sense: perhaps my default.ott was misconfigured/corrupt (I make adjustments relatively often) and it 'caught something'. I don't know why I didn't immediately see a change when I replaced it with an older copy, I don't know when it gets loaded. I usually do not restart AO but maybe I had. loaded a document that gave me the problem and there's no problem now. I much appreciate the good advice! "there's always something." f. -- Felmon Davis - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: format changes mysteriously.
At 00:51 01/03/2018 -0500, Felmon Davis wrote: using AO 4.1.5; for some reason when I type a something on a new line and end it with ':' that is, with the colon, the format of the line changes from my default to 'Heading 3'. That's supposed to happen - but when you type Ctrl+3, not Shift+: . A few thoughts: o Go to Tools | Customise... | Keyboard. o Under Category, open the Styles entry and select Paragraph. o Under Function, select "Heading 3". o What does it say under Keys? It should be Ctrl+3; is it something else? o Go to Tools | Customise... | Keyboard. o Under Category, select Format. o Under Function, select Apply. o What does it say under Keys? It should be nothing; is it something else? o If Shift+: is being interpreted as Ctrl+3, is there something seriously wrong with your keyboard driver? Or keyboard? What happens if you type Shift+: in another application? But I'm guessing ... 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: Format problem
On 06-Apr-16 05:09, E_J Fullerton wrote: How do I format a numbers column to list telephone numbers correctly? There is no number format for telephone in the number format list. Notice All addresses have been removed as a courtesy to my friends. Please be a friend and remove my address before you send this on. There is a User-defined format option. A telephone number format can be entered as (00)-000-000-000 for example. If you enter 01234567890 it will display as (01)-234-567-890. Keep in mind that formats can differ based on the country. If you have friends in different countries you should create multiple formats and work with Conditional Formatting. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Format problem
In CALC you can just type the number. Example: 123-456-7890 On 04/05/2016 12:09 PM, E_J Fullerton wrote: How do I format a numbers column to list telephone numbers correctly? There is no number format for telephone in the number format list. Notice All addresses have been removed as a courtesy to my friends. Please be a friend and remove my address before you send this on. -- Blessings, Joe Conner Joshua 24:15 "...as for me and my house, we will serve the LORD." - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Format-Frage
Hallo, From: guss.rich...@t-online.de [mailto:guss.rich...@t-online.de] Sehr geehrte Damen und Herren, Hier ist eine Anwender-Liste, das Du üblich. bisher war ich stetiger User von MS Office Produkten, jedoch kann ich diese nun nicht mehr nutzen und bin daher auf Ihr OpenOffice 4 umgestiegen. Doch leider muss ich feststellen, dass nicht alles so aussieht wie in MS Office und vor allem bekomme ich bei folgender Formel: =TEXT(ABS(J9-K9);WENN(J9K9;-;0)hh:mm) immer nur Err: 502 angezeigt, jedoch nur dann, wenn JxKx. Wenn JxKx oder 0, dann wird das Ergebnis korrekt mit einem Minuszeichen angezeigt. Und offensichtlich wird auch das Ergebnis aus der Formel gebildet, wenn JxKx, denn die Summe aus beiden Varianten wird korrekt gebildet. Bleibt also für mich ein Buch mit 7-Siegeln, denn wenn die Formel auch hier funktioniert, warum werden dann nur die --Ergebnisse angezeigt, jedoch die +-Ergebnisse nicht, stattdessen dieser Fehler. Was ist denn der Erwartungswert? Gerade mit Bezug auf MS Office, kann ich aktuell nur feststellen das sich die Formel in MS Excel 2003 vollkommen gleich verhält. Bei J9 = 3 und K9 = 2 --Fehlermeldung Err:502 (AOO 4.0) --Fehlermeldung #WERT! (MS Excel 2003) Bei J9 = 1 und K9 = 2 -- -00:00 (AOO 4.0) -- -00:00 (MS Excel 2003) (Antworten nur an die Mailingliste) Gruß Jörg - To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-de-h...@openoffice.apache.org
