Bug 41730 - problem when reading dates
Summary: problem when reading dates
Status: RESOLVED INVALID
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: unspecified
Hardware: All Windows XP
: P4 major (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-02-28 08:04 UTC by Vladimir Ganev
Modified: 2007-03-01 09:26 UTC (History)
0 users


Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Vladimir Ganev 2007-02-28 08:04:53 UTC 
I try to read cells formated as dates, but the internal date codes (listed
below) do not cover all cases.
0x0e
0x0f
0x10
0x11
0x12
0x13
0x14
0x15
0x16
0x2d
0x2e
0x2f

So, does anybody has a solution about this problem?
I also could not find any Internal Date Formats in Microsoft Excel Dev's Kit as
mentioned in HSSFDateUtil.java (Internal Date Formats as described on page 427
in Microsoft Excel Dev's Kit...)
Comment 1 Andy Oliver 2007-02-28 09:47:31 UTC 
Bugzilla is not a valid question to ask usage questions.  That you do not know
how to do something does not constitute a major bug in POI.
Comment 2 Vladimir Ganev 2007-02-28 23:50:46 UTC 
POI is not able to read most of the date formats.
Isn't it a bug?
Comment 3 Andy Oliver 2007-03-01 09:26:26 UTC 
the bug is that you haven't asked HOW on the list.