poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 24125] New: - Currency formated cells are recognized as dates.
Date Sun, 26 Oct 2003 02:20:04 GMT
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: poi-dev@jakarta.apache.org
        ReportedBy: Holger.Schulz@epost.de


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 :- org.apache.poi.hssf.usermodel.HSSFCellStyle@ae525c
cellValue = 7.0
stringValue :- null
booleanValue = false
errorValue = 0
encoding = 0
book :- org.apache.poi.hssf.model.Workbook@15f5985
sheet :- org.apache.poi.hssf.model.Sheet@ee568c
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: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org


Mime
View raw message