Issue 16451 - Missing 'Bookkeeping'-format code
Summary: Missing 'Bookkeeping'-format code
Status: CLOSED DUPLICATE of issue 15773
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 644
Hardware: All Windows 2000
: P4 Trivial (vote)
Target Milestone: ---
Assignee: niklas.nebel
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-07-04 14:12 UTC by Unknown
Modified: 2013-08-07 15:15 UTC (History)
1 user (show)

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

Attachments
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-07-04 14:12:25 UTC 
In Excel under 'format cell' there is a category called 'bookkeeping'. It is
almost the same as 'currency' but the currency symbol ($, Euro, SFr. in my
case...) is left aligned and the value is right aligned. Also if it is set to 0
it places a dash (-) instead of the number 0 (this works correct):

Currency:
|   SFr. 550.70|
|  SFr. 5054.20|
|SFr. 145477.55|
|     SFr. 0.00|

Bookkeeping:
|SFr.    550.70|
|SFr.   5054.20|
|SFr. 145477.55|
|SFr.         -|

When opening an excel file with fields formated this way the format code looks
like this:

Currency (correct):
"SFr."\ #'##0.00;[ROT]"SFr."\ #'##0.00

Bookkeeping:
_ "SFr."\ * #'##0.00_ ;_ "SFr."\ * \-#'##0.00_ ;_ "SFr."\ * "-"??_ ;_ @_ 

It seems that the format function doesn't get the width of the cell to correctly
set the width of the '*' in the format code.
Comment 1 oc 2003-09-17 09:41:27 UTC 
Hi Bettina, one4you
Comment 2 bettina.haberer 2004-01-28 18:18:48 UTC 
Summary: In Excel under 'format cell' there is a category called 'bookkeeping'.
It is almost the same as 'currency' but the currency symbol ($, Euro, SFr. in my
case...) is left aligned and the value is right aligned. Also if it is set to 0
it places a dash (-) instead of the number 0 (this works correct).
Hello Niklas, I consider this as a nice enhancement. 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 3 niklas.nebel 2004-01-30 10:24:22 UTC 
Same as 15773.

*** This issue has been marked as a duplicate of 15773 ***
Comment 4 niklas.nebel 2004-01-30 10:25:07 UTC 
closing duplicate.