x64
Hello! Is Open Office available in x64? Thanks! ed
Re: Formatting for USA Telephone Numbers
Vince, 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). There is no need for quotation marks. You can put any text you want when you are defining the format of a number. Make sure the width of the column is wide enough for all of the characters otherwise you’ll get the error code ### which signifies a number too wide to display. Steve Sent from my iPhone > On Feb 23, 2022, at 10:14 PM, PCS wrote: > > > Setting the cell format to “Text” and entering the number exactly as you want > it to look should do the trick, though the use of brackets (and maybe some > other characters?) will give an invalid formula correction warning to which > you will have to respond “No”. The resultant text does not have to be left > justified, you can select the justification you want in the top menu bar, as > normal. However the number entered as text will be text, you will not be able > to do any numerical operations with it. > > You can also enter a number as text without setting the cell format to text > by typing ="123 456” (with your number of course, not 123 446) > > PCS > > >> On 24 Feb 2022, at 12:33 pm, Vince@Verizon >> wrote: >> >> Hi: >> >> How do I format cells for entry of USA Telephone Numbers, as: 1 (###) >> ###*-* >> >> whenever, for example,I have typed a ten-digit number, e.g., 1234567890 (no >> spaces, no negative/minus sign, no parenthesis, by use of the number keypad >> (NumLk is enabled). >> >> Yes, I want the "1" prefix, the area code to appear within parenthesis, 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. >> >> 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 >> 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. >> > - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Formatting for USA Telephone Numbers
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 leading zeroes in any of the three groups - which can certainly occur in the final group. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Formatting for USA Telephone Numbers
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 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 leading zeroes in any of the > three groups - which can certainly occur in the final group. > > Brian Barker > > > - > 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: failure to close Open Office from a Forced Shutdown
How can Open Office be closed after the Forced Shutdown Box appears saying, "Your documents are Being Saved? the Save will not Start and the Shut Down is not Occuring. Clicking the X boxes does noting, - Thanks - Sam Emm - tenderbastard.com
Lost tekst because of filter pop up
l.s. I wrote a book and when opening Open Office Writer again there was a pop up screen informing me about the ASCII-filteroptions. I don’t know the filteroptions used. I cannot open my booktext anymore in the used language. All I see is pages full of ### . How to get my original tekst back? Thanks in advance
Re: Formatting for USA Telephone Numbers
In article <64a75984-4f03-422e-7ccb-0358112cb1f6 @verizon.net>, wa.two...@verizon.net.INVALID says... > > Hi: > > How do I format cells for entry of USA Telephone Numbers, as: Â Â Â 1 > (###) ###*-* > > whenever, for example,I have typed a ten-digit number, e.g., 1234567890 > (no spaces, no negative/minus sign, no parenthesis, by use of the number > keypad (NumLk is enabled). > > Yes, I want the "1" prefix, the area code to appear within parenthesis, > 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. > > 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 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. Format the cell as text and enter the characters as you want them to be displayed. trying to enter it as a number format will not get you to where you want. As Brian stated, Entering the way you want are not numeric values, but text. Keith N. McKenna - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: x64
In article , edgur...@msn.com says... > > Hello! > > Is Open Office available in x64? Thanks! > > > > ed Currently Apache OpenOffice is only available as 32-bit on Window. However It runs perfectly fine on a 64 bit system. The only proviso is that you MUST install a 32-bit Java. Regards Keith N. McKenna - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Formatting for USA Telephone Numbers
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 <64a75984-4f03-422e-7ccb-0358112cb1f6 > @verizon.net>, wa.two...@verizon.net.INVALID says... >> >> Hi: >> >> How do I format cells for entry of USA Telephone Numbers, as: Â Â Â 1 >> (###) ###*-* >> >> whenever, for example,I have typed a ten-digit number, e.g., 1234567890 >> (no spaces, no negative/minus sign, no parenthesis, by use of the number >> keypad (NumLk is enabled). >> >> Yes, I want the "1" prefix, the area code to appear within parenthesis, >> 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. >> >> 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 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. > > Format the cell as text and enter the characters as you > want them to be displayed. trying to enter it as a number > format will not get you to where you want. As Brian > stated, Entering the way you want are not numeric values, > but text. > > Keith N. McKenna > > > > - > 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: Formatting for USA Telephone Numbers
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 user types a string of zeroes - perhaps to represent that no phone number is provided. In any case, it is odd to choose to use the character (hash) that specifically drops leading zeroes instead of the obvious one (zero) that faithfully reproduces the input digits when one knows that dropping zeroes will never be needed. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Formatting for USA Telephone Numbers
At 19:53 24/02/2022 -0500, Keith N. McKenna wrote: Format the cell as text and enter the characters as you want them to be displayed. But that doesn't address the problem I understood the questioner to be posing: he wants, I think, to be able to enter just the ten digits and have 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 creates text values would be to enter the plain ten-digit values into one column and to create a suitable formula in another column to extract the appropriate parts and add the punctuation. The unwanted entry column could then be hidden or have the reformatted values pasted over it, or it could have been placed elsewhere, perhaps even on another sheet. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Lost tekst because of filter pop up
On Thu, 24 Feb 2022 22:00:38 + Alex Hemme wrote: > > > l.s. > > I wrote a book and when opening Open Office Writer again there was a pop up > screen informing me about the ASCII-filteroptions. I don’t know the > filteroptions used. I cannot open my booktext anymore in the used language. > All I see is pages full of ### . How to get my original tekst back? > > Thanks in advance The file is damaged beyond repair, possibly due to over hasty power off of your computer or closure of laptop lid, before the file had been finally written to disk from the internal write buffers of the disk apparatus. As soon as possible try the methods in this tutorial https://forum.openoffice.org/en/forum/viewtopic.php?f=71&t=85038 for detailed instructions on how to a) use Previous Versions (W7 and later) to recover previous versions of the file. b) recover your file as it was when you last opened or saved it, or as it was when it was last saved with AutoRecovery; c) find previous versions of the file in the folder it is located in, but which have since been deleted; d) un-delete the temporary files AOO wrote while you were editing the file, and then deleted. This may recover your file as it was when you last opened or you last saved it. -- Rory O'Farrell - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
