Created attachment 25660 [details] screen shot in excel, there's an option to let text go vertically (Format->Cell->Alignment->Orientation), ie: T E X T this option is especially helpful for Asian Text. The setRotation() method in HSSFCellStyle does NOT quite do the trick. it would be nice if future POI HSSF can include a method to set text vertically.
Could you please upload two simple files, created in excel? One is a file with one sheet, one row. Two cells, both with the same text in them, and both in the normal direction Then, save-as that file, rotate the text in one cell but not the other, and save that. If you could upload those two files, we'll have something to work off to spot how excel does it, and something to unit test against
Created attachment 25772 [details] normal text One is a file with one sheet, one row. Two cells, both with the same text in them, and both in the normal direction
Created attachment 25773 [details] rotated text (vertical) Then, save-as that file, rotate the text in one cell but not the other, and save that.
information added. 2 excel files as attachments. thanks alot for the response.
Thanks for the test files, they showed the trick Now fixed in r965267. You can now do cellStyle.setRotation(0xff) to request vertically orientated text