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. Summary: Currency formated cells are recognized as dates. Product: POI Version: 1.5.1 Platform: Other OS/Version: Other Status: NEW Severity: Normal Priority: Other Component: HSSF AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] Hello! Cells in Excel 2000 (German) formated as Currency are recognized as dates. In Excel they look like "7,00€" and "$7,00". style.getDataFormat() returns 171 (ab) and 172 (ac) for these cells so isInternalDateFormat(..) returns true. Is it possible to determin with HSSF how the cells look like in Excel? Greetings from Germany Holger P.S. Here are the fields for HSSFCell and HSSFCell.getCellStyle() of cell "$7,00". Hope this information helps debugging: ---- HSSFCell ------ org.apache.poi.hssf.usermodel.HSSFCell [java.lang.Object] cellNum = 1 cellType = 0 cellStyle :- [EMAIL PROTECTED] cellValue = 7.0 stringValue :- null booleanValue = false errorValue = 0 encoding = 0 book :- [EMAIL PROTECTED] sheet :- [EMAIL PROTECTED] row = 2 record :- [NUMBER] .row = 2 .col = 1 .xfindex = 1f .value = 7.0 [/NUMBER] ---- HSSFCell.getCellStyle() ------ org.apache.poi.hssf.usermodel.HSSFCellStyle [java.lang.Object] format :- [EXTENDEDFORMAT] CELL_RECORD_TYPE .fontindex = 0 .formatindex = ac .celloptions = 1 .islocked = true .ishidden = false .recordtype= 0 .parentidx = 0 .alignmentoptions= 20 .alignment = 0 .wraptext = false .valignment= 2 .justlast = 0 .rotation = 0 .indentionoptions= 400 .indent = 0 .shrinktoft= false .mergecells= false .readngordr= 0 .formatflag= true .fontflag = false .prntalgnmt= false .borderflag= false .paternflag= false .celloption= false .borderoptns = 0 .lftln = 0 .rgtln = 0 .topln = 0 .btmln = 0 .paleteoptns = 0 .leftborder= 0 .rghtborder= 0 .diag = 0 .paleteoptn2 = 0 .topborder = 0 .botmborder= 0 .adtldiag = 0 .diaglnstyl= 0 .fillpattrn= 0 .fillpaloptn = 20c0 .foreground= 40 .background= 41 [/EXTENDEDFORMAT] index = 31 fontindex = 0 ----- style.getDataFormat() ----- style.getDataFormat(): 172 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
