Issue 16451

Summary:	Missing 'Bookkeeping'-format code
Product:	Calc	Reporter:	Unknown <non-migrated>
Component:	ui	Assignee:	niklas.nebel
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P4	CC:	issues
Version:	644
Target Milestone:	---
Hardware:	All
OS:	Windows 2000
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---

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.