Bug 91289 - Base Report Chart does not show the X-Axis Value on Output generation, if X-Axis is formatted as Date
Summary: Base Report Chart does not show the X-Axis Value on Output generation, if X-A...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Chart
  Show dependency treegraph
Reported: 2015-05-14 16:12 UTC by maxcnc
Modified: 2024-01-05 17:50 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

bugreportbase x-axis not visable (74.79 KB, image/jpeg)
2015-05-14 16:12 UTC, maxcnc
91289 bug atachment (60.94 KB, application/vnd.oasis.opendocument.database)
2015-05-19 18:00 UTC, maxcnc
x-axis formatted as text will be shown ... (114.39 KB, application/vnd.oasis.opendocument.database)
2015-05-19 19:09 UTC, Robert Großkopf

Note You need to log in before you can comment on or make changes to this bug.
Description maxcnc 2015-05-14 16:12:58 UTC
Created attachment 115603 [details]
bugreportbase x-axis not visable

Hi my first bug report ever 
Version: Build-ID: 88805f81e9fe61362df02b9941de8e38a9b5fd16
OS Ubuntu 14.04 
but im with it since OOO and now got to 14.04 ubuntu

First all is good in 3.2 on ubuntu 10.04

i did the hole report new so  i assume its not the old file 

1 Generated a chart in a report  footer with SQL command 
 the preview showes all correct as expected 
2 when hiting the output REPORT Run Button the report generates but with no X-axis value at all 

X axis label or tilel is well below shown 
so it seams to me that the X-axis field is simply not there in generation of the real report
Comment 1 Robert Großkopf 2015-05-15 19:02:00 UTC
Could not confirm the x-axis is missing. But there are many other problems with charts and date or time... See https://bugs.documentfoundation.org/show_bug.cgi?id=84882 and all the bugs at "See also".
Comment 2 Alex Thurgood 2015-05-19 14:15:41 UTC
@maxcnc: please provide a test odb file, and detailed explanation of what you are doing to reproduce the behaviour :

"generated a chart in a report footer with SQL command" is not sufficient for us to be able to reproduce.

Setting to NEEDINFO pending requested information. Please set back to UNCONFIRMED once you have done so.
Comment 3 maxcnc 2015-05-19 17:04:21 UTC
hi first thanks to get feedback 

so what is going on 
 i got a csv file from a Farmstation with the Data 
i import to Calc with setting dates  YMD in imortfield correct so it showes
localised 15.05.2015  correct as dates it also converts to whatever i want in calc Dateformates CORRECT Behavier

Then mark all the data rows (200) and paste into an NEW Table in BASE
with setting all the formats as needed by Declaration Correct Behave

now i can work back and forth to all Forms Reports ok 

Fault is Report builder API maybee does not give the correct Format to the Writer output as Report is generated via Internel Reportbuilder (maybe in EN Mode throu a fail dataexport into chart implement in writer

There are siimply no data exported 

THE Report preview of the chart shoes correct info in Preview as expected the output 

i will produce a test file with some data
Comment 4 maxcnc 2015-05-19 18:00:07 UTC
Created attachment 115729 [details]
91289 bug atachment

this is the testfile open the report in edit mode you shoudt see the correct DATE values in the charts 
produce the real output and you see there are gone
Comment 5 Robert Großkopf 2015-05-19 18:57:53 UTC
I could confirm the behavior for x-axis as date-formatted value.

Will attach a new file. Have a look at the second report. I changed the date into char with the following query:
SELECT RIGHT('0'||DAY("Datum"),2)||'.'||RIGHT('0'||MONTH("Datum"),2)||'.'||YEAR("Datum") AS "Dat", COUNT( "AUNr" ) AS "Fahrten", COUNT(DISTINCT "FeldNr" ) AS "Felder" FROM "biogas" WHERE "ID" > 4 GROUP BY "Dat"

The characters were shown right in the x-axis.
Comment 6 Robert Großkopf 2015-05-19 19:09:35 UTC
Created attachment 115732 [details]
x-axis formatted as text will be shown ...

Have tested it with other versions. The bug doesn't appear with LO The first versions of LO 4.0 doesn't open the report ("Failed to parse the report"). I could test this up to Next version I have installed is LO This version is the first here which could open the report but shows the buggy behavior. Date isn't shown in x-axis, if it is formatted as date.
Comment 7 QA Administrators 2016-09-20 10:01:35 UTC Comment hidden (obsolete)
Comment 8 QA Administrators 2021-03-19 04:41:35 UTC Comment hidden (obsolete)
Comment 9 QA Administrators 2023-03-20 03:26:58 UTC Comment hidden (obsolete)
Comment 10 Robert Großkopf 2023-03-20 06:46:16 UTC
Bug still exist in LO under OpenSUSE 15.3 64bit rpm Linux.
Comment 11 Michael 2024-01-05 17:50:49 UTC
Same here using
Version: / LibreOffice Community
Build ID: c28ca90fd6e1a19e189fc16c05f8f8924961e12e
CPU threads: 16; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded