Description: When opening an existing Calc file with a line chart, the original major interval "Months" is changed to "Days". This changes the X-axis label and inserts additional grid lines: for each day. I have hundreds of old files with line charts. Steps to Reproduce: 1. With LO-Calc 7.2.5 or lower create a calc file with a line chart over one year and set the Major Interval to "Months". 2. Save the file 3. Open the same file with LO 7.3.0.1 or 7.3.0.2 Actual Results: When opening the same file with LO 7.3.0.1 or 7.3.0.2, the major interval is set to "Days" Expected Results: The major intervall should still be "Months" Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: Nothing
Created attachment 177605 [details] Change of Major Interval in Calc 7.3.0.2
Reproduced in: LO 7.2.5.2 - OKAY Version: 7.2.5.2 (x64) / LibreOffice Community Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5 CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: de-DE Calc: CL LO 7.3.0.2 - ERROR Version: 7.3.0.2 (x64) / LibreOffice Community Build ID: f1c9017ac60ecca268da7b1cf147b10e244b9b21 CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: de-DE Calc: CL
Created attachment 177617 [details] Change of Major Interval in Calc 7.3.0.2 Second version of ods-file
Regression introduced by: https://cgit.freedesktop.org/libreoffice/core/commit/?id=f547cf17a179ebd7de5c2b4dd2d00d0027a25429 author Dennis Francis <dennisfrancis.in@gmail.com> 2021-09-02 14:33:55 +0530 committer Miklos Vajna <vmiklos@collabora.com> 2021-09-06 08:47:50 +0200 commit f547cf17a179ebd7de5c2b4dd2d00d0027a25429 (patch) tree 764038da5e3280c93099d2ca3ef2731484ece324 parent ba1e42f05e785c30d03553acd5647eebd7cdede6 (diff) [API CHANGE] oox: fix import of chart date categories Bisected with: bibisect-linux64-7.3 Adding Cc: to Dennis Francis
Created attachment 180706 [details] Chart.ods
Created attachment 180707 [details] Chart - OKAY - LO 7.2.7.2.png
Created attachment 180708 [details] Chart - ERROR - LO 7.3.4.2 + 7.4.0.0.alpha1.png
LO 7.2 reached "End of Life". Can't use LO 7.3, because the problem (ASSIGNED + high major) is still not fixed (LO 7.3.4.2 + LO 7.4.0.0.alpha1). Attachments: Chart.ods, Chart - OKAY - LO 7.2.7.2.png, Chart - ERROR - LO 7.3.4.2 + 7.4.0.0.alpha1.png
I was able to understand the problem well with Jörn's example file. The major interval used to be months and is now days. It makes little sense that the minor interval (also days) is set the same as the major interval. Users of older files would have to switch off the automatic for the major interval and set it to months by hand. This is very cumbersome and not user-friendly.
Hello Jürgen, I'm sorry, I forgot to tell about Jörn's "X Axis" settings "Scale" and my "X Axis" settings "Scale" (Chart.ods) - there is a DIFFERENCE: Jörn: [Scale] Type "Date" Hans-Werner: [Scale] Type "Automatic" In my case LO is doing the wrong settings ! Greetings Hans-Werner