Bug 34943 - Financial formatting (Accounting notation) requirement
Summary: Financial formatting (Accounting notation) requirement
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.1 release
Hardware: Other All
: high enhancement
Assignee: Noel Power
URL:
Whiteboard: feature target:3.6
Keywords:
Depends on:
Blocks:
 
Reported: 2011-03-02 13:18 UTC by Tom Stone
Modified: 2016-08-06 20:25 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Tom Stone 2011-03-02 13:18:17 UTC
Financial customers insist on having financial cell formatting comparable to Excel.  This includes a left justified currency symbol with right justified numbers; single and double underlining in cells with no data, not as a cell border; and negative numbers encased within parenthesis instead of a leading minus symbol.  These are considered required standards for financial spreadsheet formatting in the USA.

This is common to all OS platforms and has been requested several times over the years for OpenOffice.
Comment 1 Kohei Yoshida 2011-03-02 13:32:05 UTC
Yes, I know this one.  It's been requested several times from several different people.  I was just thinking about this yesterday.

I'll keep this for the time being.  I don't know when we can implemented this, but I know we need to implement this someday.
Comment 2 Tom Stone 2011-03-08 19:36:15 UTC
(In reply to comment #1)
> Yes, I know this one.  It's been requested several times from several different
> people.  I was just thinking about this yesterday.
> 
> I'll keep this for the time being.  I don't know when we can implemented this,
> but I know we need to implement this someday.

It has been a complete show-stopper for 3 deployments of OpenOffice that I have tried to implement.  We just couldn't come up with work-arounds that satisfied their accounting departments and other financial people.

I don't know what needs to be done in order to get more attention on this issue but it has been a real problem.
Comment 3 Kohei Yoshida 2011-05-25 08:07:41 UTC
I'd like to take a stab at this for 3.5.
Comment 4 Kohei Yoshida 2011-10-25 08:01:23 UTC
I'm afraid my plate is full for 3.5.
Comment 5 Kohei Yoshida 2012-06-01 12:14:31 UTC
Noel is working on this, if not already done.  I'll re-assign this to him.
Comment 6 Noel Power 2012-06-01 13:16:07 UTC
(In reply to comment #5)
> Noel is working on this, if not already done.  I'll re-assign this to him.

no, not done ( some promising proof of concept implementation has been done though ) unfortunately requires an odf format change, not sure when we will be able to do this ( depends on reaction of odf committee to our proposed changes to file format )
Comment 7 Noel Power 2013-02-05 15:05:32 UTC
it's at least available for 4.0 ( can't recall if it made the later 3.6 builds, I don't think it did )

closing as fixed