Issue 39682 - "Accounting" Format for cells
Summary: "Accounting" Format for cells
Status: CLOSED DUPLICATE of issue 31799
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 1.1.4
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-12-29 21:10 UTC by winchester
Modified: 2005-01-13 16: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 winchester 2004-12-29 21:10:42 UTC 
I am having difficulty replicating the "Accounting" Format in Excel. When I
copied a spreadsheet from Excel it duplicated the format code exactly as a user
defined category under the numbers tab in the format cells area. However there
are two very important formating problems.

1st the $ sign lines up immediately to the left of the number as apposed to the
left side of the cell.  For example [space][space][space]$1,999 as apposed to
$[space][space][space]1,999.

2nd the underline only goes under the numbers not the entire cell as in Excel. 
Putting a border on the bottom of a cell is not an acceptable alternative.

I think the program is great, however until I can find a solution to the two
formating issues I can't switch to it and abandon Excel (all the financial
statements I prepare use the Excel "accounting" format).
Comment 1 frank 2005-01-13 16:14:54 UTC 
Hi,

this is a double Issue 31799.

Frank

PS You may change your votes.

*** This issue has been marked as a duplicate of 31799 ***
Comment 2 frank 2005-01-13 16:15:12 UTC 
closed double