Issue 15756 - Calc should provide a pre-defined number format for displaying negative numbers in brackets. Example: -100.00 to format as (100.00).
Summary: Calc should provide a pre-defined number format for displaying negative numbe...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 1.0.3
Hardware: All All
: P4 Trivial with 5 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: ms_interoperability, rfe_eval_ok, usability
: 33876 110016 111926 113026 (view as issue list)
Depends on:
Blocks:
 
Reported: 2003-06-18 09:33 UTC by Unknown
Modified: 2013-08-07 15:12 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Screenshot of the feature in Excel 2000 (exists also at least in 97) (10.43 KB, image/png)
2003-09-01 12:35 UTC, nicu_ooo 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2003-06-18 09:33:04 UTC 
Hi,

I am a user in Malaysia. For formatting negative numbers, normally we use it in
bracket.

Example: -100.00 to format as (100.00).

However when we go to Format/Cells/Numbers to format the negative number, there
is no option to choose it to shows as in bracket. In MS Excel, it work like magic.

Now I know it can be formatted manually as #,##0.00; (* #,##0.00).

However I would appreciate it if OOo project can include this formatting option
in the menu instead for the users to search needlessly for a simple solution.

Thank you.
Comment 1 nicu_ooo 2003-08-29 08:30:51 UTC 
this looks like a duplicate of 16759, but please don't close it as
DUPLICATE or WORKSFORME.
in MS Office this is a predefined format for numbers, users are
expecting to find it also in OOo and the string #,##0.00;(* #,##0.00)
is pretty long
Comment 2 frank 2003-09-01 12:10:27 UTC 
Hi,

this is a double to Issue 16759 and No it's not a defined numberformat
in Excel, at least not in mine.

Hi Bettina,

1 4 u.

Frank
Comment 3 nicu_ooo 2003-09-01 12:35:21 UTC 
Created attachment 8922 [details]
Screenshot of the feature in Excel 2000 (exists also at least in 97)
Comment 4 afrayer 2003-09-04 20:18:00 UTC 
Yes, it's a duplicate of 16759, but rather than simply requiring the 
user to define his/her own format, the user should be able to choose 
this one from a predetermined list.

This format of displaying negative numbers in parentheses has been 
used for ages in accounting, and is a CRITICAL feature in getting 
adoption of Calc by accounting firms.

Please provide this as a stock format.
Comment 5 bettina.haberer 2003-12-04 17:22:30 UTC 
Summary: A further numberformat 'Number Formatting - Negative in Bracket'.
Hello Niklas, please give approval for this evaluated OO.o 2.0 flagged
issue. 
If you confirm with the target OO.o 2.0, then please keep it on your
owner (or the owner of the concerning developer) for implementation.
In case you want this issue for 'OOo Later', then please reset the
target milestone. If you decline the issue finally, please set the
resolution to 'Wontfix' (but do not close). In case of 'OOo Later' or
'Wontfix' please reset it on Bettina's owner. Thank you.
Comment 6 bettina.haberer 2004-04-08 20:21:05 UTC 
Considered for OO.o later.
Comment 7 frank 2004-09-06 14:59:48 UTC 
*** Issue 33876 has been marked as a duplicate of this issue. ***
Comment 8 erwin.tenhumberg 2004-11-09 14:01:02 UTC 
enhanced summary, set keywords and reassigned issue according to RFE process
Comment 9 Regina Henschel 2010-10-14 13:47:41 UTC 
*** Issue 111926 has been marked as a duplicate of this issue. ***
Comment 10 Regina Henschel 2010-10-14 13:49:37 UTC 
*** Issue 110016 has been marked as a duplicate of this issue. ***
Comment 11 Regina Henschel 2010-10-14 13:51:10 UTC 
*** Issue 113026 has been marked as a duplicate of this issue. ***
Comment 12 Regina Henschel 2010-10-14 13:55:22 UTC 
For further descriptions see the duplicate issues. Such a "accountancy number
format" might need to include underlining too, see issue 23839.