You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on Nov 24, 2020. It is now read-only.
When using ICellStyle.Rotation to rotate a column header 90 degrees it works fine but setting it to -90 sets it to zero. The documentation states it can be set between -90 and 90. I also tried -89 and 270 to see what happened but they both set to 0 as well.
Sample code:
Dim vertStyle As ICellStyle = workbook.CreateCellStyle()
vertStyle.Rotation = -90
cell = row.CreateCell(0)
cell.SetCellValue("Employment")
cell.CellStyle = vertStyle
With Rotation set to -90 degrees it appears like this (note: this is in LibreOffice but it looks the same in Excel):
With Rotation set to 90 degrees it appears like this (appears to be working correctly):
The text was updated successfully, but these errors were encountered:
Sign up for freeto subscribe to this conversation on GitHub.
Already have an account?
Sign in.
When using ICellStyle.Rotation to rotate a column header 90 degrees it works fine but setting it to -90 sets it to zero. The documentation states it can be set between -90 and 90. I also tried -89 and 270 to see what happened but they both set to 0 as well.
Sample code:
With Rotation set to -90 degrees it appears like this (note: this is in LibreOffice but it looks the same in Excel):
With Rotation set to 90 degrees it appears like this (appears to be working correctly):
The text was updated successfully, but these errors were encountered: