https://issues.apache.org/bugzilla/show_bug.cgi?id=50681

[email protected] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Version|3.7                         |3.8-dev
            Summary|autoSizeColumn sets column  |autoSizeColumn sets column
                   |width beyond 255 character  |width beyond 255 character
                   |limit for XSSF sheets       |limit for XSSF sheets and
                   |                            |HSSF Sheets

--- Comment #3 from [email protected] 2011-06-15 20:44:06 UTC ---
I have tested the above code in 3.8 beta 3 and it failed.

There is also a regression for HSSF Sheets.

The following code works in POI 3.7, but fails in POI 3.8 beta3.

package org.apache.poi.ss.examples;
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.xssf.usermodel.*;

import java.io.*;

public class AutoSizeTest {

    public static void main(String args[]) {
        HSSFWorkbook workbook = new HSSFWorkbook();
        HSSFSheet    sheet = workbook.createSheet("Sheet1");
        HSSFRow      row = sheet.createRow(0);
        HSSFCell     cell0 = row.createCell(0);

        String longValue = "www.hostname.com, www.hostname.com, " +
                "www.hostname.com, www.hostname.com, www.hostname.com, " +
                "www.hostname.com, www.hostname.com, www.hostname.com, " +
                "www.hostname.com, www.hostname.com, www.hostname.com, " +
                "www.hostname.com, www.hostname.com, www.hostname.com, " +
                "www.hostname.com, www.hostname.com, www.hostname.com,
www.hostname.com";

        cell0.setCellValue(longValue);

        sheet.autoSizeColumn(0);
        sheet.setColumnWidth(0, sheet.getColumnWidth(0)); // FAILS HERE

        try {
            FileOutputStream out = new
FileOutputStream("C:/workspace/working.xls");
            workbook.write(out);
            out.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    } // main
}

-- 
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]

Reply via email to