DO NOT REPLY [Bug 24125] - Currency formated cells are recognized as dates.

[bu...@apache.org]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=24125>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=24125

Currency formated cells are recognized as dates.





------- Additional Comments From christopher.cope@logicacmg.com  2003-12-04 11:38 -------
Also appears to be a problem with percentage formats in Excel 2002 
(10.2614.3311 to be precise):

Percentage formats are as follows (according to number of decimal places):

0 = 9 (09)
1 = 164 (a4)
2 = 10 (0a)
3 = 167 (a7)
4 = 168 (a8)
5 = 169 (a9)
6 = 170 (aa)
7 = 171 (ab)
8 = 176 (b0)
9 = 177 (b1)
10 = 172 (ac)
11 = 173 (ad)
12 = 180 (b4)
13 = 181 (b5)
14 = 182 (b6)
15 = 178 (b2)
16 = 183 (b7)
17 = 184 (b8)
18 = 185 (b9)
19 = 186 (ba)
20 = 174 (ae)
21 = 187 (bb)
22 = 188 (bc)
23 = 189 (bd)
24 = 190 (be)
25 = 179 (b3)
26 = 191 (bf)
27 = 192 (c0)
28 = 193 (c1)
29 = 194 (c2)
30 = 175 (af)


The switch statement in isInternalDateFormat(int format) (from HSSFDateUtil rev 
1.6) contains the following:

// Additional internal date formats found by inspection
// Using Excel v.X 10.1.0 (Mac)
case 0xa4:
case 0xa5:
case 0xa6:
case 0xa7:
case 0xa8:
case 0xa9:
case 0xaa:
case 0xab:
case 0xac:
case 0xad:

So with Excel 2002 percentage formats with 1, 3, 4, 5, 6, 7, 10 and 11 decimal 
points appear to get treated as dates.

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