Mailing-List: contact dev-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Developers List" <dev@poi.apache.org>
From: bugzilla@apache.org
To: dev@poi.apache.org
Subject: DO NOT REPLY [Bug 47206] New: XSSFSheet autSizeColumn not
 considering all rows
Message-ID: <bug-47206-47293@https.issues.apache.org/bugzilla/>
Auto-Submitted: auto-generated
Content-Type: text/plain; charset="UTF-8"
MIME-Version: 1.0
Date: Sat, 16 May 2009 08:24:00 -0700 (PDT)

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: dev@poi.apache.org
        ReportedBy: robstewart57@googlemail.com


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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org