<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - When I edit the x-axis in a chart and save the file as .xlsx, the edit is lost."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138385#c2">Comment # 2</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - When I edit the x-axis in a chart and save the file as .xlsx, the edit is lost."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138385">bug 138385</a>
from <span class="vcard"><a class="email" href="mailto:stuart.soloway@ieee.org" title="SRS <stuart.soloway@ieee.org>"> <span class="fn">SRS</span></a>
</span></b>
<pre>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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>