Glitch: "Retaining comma sign in a dollar value" in a Table

Discuss the word processor

Glitch: "Retaining comma sign in a dollar value" in a Table

Postby wdc » Thu Jul 11, 2019 11:07 pm

I have run into this frustrating (but not serious) problem using OO Tables. I'd appreciate someone spotting my error.

When I insert a a value like "$ 15,000" (with the comma) in a table, the comma diasappears after about 10 seconds.

As ever, thanks much. ....wdc
OpenOffice 4.1.1 for Windows in English/ W8.1 (with Firefox)
wdc
 
Posts: 114
Joined: Wed Apr 11, 2012 3:34 pm

Re: Glitch: "Retaining comma sign in a dollar value" in a Ta

Postby robleyd » Fri Jul 12, 2019 2:01 am

Which application are you referring to - Writer or Calc ?
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2982
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Glitch: "Retaining comma sign in a dollar value" in a Ta

Postby wdc » Fri Jul 12, 2019 3:30 am

Writer. ...wdc
Last edited by MrProgrammer on Fri Jul 12, 2019 4:11 am, edited 1 time in total.
Reason: Moved to Writer forum -- MrProgrammer 2019-07-11 21:11
OpenOffice 4.1.1 for Windows in English/ W8.1 (with Firefox)
wdc
 
Posts: 114
Joined: Wed Apr 11, 2012 3:34 pm

Re: Glitch: "Retaining comma sign in a dollar value" in a Ta

Postby robleyd » Fri Jul 12, 2019 4:45 am

You may need to modify the number format that is applied to the cell(s) when you enter currency - right click in the cell and select Number format...
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2982
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Glitch: "Retaining comma sign in a dollar value" in a Ta

Postby Bill » Fri Jul 12, 2019 4:13 pm

I haven't been able to duplicate the problem with AOO 4.1.6 on Manjaro. With English (USA) as the locale and USD $ English (USA) as the default currency, the Currency Number Format includes thousands separators (commas) by default. If the currency amount is typed in without the commas, they are added automatically. They are never removed automatically.
AOO 4.1.6 and LO 6.2.0.3 on Manjaro MATE
Bill
Volunteer
 
Posts: 7372
Joined: Sat Nov 24, 2007 6:48 am

Re: Glitch: "Retaining comma sign in a dollar value" in a Ta

Postby wdc » Sat Jul 13, 2019 5:06 pm

Thanks all.
I'm afraid I have not corrected things quite yet.

To review, I want numbers (like 1,234 to appear in an OO Table).
I have:
Right clicked the number itself. This brought up the Number Format screen.
I highlighted\: Number and -1,234
I selected Language as Default English/USA

Under Options, I checked only "thousands separator"
Finally, I checked OK

BUT, that did not work. Still I get numbers in tables entries that keep "losing" the thousand-separators.

Can someone see what I am continue to do wrong?

Thanks for your patience. .... wdc
OpenOffice 4.1.1 for Windows in English/ W8.1 (with Firefox)
wdc
 
Posts: 114
Joined: Wed Apr 11, 2012 3:34 pm

Re: Glitch: "Retaining comma sign in a dollar value" in a Ta

Postby RusselB » Sat Jul 13, 2019 5:18 pm

Please upload/attach a sample of your document, as that way we will be working with any settings that you have made that are document dependent.

Quick after thought, have you checked that the formatting for the cells that are not retaining the comma match the formatting of the cells that do?
I haven't needed to use a table in this manner in Writer, but it sounds to me like you might have to set/adjust the formatting for each cell in the table...or highlight the entire table and set the formatting that way.
OpenOffice 4.1.7 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5486
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON


Return to Writer

Who is online

Users browsing this forum: No registered users and 38 guests