poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 58043] New: POI will not allow negative rotation of text using XSSF but does work for HSSF
Date Tue, 16 Jun 2015 19:46:15 GMT
https://bz.apache.org/bugzilla/show_bug.cgi?id=58043

            Bug ID: 58043
           Summary: POI will not allow negative rotation of text using
                    XSSF but does work for HSSF
           Product: POI
           Version: 3.12-FINAL
          Hardware: PC
            Status: NEW
          Severity: major
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: mwilber@utilinc.com

Created attachment 32828
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=32828&action=edit
Demonstrates inability to rotate text -90 degrees using XSSF

I need to rotate text within a cell by -90 degrees.  This feature works for a
HSSF xls spreadsheet with POI.  But it does not work for a XSSF xlsx
spreadsheet with POI.  The text remains at 0 degrees rotation.

Attached is sample code that demonstrates the successful rotation using HSSF
and the unsuccessful rotation using XSSF.

Please correct this.

Marty


import java.io.FileOutputStream;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class TestExcel
{

    private void createXls()
    {
        try
        {

            Workbook workbook = new HSSFWorkbook();
            FileOutputStream fileOut = new FileOutputStream("c:/rotated.xls");
            Sheet sheet1 = workbook.createSheet();
            Row row1 = sheet1.createRow((short) 0);

            Cell cell1 = row1.createCell(0);

            cell1.setCellValue("Successful rotated text.");

            CellStyle style = workbook.createCellStyle();
            style.setRotation((short) -90);

            cell1.setCellStyle(style);

            workbook.write(fileOut);
            fileOut.close();
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }

    }

    private void createXlsx()
    {
        try
        {

            Workbook workbook = new XSSFWorkbook();
            FileOutputStream fileOut = new FileOutputStream("c:/rotated.xlsx");
            Sheet sheet1 = workbook.createSheet();
            Row row1 = sheet1.createRow((short) 0);

            Cell cell1 = row1.createCell(0);

            cell1.setCellValue("Unsuccessful rotated text.");

            CellStyle style = workbook.createCellStyle();
            style.setRotation((short) -90);

            cell1.setCellStyle(style);

            workbook.write(fileOut);
            fileOut.close();
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }

    }

    public static void main(String[] args) throws Exception
    {

        TestExcel testExcel = new TestExcel();

        testExcel.createXls();
        testExcel.createXlsx();

    }
}

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