Bug 146826 - Calc 7.3.0.2: Chart Type "Line": Interval Major is changed from "Months" to "Days" upon FILEOPEN
Summary: Calc 7.3.0.2: Chart Type "Line": Interval Major is changed from "Months" to "...
Status: ASSIGNED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.0.1 rc
Hardware: All All
: high major
Assignee: Dennis Francis
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
Depends on:
Blocks: Chart
  Show dependency treegraph
 
Reported: 2022-01-17 14:02 UTC by Jörn Schwarz
Modified: 2022-06-13 19:20 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
Change of Major Interval in Calc 7.3.0.2 (36.78 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-01-17 14:04 UTC, Jörn Schwarz
Details
Change of Major Interval in Calc 7.3.0.2 (67.41 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-01-17 16:43 UTC, Jörn Schwarz
Details
Chart.ods (269.28 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-06-13 06:59 UTC, Hans-Werner
Details
Chart - OKAY - LO 7.2.7.2.png (5.97 KB, image/png)
2022-06-13 06:59 UTC, Hans-Werner
Details
Chart - ERROR - LO 7.3.4.2 + 7.4.0.0.alpha1.png (5.96 KB, image/png)
2022-06-13 07:00 UTC, Hans-Werner
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jörn Schwarz 2022-01-17 14:02:20 UTC
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
Comment 1 Jörn Schwarz 2022-01-17 14:04:57 UTC
Created attachment 177605 [details]
Change of Major Interval in Calc 7.3.0.2
Comment 2 Hans-Werner 2022-01-17 16:22:20 UTC
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
Comment 3 Jörn Schwarz 2022-01-17 16:43:59 UTC
Created attachment 177617 [details]
Change of Major Interval in Calc 7.3.0.2

Second version of ods-file
Comment 4 Xisco Faulí 2022-01-17 19:11:57 UTC
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
Comment 5 Hans-Werner 2022-06-13 06:59:17 UTC
Created attachment 180706 [details]
Chart.ods
Comment 6 Hans-Werner 2022-06-13 06:59:51 UTC
Created attachment 180707 [details]
Chart - OKAY - LO 7.2.7.2.png
Comment 7 Hans-Werner 2022-06-13 07:00:22 UTC
Created attachment 180708 [details]
Chart - ERROR - LO 7.3.4.2 + 7.4.0.0.alpha1.png
Comment 8 Hans-Werner 2022-06-13 07:06:31 UTC
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
Comment 9 Jürgen Kirsten 2022-06-13 17:53:04 UTC
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.
Comment 10 Hans-Werner 2022-06-13 19:20:53 UTC
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