https://bugs.freedesktop.org/show_bug.cgi?id=45780
Bug #: 45780
Summary: Accounting notation FORMATTING
Classification: Unclassified
Product: LibreOffice
Version: unspecified
Platform: All
OS/Version: All
Status: NEW
Severity: major
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Brief: Add Accounting number format to left justify the currency symbol and
right justify the decimal number within a cell and use "()" for negative
numbers.
This is a long standing bug/deficiency from the early OOo days. This does not
get many votes because the people that _REQUIRE_ this are not the population of
people who report bugs, they are the _ADOPTERS_, the very people we are trying
to target. All they know, or want to know, is that "it just doesn't work".
This needs to be elevated and dealt with. This may seem trifling to us, but
this goes straight to the heart of our credibility to those we are trying to
get to adopt LO in particular and FOSS in general: "If they can't even do this,
what else must be wrong". They don't want to know, need to know or should have
to know the inner workings of the FOSS development process.
OPTION1: A format notation functionally similar to the M$ Excel "*?" which
expands whatever the "?" character is to fill the cell. For example:
[>0]$* #,##0.00;[<0][RED]$* (#,##0.00);$* -##;@
OPTION 2: A notation to left, center or right justify the following characters
within the cell. For example:
[>0][LJ]$[RJ]#,##0.00;[<0][RED][LJ]$[RJ](#,##0.00);[LJ]$[RJ]-##;@
This will give as a significant extra general formatting tool as well as solve
this particular problem.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
