Created attachment 10395 [details]
excel file demonstrating the error

i have attached an excel file demonstrating the error.

Hi Daniel,

one for you I think.

Frank

I will look at this

Yes, the X axis label format appears quite different. There is a
simple workaround that will fix this. In the X axis Label properties,
turn off the Text Flow->break and Set the rotation to 90 degrees. I
will investigate further to see why we are interpreting the Excel X
axis label automatic orientation like this. One final minor point,
there is no data beyond row 1450 for column A (categories) and column
C (values), yet the data series has references to row 1498. Calc will
default to using the using the Row number as the axis label in the
case where no cell data is present.

This Excel document stores the category axis (x) rotation angle as 45
yet Excel successfully interprets this as 90 with a text orientation
of 90 Counter ClockWise(90CCW) direction. If you re-save this in Excel
it corrects this data to this actual interpretation. This implies that
this document was incorrectly saved by Excel at some earlier stage. I
presume the interpretation happens because the AutoRotationMode is set
and thus the only correct rotation angles are 0, 90 and 180. Calc as
yet does not support the AutoRotationMode and thus uses the incorrect
rotation angle and text orientation. But resaving this document in
Excel successfully fixes this problem.

This then leaves the final workaround of the text flow->break. Here
Calc sets this flag if the "number of categories between the tick
marks" is equal to 1. This works well for other documents and thus the
workaround here is to manually reset this value.

I would like to propose this we close this as 'worksforme'.

closing as 'worksforme'

mark closed