https://issues.apache.org/bugzilla/show_bug.cgi?id=47206
Summary: XSSFSheet autSizeColumn not considering all rows
Product: POI
Version: 3.5-dev
Platform: PC
OS/Version: Windows Vista
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Created an attachment (id=23670)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=23670)
Zip file with 3 attachments
Hi there, I am experiencing some strange behaviour with the method
XSFFSheet.autoSizeColumn(i)
I have taken a spreadsheet with two rows. I have made two cells on the 2nd row
contain more text than the cell directly above that, on row one.
I saved the spreadsheet, one as Office 2003 format: 2003_Report.xls , and the
other as 2007 format: 2007_Report.xlsx
I attach a small Java program (Main.java attached). The intention is to adjust
the column widths on both sheets, so that all columns are correctly adjusted to
show all text as visible.
The application adjusts the 2003 (.xls) file just fine, but the 2007 (.xlsx)
file does not show all the text in the 2nd row.
Note this is a really simple example that I am using to illustrate a problem
I'm experiencing with poi-dev3.5. I am dealing with spreadsheets with 100's of
rows. Dealing with both xlsx and xls files, and the implementation of
XSFFSheet.autoSizeColumn(i) does not deal with column widths very well.
ATTACHMENTS:
- autoSizeColumn.zip
- - 2003_Report.xls
- - 2007_Report.xlsx
- - Main.java
Thanks.
--
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]
