View | Details | Raw Unified | Return to bug 55730
Collapse All | Expand All

(-)a/src/java/org/apache/poi/ss/usermodel/BuiltinFormats.java (-6 / +7 lines)
Lines 54-63 import java.util.Map; Link Here
54
 *       0x26, "#,##0_);[Red](#,##0)"<br/>
54
 *       0x26, "#,##0_);[Red](#,##0)"<br/>
55
 *       0x27, "#,##0.00_);(#,##0.00)"<br/>
55
 *       0x27, "#,##0.00_);(#,##0.00)"<br/>
56
 *       0x28, "#,##0.00_);[Red](#,##0.00)"<br/>
56
 *       0x28, "#,##0.00_);[Red](#,##0.00)"<br/>
57
 *       0x29, "_(*#,##0_);_(*(#,##0);_(* \"-\"_);_(@_)"<br/>
57
 *       0x29, "_(* #,##0_);_(* (#,##0);_(* \"-\"_);_(@_)"<br/>
58
 *       0x2a, "_($*#,##0_);_($*(#,##0);_($* \"-\"_);_(@_)"<br/>
58
 *       0x2a, "_($* #,##0_);_($* (#,##0);_($* \"-\"_);_(@_)"<br/>
59
 *       0x2b, "_(*#,##0.00_);_(*(#,##0.00);_(*\"-\"??_);_(@_)"<br/>
59
 *       0x2b, "_(* #,##0.00_);_(* (#,##0.00);_(* \"-\"??_);_(@_)"<br/>
60
 *       0x2c, "_($*#,##0.00_);_($*(#,##0.00);_($*\"-\"??_);_(@_)"<br/>
60
 *       0x2c, "_($* #,##0.00_);_($* (#,##0.00);_($* \"-\"??_);_(@_)"<br/>
61
 *       0x2d, "mm:ss"<br/>
61
 *       0x2d, "mm:ss"<br/>
62
 *       0x2e, "[h]:mm:ss"<br/>
62
 *       0x2e, "[h]:mm:ss"<br/>
63
 *       0x2f, "mm:ss.0"<br/>
63
 *       0x2f, "mm:ss.0"<br/>
Lines 69-74 import java.util.Map; Link Here
69
 * @author Yegor Kozlov
69
 * @author Yegor Kozlov
70
 *
70
 *
71
 * Modified 6/17/09 by Stanislav Shor - positive formats don't need starting '('
71
 * Modified 6/17/09 by Stanislav Shor - positive formats don't need starting '('
72
 * Modified 10/31/13 by Eric Peters - * is a repeating/padding character directive, examples needed a space after the asterix (e.i. Accounting format)
72
 *
73
 *
73
 */
74
 */
74
public final class BuiltinFormats {
75
public final class BuiltinFormats {
Lines 137-144 public final class BuiltinFormats { Link Here
137
		putFormat(m, 0x28, "#,##0.00_);[Red](#,##0.00)");
138
		putFormat(m, 0x28, "#,##0.00_);[Red](#,##0.00)");
138
		putFormat(m, 0x29, "_(\"$\"* #,##0_);_(\"$\"* (#,##0);_(\"$\"* \"-\"_);_(@_)");
139
		putFormat(m, 0x29, "_(\"$\"* #,##0_);_(\"$\"* (#,##0);_(\"$\"* \"-\"_);_(@_)");
139
		putFormat(m, 0x2a, "_(* #,##0_);_(* (#,##0);_(* \"-\"_);_(@_)");
140
		putFormat(m, 0x2a, "_(* #,##0_);_(* (#,##0);_(* \"-\"_);_(@_)");
140
		putFormat(m, 0x2b, "_(\"$\"* #,##0.00_);_(\"$\"* (#,##0.00);_(\"$\"* \"-\"??_);_(@_)");
141
		putFormat(m, 0x2b, "_(* #,##0.00_);_(* (#,##0.00);_(* \"-\"??_);_(@_)");
141
		putFormat(m, 0x2c, "_(* #,##0.00_);_(* (#,##0.00);_(* \"-\"??_);_(@_)");
142
		putFormat(m, 0x2c, "_(\"$\"* #,##0.00_);_(\"$\"* (#,##0.00);_(\"$\"* \"-\"??_);_(@_)");
142
		putFormat(m, 0x2d, "mm:ss");
143
		putFormat(m, 0x2d, "mm:ss");
143
		putFormat(m, 0x2e, "[h]:mm:ss");
144
		putFormat(m, 0x2e, "[h]:mm:ss");
144
		putFormat(m, 0x2f, "mm:ss.0");
145
		putFormat(m, 0x2f, "mm:ss.0");
(-)a/src/testcases/org/apache/poi/hssf/eventusermodel/TestFormatTrackingHSSFListener.java (-2 / +2 lines)
Lines 57-63 public final class TestFormatTrackingHSSFListener extends TestCase { Link Here
57
57
58
		assertEquals("_(\"$\"* #,##0_);_(\"$\"* (#,##0);_(\"$\"* \"-\"_);_(@_)", listener.getFormatString(41));
58
		assertEquals("_(\"$\"* #,##0_);_(\"$\"* (#,##0);_(\"$\"* \"-\"_);_(@_)", listener.getFormatString(41));
59
		assertEquals("_(* #,##0_);_(* (#,##0);_(* \"-\"_);_(@_)", listener.getFormatString(42));
59
		assertEquals("_(* #,##0_);_(* (#,##0);_(* \"-\"_);_(@_)", listener.getFormatString(42));
60
		assertEquals("_(\"$\"* #,##0.00_);_(\"$\"* (#,##0.00);_(\"$\"* \"-\"??_);_(@_)", listener.getFormatString(43));
60
		assertEquals("_(* #,##0.00_);_(* (#,##0.00);_(* \"-\"??_);_(@_)", listener.getFormatString(43));
61
		assertEquals("_(\"$\"* #,##0.00_);_(\"$\"* (#,##0.00);_(\"$\"* \"-\"??_);_(@_)", listener.getFormatString(44));
61
	}
62
	}
62
	
63
	
63
	/**
64
	/**
64
- 

Return to bug 55730