https://issues.apache.org/bugzilla/show_bug.cgi?id=45105
Summary: Column width not correctly mapped to xls file (office
2003), while defaultColumnWidth is
Product: POI
Version: 3.0-dev
Platform: PC
OS/Version: Windows Vista
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
I would like confirmation that this is not a problem due to my local excel
setup-
When I generate a blank workbook and look inside, the columns are all 64 pixels
wide - this corresponds to the defaultColumnWidth value in a HSSFSheet.
A call to getColumnWidth((short)1) results in 2048, which is as expected
(2048/32 = 64)
If, however, I do "setColumnWidth((short)1, (short)2048)", this results in
column(1) being 56 pixels wide.
I tested a few widths, and each time, the pixel width in the spreadsheet is =
(width/32) * 7/8 (an eighth goes missing!)
So:
setColumnWidth(1,2048) -> Column is 56 pixels (expected 64)
setColumnWidth(1, 4096) -> Column is 112 pixels (expected 128)
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
