Issue 111926 - Accountancy number formatting missing
Summary: Accountancy number formatting missing
Status: CLOSED DUPLICATE of issue 15756
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 1.0.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Keywords: oooqa
Depends on:
Reported: 2010-05-29 14:52 UTC by anakaday
Modified: 2013-08-07 15:13 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description anakaday 2010-05-29 14:52:08 UTC
Standard accountancy number formatting is missing.
Minus signs in brackets (5,000.00)and zero should display as a dash -. 
It is possible to copy the forumala from another spreadsheet programme but it 
should be included in the number formatting function.
Comment 1 Joe Smith 2010-05-29 22:49:47 UTC
Maybe a duplicate: Issue 15773 deals with providing an "accounting" format for
values, but I can't tell if this is asking for the same format.
Comment 2 anakaday 2010-05-30 01:06:35 UTC
The other issue does not relate to standard accountancy practice. It relates to 
currency symbols and a button not working properly. There is a difference 
between 'accounting' and professional accountancy practice used by various 
professionals. Currency numbers are not accountancy numbers. The currency 
symbol is typed a column or row and the number formatting of the data is as 
above without currency symbols and negative numbers in brackets and 0s as -. 
For those who don't know how to create their own formatting, the software would 
be unusable.

Another point is single and double underline. For accountancy purposes the 
underlines have to cover the whole cell not just the text within the cell. 
Formatting borders function is not appropriate to use for this purpose as these 
symbols are typed on a regular basis. There should be a drop down box with 
standard accountancy underline combinations - single top and double bottom, 
single top and single bottom, single top, single bottom, double bottom, thick 
bottom. Excel recognises that this is vital ( but they don't recognise 
accountancy number format) The borders function is used for special formatting 
only not to create standard underline formats.

 Accountants and bookkeepers are frustrated with this. It appears to them that 
spreadsheet software has alot of fancy functions but doesn't pay attention to a 
few of the key fundamentals underpinning what they are about.
Comment 3 Joe Smith 2010-05-31 03:50:00 UTC
Requests here are most likely to get attention if they
a) focus on a single, specific topic, and
b) spell out as clearly as possible exactly what is needed.

I believe the underlining you mentioned is covered by Issue 23839.

> Minus signs in brackets (5,000.00)and zero should display as a dash -.

This is possible with Calc's current number formats, using a custom number
format, something like this: #,##0.--;(#,##0.--);--

  |     Value |   Formatted |
  |  12345.67 |   12,345.67 |
  | -12346.67 | (12,346.67) |
  |     12345 |   12,345.-- |
  |         0 |          -- |

If that's not what you're after, please give some clear examples showing the
values and the formatted display.
Comment 4 Regina Henschel 2010-10-14 13:47:42 UTC
I think the requests for a "accountancy number format" should be collected in
one issue. Therefore I set this as duplicate to issue 15756. (The underline is
covert by issue 23839.)

*** This issue has been marked as a duplicate of 15756 ***
Comment 5 Regina Henschel 2010-10-14 13:48:31 UTC
closing, duplicate