Hello, this function when given a parameter of Short.parseShort("-90") produces a cell with rotation of -77 when I open it up in Excel.
what happens if you give it (short)-90?
(short)-90 produces the same result... also, depending on some of the types of formatting given to cells, the cells are not formattable in Excel. i.e. When you select a cell in Excel that was formatted by HSSF and select "Format cells", nothing happens...but cells that were not touched or created by HSSF in the sheet work fine for "Format cells".
Attached is a patch that will correct this. What it does is ensures that the HSSFCellStyle will only accept the -90 to 90 degrees for the setRotation and the getRotation will return the same (-90 to 90). In excel the 4th quadrant is stored as 91 to 180 for a rotation of -1 to -90. Odd eh?? Jason
Created attachment 2936 [details] The patch to the HSSFCellStyle. Forgot to mention it will throw an IllegalArgumentException for an invalid rotaion in the setRotation call
Jason can you also submit a patch noting you as a developer on the project. You should be recognized for your contributions. (this page: Patch applied. Please cross check.