Description: I edit the x-axis in a graph to change the major interval from "automatic" to 7-days. When I save and re-open, the edit is lost. The file has two sheets and the data is on a different sheet from the graph. Steps to Reproduce: 1.Open the attached xlsx file 2.Open the chart on the first sheet. 3.Double-click on the chart to edit it. 4.Hover over the x-axis, right-click, and click on "format x-axis". 5.On the "Scale" tab unclick "automatic" for major interval. 6.Change the settings for major interval to be 7 days, not 1 month. 7.Save the file. 8.Open the file that was saved. Actual Results: The format changes are lost when the file is re-opened! Expected Results: The format changes should have been kept. Reproducible: Always User Profile Reset: No Additional Info: Don't know if OpenGl is enabled. It was a default installation. I am using a Windows7 machine and am running 7.1.0.0 Alpha 1, 64-bit. At least I think that's what I'm running. When I look at help/about, it says 7.0.3.1. The build id is d7547858d014d4cf69878db179d326fc3483e082. Version: 7.0.3.1 (x64) Build ID: d7547858d014d4cf69878db179d326fc3483e082 CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
Created attachment 167438 [details] This is the file where the problem happens
After I have saved and reloaded the file, I can fix the x-axis format by expanding the width of the chart. So I think what is happening is this: 1) When I edit the x-axis major interval the first time, LO Calc is happy to update the chart as directed; it doesn't think the dates are too close. 2) When I save it and reopen it, LO Calc decides that dates on the x-axis are too close together to be displayed properly, so it reverts to the "automatic" setting for the major interval. It seems to use different standards for how close x-axis labels can be when the file is opened as opposed to when you initially set up the x-axis labels. Something else I should point out: When the x-axis is displaying incorrectly, the major interval has been reset by LO Calc to "automatic". BUT if I expand the chart so that the x-axis displays the way I want, then the major interval setting magically goes back to what I set it as, which was 7 days. LO Calc seems to have some hidden state that is very confusing. I should point out that if I create a chart that is too small to accommodate the x-axis labels at my desired frequency, it normally just uses some multiple of what I have set as the major interval. And it doesn't change my configuration setting.
This was fixed recently and should work in current nightly versions: https://dev-builds.libreoffice.org/daily/master/current.html *** This bug has been marked as a duplicate of bug 137917 ***