Created attachment 117222 [details]
Open the report "report_gender_chart" for editing and execute it.
Open the attached database.
Execute the report "report_gender_chart".
Since LO 4.3 it shows DATE-formatted values at x-axis.
Now open the report for editing.
Preview shows the right values for x-axis.
Close the report and execute the report "report_gender_chart_new".
Shows the right values in x-axis of the chart.
Difference between the queries for the charts is:
"report_gender_chart" has numbers in the x-axis, which seem to be sometimes decimal numbers with one decimalpoint like '20.0' or '50.0'. This decimalpoint isn't shown in query, but appers when changing the numbers to text-format.
"report_gender_chart_new" has text-formatted values for the x-axis.
Could be this buggy behavior could reproduced only with language-settings, where date is formatted like 14.07.2015.
There is another bug with LO 18.104.22.168 - both reports for charts could not be opened. Will report this also. So please test with LO 22.214.171.124. I tested with this and older versions. Worked right with LO 4.1.* and LO 126.96.36.199 (last installed 4.2-version here). Failed first with LO 188.8.131.52.
Confirming that in
Build ID: 88805f81e9fe61362df02b9941de8e38a9b5fd16
Locale : fr_
I see dates along x axis, so not just DE locale related
Also confirming that preview of chart in Report Edit mode show f or m with a number.
I sse same bug in LO4352, and additionally, the charts are incorrectly sized, to that the bottom of the charts is invisible (well half of the chart to be more exact).
Charts are correctly displayed in
Build ID: 63150712c6d317d27ce2db16eb94c2f3d7b699f8
This seems to have begun at the below commit. Unfortunately Kohei's no longer with us so nobody to forward this to.
The incorrect sizing and failure to open the report are separate issues
Author: Kohei Yoshida <firstname.lastname@example.org>
AuthorDate: Fri Jun 13 11:12:50 2014 -0400
Commit: Kohei Yoshida <email@example.com>
CommitDate: Thu Jun 19 14:46:56 2014 -0400
fdo#71076, fdo#71767: Preserve number formats when charts are copied.
For reference, the incorrect chart sizing/cropping seems to have been fixed prior to the current failure-to-load breakage, probably on bug 83354
The load breakage is bug 92720
Migrating Whiteboard tags to Keywords: (bibisected)
*** This bug has been marked as a duplicate of bug 90352 ***
(In reply to Xisco Faulí from comment #7)
> *** This bug has been marked as a duplicate of bug 90352 ***
How could this one be a duplicate of bug 90352? Have tested that bug? Couldn't reproduce bug 90352 it, if I am using *.ods instead of *.xls. Could reproduce bug 92719, when I am using Base and the report-builder with a chart in a (from report created) writer-document.
If there will appear a date instead of a text in a chart of a Base-report when using the source-format of the query without any date its something else than trying to change the format for the axis to other format instead.
(In reply to robert from comment #8)
> How could this one be a duplicate of bug 90352? Have tested that bug?
> Couldn't reproduce bug 90352 it, if I am using *.ods instead of *.xls. Could
> reproduce bug 92719, when I am using Base and the report-builder with a
> chart in a (from report created) writer-document.
> If there will appear a date instead of a text in a chart of a Base-report
> when using the source-format of the query without any date its something
> else than trying to change the format for the axis to other format instead.
Xisco's setting as duplicate appears to stem from the same commit being identified as responsible for the behaviour, i.e. Kohei's changes to the Calc number formatter which is also used in charts by the report wizard.