Thousands Separatorby Open Source Development Co., Ltd. Thailand. 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. :- 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. License: opensource | Read license Further product information: Screenshots | Product details 
|
||
Report abuse here
By any use of this Website, you agree to be bound by these Policies and Terms of Use
Sun, Sun Microsystems, the Sun logo, Java, Solaris, StarOffice are trademarks or registered trademarks of Sun Microsystems, Inc. in the United States and other countries.
Comments
improvements
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!
I think is possible to align the decimal point
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)
screenshot
would you please post a screenshot?