[Libreoffice-bugs] [Bug 63536] Add Accounting format code to currency list

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63536

--- Comment #17 from Bookkeeper  ---
Thanks for the resolution this was very helpful, accounting services
https://jugma.lt

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 63536] Add Accounting format code to currency list

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63536

--- Comment #16 from Laurent BP  ---
(In reply to tom from comment #15)
> P.P.S: The 0 can alternatively be displayed as
> "- €" or "$ -" respectively

For which localization?
Any reference where some acceptance rules are defined?
I wrote:
(In reply to Laurent BP from comment #9)
> We may add some more formats but we need some references: currency unit can
> be on left or right, negative numbers can be in red or not, with a minus
> sign or with parentheses, zeros can be displayed as --, etc. There are many
> possibilities depending on locales acceptance rules.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 63536] Add Accounting format code to currency list

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63536

t...@lautenbacher.biz changed:

   What|Removed |Added

 CC||t...@lautenbacher.biz

--- Comment #15 from t...@lautenbacher.biz ---
P.P.S: The 0 can alternatively be displayed as
"- €" or "$ -" respectively

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 63536] Add Accounting format code to currency list

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63536

--- Comment #14 from t...@lautenbacher.biz ---
P.S.: To be 100% clear and not make misunderstandings here the exact formatting
including currency and needed for accounting style formatting:

Numbers should be formatted:
10 -> "10,00 €"
0 -> "-"
-10 -> either "(10,00 €)" or "-10,00 €" in red, as per user selection.

for US-style Dollars that would be:

10 -> "$10.00"
0 -> "-"
-10 -> either "($10.00)" or "-$10.00" in red, as per user selection.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 63536] Add Accounting format code to currency list

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63536

--- Comment #13 from t...@lautenbacher.biz ---
7 years passed and yet Calc is still left without the professional accounting
number format. I believe that this is a shame for Calc.

Numbers should be formated:
10 -> "10"
0 -> "-"
-10 -> either "(10)" or "-10" in red, as per user selection.

The magic about this format is the 0. Having huge accounting sheets full of
"0,00 €" makes e.g. the "1,00 €" in this only one cell almost invisible.

Having all cells filled with "-" instead "0,00 €", makes the "1,00 €" be very
distinct for the eye.

Can someone please be so kind to add this, is seems super easy to code.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 63536] Add Accounting format code to currency list

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63536

Cor Nouws  changed:

   What|Removed |Added

 Status|RESOLVED|NEW
 Resolution|INSUFFICIENTDATA|---

--- Comment #12 from Cor Nouws  ---
(In reply to jani from comment #8)
> There seems to be missing consensus about what should be added (like having
> an accounting look at it), I would suspect too that this would be country or
> at least region specific.

IMO comment #0 and comment #2 are clear enough > NEW

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 63536] Add Accounting format code to currency list

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63536

QA Administrators  changed:

   What|Removed |Added

 Status|NEEDINFO|RESOLVED
 Resolution|--- |INSUFFICIENTDATA

--- Comment #11 from QA Administrators  ---
Dear Bug Submitter,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-20170328

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 63536] Add Accounting format code to currency list

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63536

--- Comment #10 from QA Administrators  ---
Dear Bug Submitter,

This bug has been in NEEDINFO status with no change for at least
6 months. Please provide the requested information as soon as
possible and mark the bug as UNCONFIRMED. Due to regular bug
tracker maintenance, if the bug is still in NEEDINFO status with
no change in 30 days the QA team will close the bug as INSUFFICIENTDATA
due to lack of needed information.

For more information about our NEEDINFO policy please read the
wiki located here:
https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO

If you have already provided the requested information, please
mark the bug as UNCONFIRMED so that the QA team knows that the
bug is ready to be confirmed.

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-NeedInfo-Ping-20170131

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 63536] Add Accounting format code to currency list

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63536

--- Comment #9 from Laurent BP  ---
LibO, with en-US and en_GB locales, already contains two currency formats with
left justify currency symbol and right justify decimal number:
[$$-409]* #,##0;-[$$-409]* #,##0
[$$-409]* #,##0.00;-[$$-409]* #,##0.00

These formats are defined in
http://opengrok.libreoffice.org/xref/core/i18npool/source/localedata/data/en_US.xml#113
[CURRENCY]* #,##0;-[CURRENCY]* #,##0


   [CURRENCY]* #,##0.00;-[CURRENCY]* #,##0.00


This was added 4 years ago:
https://cgit.freedesktop.org/libreoffice/core/commit?id=84c54990c0dbd3385a4a653afe63d0fa7b1c435b
We may add some more formats but we need some references: currency unit can be
on left or right, negative numbers can be in red or not, with a minus sign or
with parentheses, zeros can be displayed as --, etc. There are many
possibilities depending on locales acceptance rules.

As I have no accounting capacities, I looked to other spreadsheet for fr-FR:
Gnumeric proposes:
_(0,00*  [$€-1]_);_((0,00)*  [$€-1];_("-"??*  [$€-1]_);_(@_)
Excel 2010:
_-* # ##0,00 €_-;-* # ##0,00 €_-;_-* "-"?? €_-;_-@_-
I would prefer Excel proposition as there is thousand separator and decimal are
aligned.
According to help
https://support.office.com/en-US/article/Format-numbers-as-currency-0A03BB38-1A07-458D-9E30-2B54366BC7A4
Accounting format for en-US in Excel may look like:
[$$-409]* #,##0.00_);[$$-409]* (#,##0.00);[$$-409]* -_);_(@_)

This has to be defined for each locale which needs an accounting format. There
are 198 XML files in
http://opengrok.libreoffice.org/xref/core/i18npool/source/localedata/data to be
modified. But they can be modified one after one, when localization teams
decide what is the best format for each.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 63536] Add Accounting format code to currency list

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63536

jan iversen  changed:

   What|Removed |Added

 Status|NEW |NEEDINFO

--- Comment #8 from jan iversen  ---
There seems to be missing consensus about what should be added (like having an
accounting look at it), I would suspect too that this would be country or at
least region specific.

So first we need to have 1 (or more) fixed definitions, then we can add them.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 63536] Add Accounting format code to currency list

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63536

Cor Nouws  changed:

   What|Removed |Added

   Keywords||needsDevEval
 CC||c...@nouenoff.nl,
   ||j...@documentfoundation.org

--- Comment #7 from Cor Nouws  ---
waiting in silence.. maybe relatively easy, Jani/dev x ?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 63536] Add Accounting format code to currency list

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63536

Laurent BP  changed:

   What|Removed |Added

 CC||jumbo4...@yahoo.fr

--- Comment #6 from Laurent BP  ---
In en_US, three last currency formats have currency symbol left aligned. If
that not fit your needs, you may suggest new format with some reference.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 63536] Add Accounting format code to currency list

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63536

Laurent BP  changed:

   What|Removed |Added

 CC||rk...@verizon.net

--- Comment #5 from Laurent BP  ---
*** Bug 78542 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 63536] Add Accounting format code to currency list

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=63536

m.a.riosv miguelange...@libreoffice.org changed:

   What|Removed |Added

 CC||marcelo_javier_ruiz@yahoo.c
   ||om.ar

--- Comment #4 from m.a.riosv miguelange...@libreoffice.org ---
*** Bug 92121 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 63536] Add Accounting format code to currency list

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=63536

Qubit qu...@runcibility.com changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
   Severity|normal  |enhancement
 CC||qu...@runcibility.com
 Ever confirmed|0   |1

--- Comment #3 from Qubit qu...@runcibility.com ---
(In reply to comment #2)
 ...As I have bellowed from my soap-box
 before, we must make this work for the adopters and leaving this other
 piece undone creates a barrier to them.

Smells like an enhancement.

 
 This bug report is an effort to drop the other shoe and bring that remaining
 piece to the fore to be addressed. (And does not get lost in the
 completion of the primary bug.)
 
 It's not a very challenging fix unlike the technical underpinnings.  The
 biggest issue would be what the formatting code should be (I would defer to
 a professional accountant for that).  But I would amend my original
 suggestion to correct the right-indent of the negative value:
 
 [$$-409]* #,##0.00_);[RED][$$-409]* (#,##0.00)_);[$$-409]* -_)

Feel free to submit a patch for this.

 
 Separately, I feel LO should add the ability of a user to define number
 formats and then have [Add] and [Delete] buttons to manage their User
 Defined formats in the default template

Feel free to submit this as a separate enhancement request.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 63536] Add Accounting format code to currency list

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=63536

--- Comment #1 from ign_christian ign_christ...@yahoo.com ---
Hi Phil, please explain the purpose of this report. What is the difference with
Bug 45780?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 63536] Add Accounting format code to currency list

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=63536

--- Comment #2 from PhilC2K pb...@cvox.us ---
A fair question.  The original bug report (Bug 45780) was to address a
fundamental technical deficiency that prevented the basic ability to even
create an accounting format, and the implied (though not explicitly stated)
addition of an Accounting format to the list of pre-defined number formats. 
That technical issue has now been solved but not the addition of the Accounting
format entry.  That is left to the user to 1) build the format, 2) create a new
template 3) make the new template the default.  Hardly an adopter friendly
process.  As I have bellowed from my soap-box before, we must make this work
for the adopters and leaving this other piece undone creates a barrier to them.

This bug report is an effort to drop the other shoe and bring that remaining
piece to the fore to be addressed. (And does not get lost in the completion
of the primary bug.)

It's not a very challenging fix unlike the technical underpinnings.  The
biggest issue would be what the formatting code should be (I would defer to a
professional accountant for that).  But I would amend my original suggestion to
correct the right-indent of the negative value:

[$$-409]* #,##0.00_);[RED][$$-409]* (#,##0.00)_);[$$-409]* -_)


Separately, I feel LO should add the ability of a user to define number formats
and then have [Add] and [Delete] buttons to manage their User Defined formats
in the default template

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs