To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110016 Issue #|110016 Summary|Add number format presets with negatives in parenthese |s, for financial/accounting uses. Component|Spreadsheet Version|OOO310m9 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P4 Subcomponent|formatting Assigned to|spreadsheet Reported by|rjpaiz
------- Additional comments from [email protected] Wed Mar 10 14:14:34 +0000 2010 ------- OpenOffice.org does not include presets that use parentheses instead of a minus sign to denote negative numbers. For financial and accounting purposes, negatives in parentheses and in red are often the standard. It is also common to show a centered or offset hyphen instead of a zero to make scanning a spreadsheet or report easier. Please add the following number formats to the standard built-in presets: Number ------ #,##0_);[RED](#,##0);" - " #,##0.00_);[RED](#,##0.00);" - " Percent ------- #,##0%_);[RED](#,##0%);" - " #,##0.00%_);[RED](#,##0.00%);" - " Currency (using USD as an example) --------------------------------- [$$-409]#,##0_);[RED][$$-409](#,##0);" - " [$$-409]#,##0.00_);[RED][$$-409](#,##0.00);" - " Ideally, OOo would also supply a "Negative numbers in parentheses" checkbox just below the "Negative numbers red" checkbox already available. Please note that there are two spaces before and after the hyphen in the zero format. This is so that the hyphens display correctly (and pleasingly) whether the numbers are centered or right-justified. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
