[Libreoffice-bugs] [Bug 138385] When I edit the x-axis in a chart and save the file as .xlsx, the edit is lost.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=138385

--- Comment #2 from SRS <stuart.soloway at ieee.org> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201121/e6bcd88a/attachment.htm>