Ask Your Question
0

Chart in Calc does not update after being saved

asked 2016-08-24 09:50:26 +0100

Zabusy gravatar image

updated 2016-08-24 10:27:20 +0100

My issue: One of my colleagues is working on a chart in libre Calc. Basically, data on the X side should be in 90° position, but they're always in 45°. The chart is in Calc and is required to be in .xlsx format, as it will be later used in Microsoft office by another colleague. However, when I change the X to 90°, click off the chart to save it in xlsx(as having the chart selected will only give me the option to save it as .odc), close the file and open it again the X returns to 45°.

I've tried to look up for multiple suggestions but so far I have not found a solution. Forcing Shift + Ctrl + F9 or automatic saving on/off does not help.

FYI, the data in the file is connected to other files. I don't think it's the reason why it moves back to 45° but just putting it here in case if it's related.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-08-24 16:41:18 +0100

mark_t gravatar image

Are you able to save in xls format instead of xlsx? This seems to work around the axis label rotation issue, but not sure if it works ok for connections to other files.

In general LibreOffice compatibility with Excel is better in xls files than with xlsx.

edit flag offensive delete link more

Comments

Yes,thank you. That fixed the issue I was having.

Zabusy gravatar imageZabusy ( 2016-08-26 11:27:03 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-08-24 09:50:26 +0100

Seen: 71 times

Last updated: Aug 24 '16