Calc plot axis format is not saved

asked 2015-05-21 07:35:22 +0200

Paul34utter gravatar image

updated 2015-08-26 21:46:36 +0200

Alex Kemp gravatar image

LibreOffice version 4.4.3.2 (but same behavior in earlier releases) Windows 7

I have several XY plots in LibreOffice Calc spreadsheets. I set a particular format for the numbers on the using edit > format axis. But after saving the file and closing it, the numeric format has switched back to Source Format. How can I make it stay with the format I set? Also, lately the y-axis label sometimes switches to 0 degree rotation rather than the 90 degree rotation (text parallel to the axis), which is how it was created and saved. I have the data on one tab (sheet), the plot on another tab (sheet). The spreadsheet is saved in Excel format, either .xls or .xlsx (both Excel formats have the same behavior.)

edit retag flag offensive close merge delete

Comments

What happens if you save in ods-format?

ROSt52 gravatar imageROSt52 ( 2015-05-22 05:28:20 +0200 )edit