Bug 54396 - HSSFSheet autoSizeColumn() not correctly sizing Date cells
Summary: HSSFSheet autoSizeColumn() not correctly sizing Date cells
Status: RESOLVED INVALID
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.9-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-01-09 22:22 UTC by tomm
Modified: 2013-01-09 22:39 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 tomm 2013-01-09 22:22:03 UTC 
It seems to be autoSizing the column as if it is a numeric value (which Dates are stored as in Excel aren't they?) because it is sized fine if you format the column as a number, however if the Date is formatted as MM/DD/YYYY, the size of the column is slightly smaller than necessary resulting in ###### instead of the date.  Is there any way to prevent this and have the column sized taking into account the date format?