Bug 63536

Hi Phil, please explain the purpose of this report. What is the difference with Bug 45780?

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

(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.