Brand New to Open Office and have a question re Date Formatting

2023-04-12 Thread Rick Malkin
dates to look like Friday, 21st or Sat, 2nd, Sun 3rd Mon 4th . Is there a way to have this happen within the date formatting?? Also I would like the time to show say 2345 hrs. So with Hours as text after the time.. Is there a way to have this happen within the time formatting??

How to Add Conditional Formatting to Existing Data

2022-09-06 Thread David Stuhr
Hello, I have been teaching/learning how "Conditional Formatting" (cell value and formula is) in OpenOffice Calc works. On new columns (or rows) of data applying the conditional formatting is/has been a very straight forward and an easy process. I have been able to apply the c

Re: Calc data sorting problem - cell formatting appears same but mustn't be?

2022-07-01 Thread David Deeks
+0100, David Deeks wrote: >> I am using Calc on a MacBook Pro running OS High Sierra 10.13.6 (the highest >> version this Mac will run). A long while back I had a problem sorting data >> on Calc spreadsheets which boiled down to cell formatting being different, >> solv

Re: Calc data sorting problem - cell formatting appears same but mustn't be?

2022-07-01 Thread Brian Barker
At 19:20 01/07/2022 +0100, David Deeks wrote: I am using Calc on a MacBook Pro running OS High Sierra 10.13.6 (the highest version this Mac will run). A long while back I had a problem sorting data on Calc spreadsheets which boiled down to cell formatting being different, solved by a friendly

formatting at new technition

2022-05-27 Thread Null REPLY
I'm telling you guys are doing a good job in the right thing but no more plugins start working on the base feature and its modules text formatting definitely needs improvement because some fonts don't display properly or adjust with print option or other changes! /fun ticket secondl

Re: Formatting for USA Telephone Numbers

2022-02-27 Thread Brian Barker
At 13:08 27/02/2022 -0500, Vince Bonly wrote: I must figure a way to convert existing cell contents such as (877) 300- to the desired display format. Can this task be accomplished using a formula? Yup: =VALUE(MID(Xn;2;3)&MID(Xn;7;3)&MID(Xn;11;4)) - where Xn is the cell containing the origi

Re: Formatting for USA Telephone Numbers

2022-02-27 Thread Steven Ahlers
Vince, 1) Yes, it’s normal to switch to User Defined. 2) Not sure what you’re referring to. Steve Sent from my iPhone > On Feb 27, 2022, at 11:58 AM, wa.two...@verizon.net.invalid wrote: > >  > My thanks to all that have replied. It has been wild here with home repair > concerns, or I woul

Re: Formatting for USA Telephone Numbers

2022-02-27 Thread Vince@Verizon
s shown in image included above. Ultimately, I want to be able to use LO or AOO for USA Telephone Number formatting.  Then, I must deal with very few international telephone numbers within my Calc file. TIA. On 2/27/2022 12:58 PM, Vince@Verizon wrote: My thanks to all that have re

Re: Formatting for USA Telephone Numbers

2022-02-27 Thread Vince@Verizon
My thanks to all that have replied.  It has been wild here with home repair concerns, or I would have acknowledged sooner. I will attempt 1^(###)^###- (where ^ is a space) under the numbers tab, when time permits. 1. I believe that as soon as I begin typing into the definition box, it

Re: Formatting for USA Telephone Numbers

2022-02-26 Thread Steven Ahlers
Jonathan, Actually Vince’s (the OP) original question was about 1+ (###) ###- not +1 (###) ###-. He also asked about (###) ###- as an alternative. Both were addressed several responses ago including an incorrection in regards to those solutions. Steve Sent from my iPhone > On Fe

Re: Formatting for USA Telephone Numbers

2022-02-26 Thread toki
On 25/02/2022 19:58, Alan B wrote: Correction After applying the recommended format, (###) ###-, and entering 1234567890 the displayed value will be (123) 456-7890. Your original question was asking about +1 (###) ###-, not (###) ###-. jonathon OpenPGP_0xA759EEC77A18EA38.asc D

Re: Formatting for USA Telephone Numbers

2022-02-25 Thread Alan B
parenthesis. >> >> I have tried to set a user defined number-format, but am getting strange >> results with apostrophes and/or double quote markings mixed in when >> viewing the Format Cells dialogue, e.g., (#") "###"*-*". And, I >> don;t understand

Re: Formatting for USA Telephone Numbers

2022-02-25 Thread Alan B
mixed in when > viewing the Format Cells dialogue, e.g., (#") "###"*-*". And, I > don;t understand why that is. I was hoping to find a pre-defined/default > format for use when entering USA telephone numbers. I am flexible; I can > probably do without the "

Re: Formatting for USA Telephone Numbers

2022-02-24 Thread Brian Barker
e the punctuation appear as if by magic. A suitable cell format does that - and entering data that way is less prone to error in the formatting. Isn't that what cell formatting is all about? As Brian stated, Entering the way you want are not numeric values, but text. An alternative way that cr

Re: Formatting for USA Telephone Numbers

2022-02-24 Thread Brian Barker
At 10:17 24/02/2022 -0600, Steven Ahlers wrote: It does drop a leading zero in the area code. It doesn't drop leading zeros from the prefix series or the exchange series. In the USA no area code starts with a zero so this would be a nonissue. Ho, ho: indeed so! But look what happens if the us

Re: Formatting for USA Telephone Numbers

2022-02-24 Thread Steven Ahlers
Keith, The formatting that I shared works fine for USA phone numbers. I’ve used it for many years for tracking a list of contact information of a fantasy football league. Steve Sent from my iPhone > On Feb 24, 2022, at 6:53 PM, Keith N. McKenna > wrote: > > In article <64a

Re: Formatting for USA Telephone Numbers

2022-02-24 Thread Keith N. McKenna
"###"*-*". And, I > don;t understand why that is. I was hoping to find a pre-defined/default > format for use when entering USA telephone numbers. I am flexible; I can > probably do without the "1" prefix and/or the parenthesis. > > Should I be formatt

Re: Formatting for USA Telephone Numbers

2022-02-24 Thread Steven Ahlers
Brian, It does drop a leading zero in the area code. It doesn’t drop leading zeros from the prefix series or the exchange series. In the USA no area code starts with a zero so this would be a nonissue. Steve Sent from my iPhone > On Feb 24, 2022, at 9:44 AM, Brian Barker > wrote: > > At 0

Re: Formatting for USA Telephone Numbers

2022-02-24 Thread Brian Barker
At 09:18 24/02/2022 -0600, Steven Ahlers wrote: If you want the format of 1 (123) 456-7890 simply type in the format definition box (near the bottom of the pop up menu for Format Cell under the Numbers tab) 1^(###)^###- (where ^ is a space). But that format will (inappropriately) lose lead

Re: Formatting for USA Telephone Numbers

2022-02-24 Thread Steven Ahlers
> results with apostrophes and/or double quote markings mixed in when viewing >> the Format Cells dialogue, e.g., (#") "###"*-*". And, I don;t understand >> why that is. I was hoping to find a pre-defined/default format for use when >> enteri

Re: Formatting for USA Telephone Numbers

2022-02-23 Thread PCS
(#") "###"*-*". And, I don;t understand > why that is. I was hoping to find a pre-defined/default format for use when > entering USA telephone numbers. I am flexible; I can probably do without the > "1" prefix and/or the parenthesis. > > Should I be formatting these cells as "text" (left-justified) rather than as > numbers (right-justified)? > > Regards, > > VinceB. >

Re: Formatting for USA Telephone Numbers

2022-02-23 Thread Brian Barker
sis, and a negative/minus sign between the 3rd digit and the 4th digit. A space follows the prefix "1" and a space follows the closing parenthesis. What's wrong with "1 (000) 000-" (no quotes, of course)? Should I be formatting these cells as "text" (left

Formatting for USA Telephone Numbers

2022-02-23 Thread Vince@Verizon
bly do without the "1" prefix and/or the parenthesis. Should I be formatting these cells as "text" (left-justified) rather than as numbers (right-justified)? Regards, VinceB.

Re: formatting; hyphens, dashes and SpellCheck

2021-12-23 Thread Brian Barker
At 20:41 16/12/2021 +, Ralph McCrum wrote: Good Luck Ken [who asked to be able to turn off all automatic formatting changes]. I DON'T want automatic bulleting or paragraph numbering And A Few Other Things either. But After The Answers I Got On Bullets And Numbering, I Never Ask

Re: formatting; hyphens, dashes and SpellCheck

2021-12-16 Thread Ralph McCrum
- From: "Ken" To: "users@openoffice.apache.org" Sent: 12/16/2021 14:27:05 Subject: formatting; hyphens, dashes and SpellCheck I have simply lost track of formatting changes. I want to undo the lot of them and start over. Particularly I want to turn off Spell Check a

formatting; hyphens, dashes and SpellCheck

2021-12-16 Thread Ken
I have simply lost track of formatting changes.  I want to undo the lot of them and start over. Particularly I want to turn off Spell Check and restore the hyphen-to-dash feature, and I DON'T want automatic bulleting or paragraph numbering. Community forums aren't helpful because t

Re: PLEASE DISCONTINUE AUTOMATIC FORMATTING

2021-08-13 Thread Rory O'Farrell
On Thu, 12 Aug 2021 19:14:06 -0400 David Cobble wrote: > DEAR OPEN-OFFICE, > > THE AUTOMATIC FORMATTING FEATURES ON YOUR SOFTWARE *IS A NIGHTMARE FOR > WRITERS!* > > WE DO NOT NEED IT. WE DO NOT NEED YOUR PLATFORM MAKING FORMATTING > DECISIONS FOR US. > > I'M

Re: PLEASE DISCONTINUE AUTOMATIC FORMATTING

2021-08-12 Thread Fernando Cassia
k the [T] box next to "Capitalize first letter of every sentence". 3. Click OK at the bottom of the dialog to apply the change. Aug 7, 2018 Best , FC On Thu., 12 Aug. 2021, 21:39 David Cobble, wrote: > DEAR OPEN-OFFICE, > > THE AUTOMATIC FORMATTING FEATURES ON YOUR SOFTWA

Re: PLEASE DISCONTINUE AUTOMATIC FORMATTING

2021-08-12 Thread Fernando Cassia
You seem to have no problems with writing in all caps, that's for sure. FC On Thu., 12 Aug. 2021, 21:39 David Cobble, wrote: > DEAR OPEN-OFFICE, > > THE AUTOMATIC FORMATTING FEATURES ON YOUR SOFTWARE *IS A NIGHTMARE FOR > WRITERS!* > > WE DO NOT NEED IT. WE DO NOT NE

PLEASE DISCONTINUE AUTOMATIC FORMATTING

2021-08-12 Thread David Cobble
DEAR OPEN-OFFICE, THE AUTOMATIC FORMATTING FEATURES ON YOUR SOFTWARE *IS A NIGHTMARE FOR WRITERS!* WE DO NOT NEED IT. WE DO NOT NEED YOUR PLATFORM MAKING FORMATTING DECISIONS FOR US. I'M SURE I SPEAK FOR LOTS OF WRITERS. YOUR "DROP CAP" FEATURE KEEPS ASSERTING ITSELF INTO M

Re: Formatting a Newsletter Containing an Index

2020-12-12 Thread Brian Barker
At 22:12 10/12/2020 +0100, Martin Groenescheij wrote: The definition from PC Magazine What is the difference between a hard and soft return in Word? *Hard return*: Pressing the *Enter* key in *Word* ends a paragraph. It's officially known as typing a *hard return*. ... The *soft return*, or *

Re: formatting

2020-12-11 Thread Nicholas Andrefsky
Thanks, I'll check it out. On Fri, Dec 11, 2020, 7:27 AM Rory O'Farrell wrote: > On Fri, 11 Dec 2020 11:33:09 + (UTC) > nicholas wrote: > > > Hi > > > > In an effort to create a document that can be printed in landscape > as an 8.5 x 5.5 folding book, I have been struggling with the

Re: formatting

2020-12-11 Thread Rory O'Farrell
On Fri, 11 Dec 2020 11:33:09 + (UTC) nicholas wrote: >     Hi > >     In an effort to create a document that can be printed in landscape as an > 8.5 x 5.5 folding book, I have been struggling with the page set up. > >     Top and bottom margins are set at .59 >     Left and right margins s

formatting

2020-12-11 Thread nicholas
    Hi     In an effort to create a document that can be printed in landscape as an 8.5 x 5.5 folding book, I have been struggling with the page set up.     Top and bottom margins are set at .59     Left and right margins set at 2.99     These don't seem to be working properly and I just can't

Re: Formatting a Newsletter Containing an Index

2020-12-10 Thread Martin Groenescheij
On 10/12/2020 18:33, Brian Barker wrote: At 21:05 10/12/2020 +1000, Jean Lear wrote: I knew there were Hard Returns and Soft Returns but never consciously used them. I now have to understand which, when and where to use them as I add items to the Newsletter. The terms "hard return" and "soft

Re: Formatting a Newsletter Containing an Index

2020-12-10 Thread Brian Barker
At 21:05 10/12/2020 +1000, Jean Lear wrote: I knew there were Hard Returns and Soft Returns but never consciously used them. I now have to understand which, when and where to use them as I add items to the Newsletter. The terms "hard return" and "soft return" are probably unhelpful. Indeed, W

Re: Formatting a Newsletter Containing an Index

2020-12-10 Thread Jean Lear
ave been given to use has worked well for months > >until this week. > > So the question is: what have you changed? There are various > possibilities, I think: > > o You have changed the details of one or other of the paragraph > styles involved to match the other - or at

Formatting a Newsletter Containing an Index

2020-12-09 Thread Jean Lear
is another formatting exercise but that is quite a separate issue. Any suggestions for OO would be appreciated. Thank you. Jean

Re: Formatting

2020-08-10 Thread Howard Bennett
weight, height, blood pressure). I cannot find a way to center > "Summer" > > o Select the three cells which you want the main heading to span (one > of which will contain the word "Summer"). > o Go to Format | Merge Cells (or click the Merge Cells button in the &

Re: Formatting

2020-08-10 Thread Brian Barker
in heading to span (one of which will contain the word "Summer"). o Go to Format | Merge Cells (or click the Merge Cells button in the Formatting toolbar). o If challenged, accept the offer to move the contents of cells now to be hidden to the first cell. o Click the Align Centre Horizo

Formatting

2020-08-10 Thread Howard Bennett
In Excel there is a command under formatting "format cells/alignment/center across selection." This is useful when preparing a spreadsheet for presentation. For instance, I might have 2 or 3 columns fall under the heading Summer (weight, height, blood pressure). I cannot find a way

Re: OpenOffice page formatting

2020-08-07 Thread Rory O'Farrell
On Fri, 7 Aug 2020 11:49:38 -0700 Robert Freedman wrote: > Dear Friends, > > The full text of my document exceeds the visible right hand margin and I > have to keep moving > the bottom horizontal scroll bar back and forth to compose and edit. > I tried to find a solution, under the ‘Format’ menu

OpenOffice page formatting

2020-08-07 Thread Robert Freedman
Dear Friends, The full text of my document exceeds the visible right hand margin and I have to keep moving the bottom horizontal scroll bar back and forth to compose and edit. I tried to find a solution, under the ‘Format’ menu but saw nothing. I also tried changing Portrait to Landscape and incr

Re: Another spreadsheet formatting query

2020-06-11 Thread Martin Groenescheij
Optimal Row Height is not the same as Optimal Column Width On 10/06/2020 23:55, David Deeks wrote: Sorry, here’s attachment ! ... On 10 Jun 2020, at 22:53, Prof wrote: Having had my cell colours query sorted so quickly by you very helpful people, I’m gonna push my luck because I have discov

Re: Another spreadsheet formatting query

2020-06-10 Thread David Deeks
Sorry, here’s attachment ! ... > On 10 Jun 2020, at 22:53, Prof wrote: > > Having had my cell colours query sorted so quickly by you very helpful > people, I’m gonna push my luck because I have discovered another one! > > I am finding that apparently random rows do not set themselves to my sel

Another spreadsheet formatting query

2020-06-10 Thread Prof
Having had my cell colours query sorted so quickly by you very helpful people, I’m gonna push my luck because I have discovered another one! I am finding that apparently random rows do not set themselves to my selected ‘optimal height’? See attached extract from a recordings catalogue. Optimal

Re: Telephone Number Formatting

2020-05-30 Thread Brian Barker
At 11:41 30/05/2020 -0400, Vince Bonly wrote: I have a Calc file that presently has telephone numbers existing within a column. They were previously imported from a source that used the following format: 800 555 1234, and some cells are blank. How can I reformat the column and all existing numb

Re: Telephone Number Formatting

2020-05-30 Thread David Belina
I think this YouTube may answer most of your question: youtube.com/watch?v=QzmAq-x2KM0 On May 30, 2020 at 9:41:34 AM, WA.TWORSX via AOL (wa.two...@verizon.net.invalid) wrote: I have a Calc file that presently has telephone numbersexisting within a column. They were previously imported from a s

Telephone Number Formatting

2020-05-30 Thread WA.TWORSX via AOL
I have a Calc file that presently has telephone numbersexisting within a column. They were previously imported from a source that used the following format: 800 555 1234, and some cells are blank. How can I reformat the column and all existing numbers within the column to be in the form: (

Re: Formatting cells

2018-12-06 Thread David Robley
On 7/12/18 2:46 pm, Brian Barker wrote: At 03:50 07/12/2018 +, John van Barneveld wrote: I use 4.1.5 on Win10. Is it possible to set numeric formatting so that 4 decimal places are displayed and if the value in a cell is zero then that cell displays as Blank. Yes; enter [=0]"&qu

Re: Formatting cells

2018-12-06 Thread Brian Barker
At 03:50 07/12/2018 +, John van Barneveld wrote: I use 4.1.5 on Win10. Is it possible to set numeric formatting so that 4 decimal places are displayed and if the value in a cell is zero then that cell displays as Blank. Yes; enter [=0]"";0. into the "Format code"

Formatting cells

2018-12-06 Thread John van Barneveld
I use 4.1.5 on Win10. Is it possible to set numeric formatting so that 4 decimal places are displayed and if the value in a cell is zero then that cell displays as Blank. Thanks John van Barneveld --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com

Re: formatting

2018-07-30 Thread Rory O'Farrell
On Mon, 30 Jul 2018 06:52:43 -1000 Joan Rawson wrote: > I would like instructions about formatting > johnrawsonpharmac...@gmail.com > You may find this document helpful: https://wiki.openoffice.org/wiki/Documentation/Writer_for_Students -- Rory

Re: formatting

2018-07-30 Thread Wade Smart
Formatting what? -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Mon, Jul 30, 2018 at 11:52 AM, Joan Rawson wrote: > I would like instructions about formatting > johnrawsonpharmac...@gma

formatting

2018-07-30 Thread Joan Rawson
I would like instructions about formatting johnrawsonpharmac...@gmail.com - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org

Re: missing formatting bar

2017-09-16 Thread WA.TWORSX via AOL
TNX ! On 9/16/2017 12:18 PM, Matthias Seidel wrote: View - Toolbars - Formatting ? Am 16.09.2017 um 18:11 schrieb WA.TWORSX via AOL: AOO413m1(Build:9783)  -  Rev. 1761381 2016-09-29 02:39:19 Win10-64bit After opening an existing Calc spreadsheet, the Formatting Bar is missing. How is

Re: missing formatting bar

2017-09-16 Thread Matthias Seidel
View - Toolbars - Formatting ? Am 16.09.2017 um 18:11 schrieb WA.TWORSX via AOL: > AOO413m1(Build:9783)  -  Rev. 1761381 > 2016-09-29 02:39:19 > > Win10-64bit > > After opening an existing Calc spreadsheet, the Formatting Bar is > missing. > > How is th

Re: missing formatting bar

2017-09-16 Thread Rory O'Farrell
On Sat, 16 Sep 2017 12:11:39 -0400 "WA.TWORSX via AOL" wrote: > AOO413m1(Build:9783)  -  Rev. 1761381 > 2016-09-29 02:39:19 > > Win10-64bit > > After opening an existing Calc spreadsheet, the Formatting Bar is missing. > > How is the Formatting bar added bac

missing formatting bar

2017-09-16 Thread WA.TWORSX via AOL
AOO413m1(Build:9783)  -  Rev. 1761381 2016-09-29 02:39:19 Win10-64bit After opening an existing Calc spreadsheet, the Formatting Bar is missing. How is the Formatting bar added back? - To unsubscribe, e-mail: users-unsubscr

Re: Cannot get cells to accept "Date" formatting.

2017-04-12 Thread paulranger
Thank you, Martin. I followed your kind advice and the cell Date formatting seems to be resolved. Sincerely, ranger1. > On 12 Apr 2017, at 6:31 pm, Martin Groenescheij > wrote: > > > > On 12/04/17 6:07 PM, paulranger wrote: >> Hello all, >> >> I a

Re: Cannot get cells to accept "Date" formatting.

2017-04-12 Thread Martin Groenescheij
rrect formatting of the ‘copy’ cell will transfer to the desired cell through the subsequent ‘paste’ action. Alas, the ‘3 / 4’ key entry still displays as a fraction, not a date. Could someone please advise how I can achieve the Date formatting I need? Under Tools (Preference) go to AutoCo

Cannot get cells to accept "Date" formatting.

2017-04-12 Thread paulranger
cript subscript) as a fraction is displayed, not the desired date 3 April 2017. I have tried copying a formatted cell (above the blank cell) which is correctly formatted e.g. “17 Mar 2017” and pasted that into the cell I want to fill, assuming that the correct formatting of the ‘copy’ cell

Re: Formatting Pages in Calc

2017-03-03 Thread Brian Barker
style. You can see this when you go to Format | Page...: the panel is headed Page Style: Default. So all you need is to use a different page style for the rogue sheet. o Go to Format | Styles and Formatting... (or click the Styles and Formatting button in the Formatting toolbar, or press F11

Re: Formatting Pages in CaLc

2017-03-02 Thread Martin Groenescheij
lease. Brute force solution: print the landscape page as a separate PDF; Print the other three pages, and then glue the two PDF files together. Better is to use existing functionalities. Go to Format -> Styles and Formatting, the second icon at the top is Page Styles Create a Landscape and a

Re: Formatting Pages in CaLc

2017-03-02 Thread Julian THOMAS
Sent from JT's iMini - using voice dictation! > On Mar 2, 2017, at 18:44, John van Barneveld > wrote: > > This is fine for printing but I want to save a four page .pdf with the one > page as landscape. Can anyone tell me how to go about this please. Brute force solution: print the landscap

Formatting Pages in CaLc

2017-03-02 Thread John van Barneveld
I have a spreadsheet with four sheets, the third of which I want printed in landscape and the rest in portrait. It seems when I set in Format-Page it formats all four the same forcing me to print each page separately. This is fine for printing but I want to save a four page .pdf with the one pa

Re: Conditional Formatting over Same Range of Cells

2017-02-06 Thread VinceB.
ings at the Format*|*Conditional Formatting dialogue: Condition 1: Cell value isgreater than74 Cell StyleRed if >174 Condition 2: Cell value isgreater than199 Cell StyleBOLD if >199 Scored Condition 3: Cell value isgreater than199 Cell Style

Re: Conditional Formatting over Same Range of Cells

2017-01-25 Thread Brian Barker
riment, I see that is not true: you can achieve what you want. Unfortunately, you don't explain exactly what you have done and what result you see, so anyone is left to guess. Conditional formatting works by applying cell styles. You talk about applying "both red and bold", but

Conditional Formatting over Same Range of Cells

2017-01-25 Thread VinceB.
Using AOO 4.1.2 Calc on my WIN10 desktop, I have succeeded in detecting scores above a threshold (>174) and marking the cell for red font for a specified range of cells. That uses 1 of the 3 available criteria settings. Next, I tried setting a criteria setting (condition 2 of 3) for the same

Re: Problems with File Formatting and Document Display on Open Office Writer

2016-07-19 Thread Brian Barker
extension (once you have replaced the tick) or else by using your operating system's facilities to rename the files, adding the extension manually. I also had difficulty with the formatting of a Word document that I opened in OpenOffice. When I opened the file, the formatting had been thr

Re: Problems with File Formatting and Document Display on Open Office Writer

2016-07-19 Thread Daniel Roma
same formatting as the word.my sister had a similar problem when trying to open documents in Word, and for some reason the windows put the writter as the default program when I open or create word documents the writer, always saved in the word standard, never on writter pattern. try opening the same

Problems with File Formatting and Document Display on Open Office Writer

2016-07-19 Thread e-mail rm004e0578
. I also had difficulty with the formatting of a Word document that I opened in OpenOffice. When I opened the file, the formatting had been thrown around and text boxes were moved and had a strange red arrow in the right-had corner. I have never known of this problem before - could it be due to a

Re: Unwanted interference in text formatting.

2015-10-27 Thread Martin Groenescheij
On 27-Oct-15 10:57, Donald Miller wrote: Unwanted interference in text formatting. In plain text editors, I can manually control formatting, spacing, numbering, indent, et cetera. For example, it is straightforward 1. to start a number list, 2. and continue without any unwanted indents or

Unwanted interference in text formatting.

2015-10-26 Thread Donald Miller
Unwanted interference in text formatting. In plain text editors, I can manually control formatting, spacing, numbering, indent, et cetera. For example, it is straightforward 1. to start a number list, 2. and continue without any unwanted indents or font changes, like a typewriter. LibreOffice

Re: Question about formatting

2015-10-14 Thread Rory O'Farrell
On Wed, 14 Oct 2015 14:16:33 +0100 Rory O'Farrell wrote: > On Wed, 14 Oct 2015 08:51:47 -0400 > Chuck Selvaggio wrote: > > > When I have a new document and want to import a logo (from a jpeg), the > > whole format changes to something that looks like a power point > > presentation. I just wa

Re: Question about formatting

2015-10-14 Thread Rory O'Farrell
On Wed, 14 Oct 2015 08:51:47 -0400 Chuck Selvaggio wrote: > When I have a new document and want to import a logo (from a jpeg), the whole > format changes to something that looks like a power point presentation. I > just want to begin with a clear document, put our logo (Jpeg) at the top and

Question about formatting

2015-10-14 Thread Chuck Selvaggio
When I have a new document and want to import a logo (from a jpeg), the whole format changes to something that looks like a power point presentation. I just want to begin with a clear document, put our logo (Jpeg) at the top and continue typing text. How do I do this? Chuck 302-529-5661….here

Re: Number Formatting

2015-07-28 Thread Dale Erwin
On 7/28/2015 5:12 PM, Dale Erwin wrote: Environment: AOO 4.1.1 under Win 7. I am using a table in Writer for as tabulation because I want some columns left-justified and some columns right-justified. The right-justified columns contain dollars and cents. Every time I enter an amount that en

Number Formatting

2015-07-28 Thread Dale Erwin
Environment: AOO 4.1.1 under Win 7. I am using a table in Writer for as tabulation because I want some columns left-justified and some columns right-justified. The right-justified columns contain dollars and cents. Every time I enter an amount that ends in .00, it eliminates the two zeroes.

Re: Conditional Formatting Issue

2015-05-19 Thread Martin Groenescheij
Sent from my mobile device. > On 19 May 2015, at 10:02 pm, Mobile App wrote: > > Hi, > > I am using open office in fedora21 and I want to use conditional formatting > in my report. We want to apply more than 4 condition on a cell but > openoffice provides only 3 cond

Conditional Formatting Issue

2015-05-19 Thread Mobile App
Hi, I am using open office in fedora21 and I want to use conditional formatting in my report. We want to apply more than 4 condition on a cell but openoffice provides only 3 condition for conditional formatting. Please provide solution for it.

Re: Removing condition formatting using macro

2014-07-08 Thread Ariel Constenla-Haile
Hello João, On Tue, Jul 08, 2014 at 11:02:21AM -0300, "João Paulo R. Rezende" wrote: > Hello, > > I want to create a macro to remove or clear all condition formats in current > sheet. > > I had tried: > > myRange.ConditionalFormat.Clear() > myRange.ConditionalFormat.removeByIndex(index) > myShe

Removing condition formatting using macro

2014-07-08 Thread João Paulo R. Rezende
Hello, I want to create a macro to remove or clear all condition formats in current sheet. I had tried: myRange.ConditionalFormat.Clear() myRange.ConditionalFormat.removeByIndex(index) mySheet.ConditionalFormat.Clear() Already tried, Dim oPropCondition As Object . oPropCondition = oRange

Re: try to clear/default formatting causes lock-ups

2014-05-24 Thread Ariel Constenla-Haile
nd linksall at once. > > I've tried default formatting, too, but same result. > > > > But lately (and I've been using it in multiple computer types), it > locks up. I mean IT IS CRASHED. No use waiting for it to solve > anything. > > >

Re: try to clear/default formatting causes lock-ups

2014-05-24 Thread Andrea Pescetti
On 19/05/2014 John Deaton wrote: you could put any text, etc., and clear formats, and get rid of fonts, paging, paragraphing, and linksall at once. ... But lately (and I've been using it in multiple computer types), it locks up. I mean IT IS CRASHED. No use waiting for it to solve anything.

try to clear/default formatting causes lock-ups

2014-05-19 Thread John Deaton
One of the many great things about OO, until now---and not sure if 4.1.0 is worse (but pretty sure), Is you could put any text, etc., and clear formats, and get rid of fonts, paging, paragraphing, and linksall at once. I've tried default formatting, too, but same result. But lately

Re: AOO writer cell formatting not sticky

2014-04-20 Thread Greg Madden
mating. the > > >'currency' number format. The cells are empty, data gets entered > > >later. Formatting only works if there is a number in the cell. > > > > To achieve what you want, you need to tick Tools | Options... | > > OpenOffice Writer | Table |

Re: AOO writer cell formatting not sticky

2014-04-20 Thread Greg Madden
ls are empty, data gets entered > >later. Formatting only works if there is a number in the cell. > > To achieve what you want, you need to tick Tools | Options... | > OpenOffice Writer | Table | Input in tables | Number recognition. You > may want to experiment with whether you al

Re: AOO writer cell formatting not sticky

2014-04-20 Thread Brian Barker
At 16:34 20/04/2014 -0800, Greg Madden wrote: I am using AOO v 4.0.1, Debian Wheezy, Linux. I create a table in writer, select a range of cells, apply number formating. the 'currency' number format. The cells are empty, data gets entered later. Formatting only works if there is a

AOO writer cell formatting not sticky

2014-04-20 Thread Greg Madden
I am using AOO v 4.0.1 , Debian Wheezy, Linux. I create a table in writer, select a range of cells, apply number formating. the 'currency' number format. The cells are empty , data gets entered later. Formatting only works if there is a number in the cell. Is this normal/desir

Re: email address formatting in Calc

2014-04-03 Thread Don Daugherty
On 3/31/2014 7:21 PM, phalbe henriksen wrote: Hi. I have a Calc spreadsheet that contain about 400 email addresses. They are formatted as plain text, hyper-linked in blue and underlined, and hyper-linked in blue, underlined with a gray background. How can I change the special formatting and

Re: email address formatting in Calc

2014-03-31 Thread Tubular
. How can I change the special formatting and make them all plain text? Nothing I've tried works. Thanks. Phalbe Henriksen working on 50th class reunion - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2241 / Virus Database: 3722/6776 - Release Date: 03/31/14

email address formatting in Calc

2014-03-31 Thread phalbe henriksen
Hi. I have a Calc spreadsheet that contain about 400 email addresses. They are formatted as plain text, hyper-linked in blue and underlined, and hyper-linked in blue, underlined with a gray background. How can I change the special formatting and make them all plain text? Nothing I've tried

Re: Formatting a hyperlink in Calc

2014-03-02 Thread Martin Groenescheij
Tools --> Options --> Appearance ... Visited Links On 3-3-2014 3:47, William K Helbig Jr wrote: Can anyone please me how to format a hyperlink in a Calc cell to appear the way I want it to, not just the way Openoffice wants? Skip H

Formatting a hyperlink in Calc

2014-03-02 Thread William K Helbig Jr
Can anyone please me how to format a hyperlink in a Calc cell to appear the way I want it to, not just the way Openoffice wants? Skip H

Crash during displaying the aid formatting

2013-09-23 Thread Matthieu Riolo
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dear ladies and gentlemen One of our customer is having a problem with AOO 3.4. The failure is a crash (SIGBUS). It occurs each time when an user tries to open the configurationpanel for the aid formatting. Our customer is using Solaris on a sparc

Re: strip formatting??

2013-06-02 Thread johnny smith
On Sun, 02 Jun 2013 03:49:39 -, Patricia Hickin wrote: Is there a way to remove all formatting? please select the text and apply one of the following: 1 press ctrl+m 2 choose 'default formatting' from the 'format' menu 3 choose 'clear formatting' from th

Re: strip formatting??

2013-06-02 Thread Hagar Delest
Le 02/06/2013 07:26, Rory O'Farrell a écrit : /Edit /Paste Special and then choose "text"when offered. Actually Unformatted text. Hagar - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional comman

Re: strip formatting??

2013-06-01 Thread Rory O'Farrell
On Sat, 1 Jun 2013 23:49:39 -0400 Patricia Hickin wrote: > Is there a way to remove all formatting? > > I am copying some items from a website (worldcat.org) to include in a > report and I want to do my own formatting so I would like to strip the > current formatting (font style

Re: strip formatting??

2013-06-01 Thread Doug
On 06/01/2013 11:49 PM, Patricia Hickin wrote: Is there a way to remove all formatting? I am copying some items from a website (worldcat.org) to include in a report and I want to do my own formatting so I would like to strip the current formatting (font style, size, color; italics, etc. Is

  1   2   >