Chart.CategoryAxis.TickLabels.RotationAngle is opposite in Excel

Strange behavior setting the alignment of axis labels with Aspose.Cells 6.0.0.0

chart.CategoryAxis.TickLabels.RotationAngle = -45

results in an Excel sheet with properties showing a rotation of +45 degrees on axis labels. The effect is the same as setting a +45 value in Excel directly. Text begins at top left and slants to bottom right.

chart.CategoryAxis.TickLabels.RotationAngle = 45

results in -45 in Excel. Text from bottom left to top right.

Jeff

Hi Jeff,


After an initial test, I am able to find the issue as you have mentioned. I have logged a ticket for your issue with an id: CELLSNET-28777. We will fix it soon.

Thank you.

Hi,

It must be different behavior of MS Excel 2003 and MS Excel 2007.

The rotation is clockwise in MS excel 2003, but it’s counter clockwise in MS Excel 2007.

Now Aspose.Cells works as MS Excel 2003.

Please check which direction to cycle the tick labels.