after editing the x-axis in calc charts, they revert back to pre-edit state. how can I keep the edited format?

asked 2019-03-24 01:54:44 +0100

bof gravatar image

updated 2019-03-24 01:55:54 +0100

New user of LibreOffice, using charts produced in Excel over several years. I get monthly spacing on my x-axis, but want weekly spacing. I edit the axis format, and the spacing shows as weekly. Then press OK, and click outside the chart, and it goes back to monthly spacing! I could do this OK in Excel, but dont have that anymore. Help please.

edit retag flag offensive close merge delete


I cannot confirm this. What's your version of LibO? (Your OS?)
In what way (exactly) did you format the axis?
Were all your charts converted from Excel documents? Did you try it also with a newly created chart?
Charts are very complex, and surely there is no exact mapping of properties accross different applications.
Best upload an example file.

Lupp gravatar imageLupp ( 2019-03-24 02:24:33 +0100 )edit

Just my own oberservation - a similiar behavior is seen on diagrams originally created with LibreOffice (and not converted from Excel). I need to close the file (or a do a "save / reload") to make visible changes in the scaling of axis in almost all cases.

My current config is:

Version: Build-ID: 2b840030fec2aae0fd2658d8d4f9548af4e3518d CPU-Threads: 8; BS: Linux 4.12; UI-Render: Standard; VCL: kde5; Gebietsschema: de-DE (de_DE.UTF-8); UI-Sprache: de-DE Calc: threaded Distrubution: OpenSUSE Leap 15.0 but using LO native (not the version of the distribution)

but I observed this for a long time (meaning "many previous releases") and somehow got used to the issue and worked around.

Opaque gravatar imageOpaque ( 2019-03-24 10:53:13 +0100 )edit

Is this problem peculiar to graduating the x-axis in weeks/months? A calendar variable? I have never had the problem described, but my x-axes are always just a pure number (voltage, frequency, time in hours, etc) and not converted from Excel.

ve3oat gravatar imageve3oat ( 2019-03-24 15:08:49 +0100 )edit

I have version, running on Windows 10 Home. I've used the dates for x-axis format since about 2009, on Excel, to give me values per week, on several different charts. Would like to be able to continue these graphs in the future. All suggestions welcomed.

bof gravatar imagebof ( 2019-03-24 18:30:28 +0100 )edit

Forgot to say, all my spreadsheets and integrated graphs are currently loaded from my Excel backups, have not yet tried creating new ones in LO.

bof gravatar imagebof ( 2019-03-24 18:35:01 +0100 )edit

"have not yet tried creating new ones in LO"

As @Lupp suggested, it would be informative to try that. It could help to better define the problem.

ve3oat gravatar imageve3oat ( 2019-03-25 15:48:43 +0100 )edit