OOo/LibreOffice Calc BASIC: cell display orientation/rotation
Posted 05-18-2012 at 01:45 AM by catkin
There are incorrect examples on the internet of using OOo/LibreOffice BASIC to set Calc cell contents to display vertically, the same as can be done interactively via Format Cell -> Alignment -> Text Orientation and setting the angle to 90 degrees.
The problem is that they show 90 but the units are 1/100ths of a degree so vertical requires 9000.
This works
This does not work (it is here to help people searching for this string when they use it and it does not have the intended effect)
The problem is that they show 90 but the units are 1/100ths of a degree so vertical requires 9000.
This works
Code:
oCell.setPropertyValue( "RotateAngle", 9000 )
Code:
oCell.setPropertyValue( "RotateAngle", 90 )
Total Comments 0