DO NOT REPLY [Bug 41478] HSSFDataFormat builtin values are wrong

[bu...@apache.org]

https://issues.apache.org/bugzilla/show_bug.cgi?id=41478





--- Comment #1 from Dmitriy Kumshayev <dq...@mail.com>  2009-01-21 21:43:22 PST ---
Created an attachment (id=23155)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23155)
Please apply the proposed patch 

Positive numbers should not be in parenthesis
the should all start with "_(" 

 *       5, "_($#,##0_);($#,##0)"<br>
 *       6, "_($#,##0_);[Red]($#,##0)"<br>
 *       7, "_($#,##0.00);($#,##0.00)"<br>
 *       8, "_($#,##0.00_);[Red]($#,##0.00)"<br>
 *       0x25, "_(#,##0_);(#,##0)"<P>
 *       0x26, "_(#,##0_);[Red](#,##0)"<P>
 *       0x27, "_(#,##0.00_);(#,##0.00)"<P>
 *       0x28, "_(#,##0.00_);[Red](#,##0.00)"<P>

This is from MS Excel Help:

To create a space that is the width of a character in a number format, include
an underscore, followed by the character. For example, when you follow an
underscore with a right parenthesis, such as _), positive numbers line up
correctly with negative numbers that are enclosed in parentheses.


-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org