Thousands Separator

Provider:
Open Source Development Co., Ltd. Thailand. The OpenOffice Migration Expert.
Maintainer:
tantai_thanakanok
Rating:
3.333335
Average: 3.3 (3 votes)
Application:
Calc
Tags:
calc, , format, , spreadsheets, , formatting, , spreadsheet, , number, , numbers, , osdev,
Screenshots:
http://www.osdev.co.th/sites/default/files/image/screenshot/thousand_separator.P...
Post date:
Thursday, 19 March, 2009 - 05:54
Statistics
Week: 15 - Month: 79 - Year: 1,497 - Timeline
Download extension
System Independent version - All releases
Compatible with OpenOffice 4: Unknown
User feedback:
Compatible with OpenOffice 4.x?

Add the missing thousands separator button to OpenOffice.org Calc toolbar.

One of the UI element that is missing in Calc compare to Excel 2003 is the thousands separator button on the toolbar. The button will format the numbers in the currently selected cell(s) using a predefined (accounting) format. Though Calc users can do the same using the menu Format > Cell but the converted Excel users usually miss the convenience and ask for the feature.

After installing this simple extension (and restart), you'll see a comma button near the percent button on the Formatting toolbar in Calc. It implements the same behavior as in Excel, e.g. :-
100 -> 100.00
1000 -> 1,000.00
-100 -> (100.00)
-1000 -> (1,000.00)
0 -> -

The only exception is that it will not align the decimal points which is currently not possible in Calc. The format code used is "#,##0.00;(#,##0.00);-#". Comments for improvement of the extension are welcome.

Thousands Separator

Version Operating system Compatibility Release date
1.0.1 System Independent 3.4 11/05/2009 - 22:46 More information Download
1.0.0 System Independent 3.4 11/05/2009 - 05:49 More information Download
0.92.0-beta-4 System Independent 3.4 03/04/2009 - 05:56 More information Download
0.91.3-beta-3 System Independent 3.4 02/04/2009 - 03:36 More information Download
0.91.0-beta-2 System Independent 3.4 24/03/2009 - 04:25 More information Download
0.9.0-beta-1 System Independent 3.4 19/03/2009 - 05:59 More information Download

Comments

Since your extension involves adding a non existing button, I just wanted to stress that another important menu command is notably missing among those that can have buttons: the rulers view/hide switch in Impress and draw.
In my experience this command is often used when creating drawings or presentation pages, normally you want the rules to be hidden since they eat up a lot of screen, but very frequently you need them for quick operation that need size and distances measurement.
Well, while almost everything of the Impress/draw interface can be switched through specific buttons, there is NO way to add a button for this - I noticed this a few years ago, and posted a bug report - the thing was confirmed, but afaik the problem has never been addressed.
The only way to go is through the menu.

Maybe you could do it separately or put the functionality together in the same extension....
Thanks for the attention,
Andrea

It would make more sense if 0 -> 0 instead of -.

Please change the current behaviour, because this behaviour can really break things.
( 0 is a number, I mean, can be used as one and "-" is a string with one character in that can not be used as a number )

Don't forget Europa and the rest of the world.
We use the comma as the decimal separator while using the point as the thousands separator.

It would make more sense if 0 -> 0 instead of -.

Please change the current behaviour, because this behaviour can really break things.
( 0 is a number, I mean, can be used as one and "-" is a string with one character in that can not be used as a number )

in our language as well as in many others comma is decimal separator and space or dot is used as a thousand separator, it would be nice to have locale specific thousands separator.

Regards!

The only exception is that it will not align the decimal points which is currently not possible in Calc...

When I have done this by formating, I leave a blank space for the positive numbers that give the space for ')':

The format code used is "#,###.00;(#,##0.00);-#"

What I have used is: "#,##0.00 ;(#,##0.00)

would you please post a screenshot?