Created attachment 32828 [details]
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();

    }
}