Bug 87012 - REPORT-BUILDER: Charts without content if chart contain date or time
Summary: REPORT-BUILDER: Charts without content if chart contain date or time
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
4.2.6.2 release
Hardware: Other All
: high major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
Depends on: 68663 117162
Blocks: Database-Reports-Builder
  Show dependency treegraph
 
Reported: 2014-12-04 19:36 UTC by Robert Großkopf
Modified: 2022-06-02 21:58 UTC (History)
8 users (show)

See Also:
Crash report or crash signature:


Attachments
Database for testing some charts in Report-Builder (79.50 KB, application/vnd.oasis.opendocument.database)
2014-12-04 19:36 UTC, Robert Großkopf
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2014-12-04 19:36:58 UTC
Created attachment 110467 [details]
Database for testing some charts in Report-Builder

Open the attached database. 
Open one report.
Only the report Report-Integer-Temperature would show a chart with content. All other reports will show empty charts.

Works as expected with LO 4.2.0.0.beta2. Doesn't work with LO 4.2.8.1. Have no other version between this installed for testing.

My configuration: OpenSUSE 12.3 64bit rpm Linux.
Comment 1 Michael Stahl (allotropia) 2014-12-12 21:38:25 UTC
4.2.5.2 good, 4.2.6.2 bad

bibisect range: abf842e4b125b9f863ea4c2af17ad6ac7d82b15e.. e990e4d145f16c0c7e4e9e12c4882ddde63a3d5a

let's see, if we intersect the above ranges...

reverting these commits on master gets the data points back on the charts:

commit 2b959fb871a68f08a06850909abd16f71033aa3a
Author:     Kohei Yoshida <kohei.yoshida@collabora.com>
AuthorDate: Thu Jun 5 15:17:00 2014 -0400
Commit:     Markus Mohrhard <markus.mohrhard@googlemail.com>
CommitDate: Fri Jun 6 01:09:43 2014 +0000

    fdo#72727: Revert "-Werror=unused-but-set-variable second try"
    
    This reverts commit ccf7b15c0a5776c6431fdcb0c0e2b0f3935ae3dc.
    (cherry picked from commit 61d958f37ed2aad6be2eab7bb507e0fb77716eec)
    
commit 5a53dfa86a2b61154f4c2c7cb356d32a569aaf69
Author:     Kohei Yoshida <kohei.yoshida@collabora.com>
AuthorDate: Thu Jun 5 15:02:48 2014 -0400
Commit:     Markus Mohrhard <markus.mohrhard@googlemail.com>
CommitDate: Fri Jun 6 01:09:28 2014 +0000

    fdo#72727: Revert "fdo#68663 don't blindly force categories when there are"

    This reverts commit b090cbdf82e0827234caf5969124f6631311ef35.
    (cherry picked from commit 91ca3a92c54a08ad13497d7e8ac1916e7b68bbfd)
Comment 2 Lionel Elie Mamane 2014-12-18 04:43:09 UTC
This is quite possibly the same bug "under the hood" as bug 68663, whose fix was reverted to fix bug 72727.
Comment 3 Alex Thurgood 2015-01-03 17:39:21 UTC Comment hidden (no-value)
Comment 4 QA Administrators 2016-01-17 20:04:39 UTC Comment hidden (obsolete)
Comment 5 Robert Großkopf 2016-01-30 17:09:02 UTC
Couldn't be tested with LO 5.0 or newer because reports with charts couldn't be opened. See https://bugs.documentfoundation.org/show_bug.cgi?id=92720 .
Comment 6 Robert Großkopf 2016-03-05 11:09:26 UTC
Marked as regression, see comment1.
Comment 7 Alex Thurgood 2016-06-16 09:23:19 UTC
Tested Robert's sample database with 

Version: 5.1.3.2
Build ID: 644e4637d1d8544fd9f56425bd6cec110e49301b
CPU Threads: 2; OS Version: Mac OS X 10.11.5; UI Render: default; 
Locale: fr-FR (fr.UTF-8)

The only report that displays data points is Report_Integer_Temperature, on the other reports no data points are displayed at all.
Comment 8 Alex Thurgood 2016-06-16 09:42:17 UTC
Isn't this a DUP of bug 68781 ?
Comment 9 Xisco Faulí 2016-09-12 12:47:38 UTC
Adding keyword 'bibisectRequest'.
Comment 10 Xisco Faulí 2016-10-05 22:30:26 UTC
Adding Cc: to Kohei Yoshida
Comment 11 QA Administrators 2018-06-25 02:40:22 UTC Comment hidden (obsolete)
Comment 12 Robert Großkopf 2018-06-25 14:52:11 UTC
Bug still exists with LO 6.0.5.2, OpenSUSE 42.3 Leap, 64bit rpm Linux.

... but also the Report_Integer-Temperature doesn't show any chart. See bug117162 for this ...
Comment 13 QA Administrators 2019-06-26 02:45:45 UTC Comment hidden (obsolete)
Comment 14 Robert Großkopf 2019-06-26 14:05:15 UTC
Bug couldn't be tested, because charts aren't shown since LO 5.4.0.3. See bug 117162
Comment 15 QA Administrators 2021-06-26 03:29:21 UTC Comment hidden (obsolete)
Comment 16 Robert Großkopf 2021-06-26 06:09:24 UTC
Bug couldn't be tested, because charts aren't shown since LO 5.4.0.3. See bug 117162
Comment 17 Julien Nabet 2022-03-30 21:05:23 UTC
With master sources updated today (so including fix for tdf#117162), I could reproduce this.

I noticed these logs:
warn:xmloff:249169:249169:xmloff/source/chart/SchXMLTableContext.cxx:594: unknown attribute urn:oasis:names:tc:opendocument:xmlns:office:1.0 office:date-value value=2013-01-10T00:00:00.0Z
warn:xmloff:249169:249169:xmloff/source/chart/SchXMLTableContext.cxx:594: unknown attribute urn:oasis:names:tc:opendocument:xmlns:office:1.0 office:date-value value=2013-03-10T00:00:00.0Z
warn:xmloff:249169:249169:xmloff/source/chart/SchXMLTableContext.cxx:594: unknown attribute urn:oasis:names:tc:opendocument:xmlns:office:1.0 office:date-value value=2013-06-10T00:00:00.0Z
warn:xmloff:249169:249169:xmloff/source/chart/SchXMLTableContext.cxx:594: unknown attribute urn:oasis:names:tc:opendocument:xmlns:office:1.0 office:date-value value=2013-07-10T00:00:00.0Z
warn:xmloff:249169:249169:xmloff/source/chart/SchXMLTableContext.cxx:594: unknown attribute urn:oasis:names:tc:opendocument:xmlns:office:1.0 office:date-value value=2013-08-10T00:00:00.0Z
warn:xmloff:249169:249169:xmloff/source/chart/SchXMLTableContext.cxx:594: unknown attribute urn:oasis:names:tc:opendocument:xmlns:office:1.0 office:date-value value=2013-12-10T00:00:00.0Z


warn:xmloff:249793:249793:xmloff/source/chart/SchXMLTableContext.cxx:599: unknown attribute urn:oasis:names:tc:opendocument:xmlns:office:1.0 office:time-value value=PT07H00M00S
warn:xmloff:249793:249793:xmloff/source/chart/SchXMLTableContext.cxx:599: unknown attribute urn:oasis:names:tc:opendocument:xmlns:office:1.0 office:time-value value=PT08H00M00S
warn:xmloff:249793:249793:xmloff/source/chart/SchXMLTableContext.cxx:599: unknown attribute urn:oasis:names:tc:opendocument:xmlns:office:1.0 office:time-value value=PT11H30M00S
warn:xmloff:249793:249793:xmloff/source/chart/SchXMLTableContext.cxx:599: unknown attribute urn:oasis:names:tc:opendocument:xmlns:office:1.0 office:time-value value=PT15H00M00S
warn:xmloff:249793:249793:xmloff/source/chart/SchXMLTableContext.cxx:599: unknown attribute urn:oasis:names:tc:opendocument:xmlns:office:1.0 office:time-value value=PT18H00M00S
warn:xmloff:249793:249793:xmloff/source/chart/SchXMLTableContext.cxx:599: unknown attribute urn:oasis:names:tc:opendocument:xmlns:office:1.0 office:time-value value=PT22H00M00S

code pointer:
xmloff/source/chart/SchXMLTableContext.cxx
Comment 18 Alex Thurgood 2022-04-01 09:36:08 UTC
Bug still reproducible with

Version: 7.4.0.0.alpha0+ / LibreOffice Community
Build ID: 040b3198fde3385e19e7380fdcabae84a0abac9d
CPU threads: 8; OS: Mac OS X 12.2.1; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: en-US
Calc: threaded