poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 60396] setWrapText not working for SXSSFWorkbook
Date Mon, 21 Nov 2016 23:54:58 GMT
https://bz.apache.org/bugzilla/show_bug.cgi?id=60396

Marc <marc@schregardus.com.au> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |NEW

--- Comment #2 from Marc <marc@schregardus.com.au> ---
In my production code, the styles are cached and I still get the same issue. To
demonstrate, I've amended the code below to create the style outside the loop
(so only 1 style is created), and there is still the problem with wrapping for
the streamed version of the renderer.

        SXSSFWorkbook wb = new SXSSFWorkbook(100); 
//        XSSFWorkbook wb = new XSSFWorkbook(); 

        CellStyle cellStyle = wb.createCellStyle();
        cellStyle.setWrapText(true);

        Sheet sh = wb.createSheet();
        for(int rownum = 0; rownum < 1000; rownum++){
            Row row = sh.createRow(rownum);
            for(int cellnum = 0; cellnum < 10; cellnum++) {

                Cell cell = row.createCell(cellnum);
                String address = new CellReference(cell).formatAsString();
                address += "\ntest";

                row.setHeightInPoints((2*sh.getDefaultRowHeightInPoints()));

                cell.setCellStyle(cellStyle);
                cell.setCellValue(address);                
            }
        }

If you switch to the XSSFWorkbook (commented out), then the spreadsheet is
rendered correctly

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


Mime
View raw message