[Upstream] x-axis displays incorrect information in calc chart

Bug #1301725 reported by Jaime Carpenter
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
LibreOffice
Fix Released
Critical
libreoffice (Ubuntu)
Fix Released
Medium
Unassigned

Bug Description

The chart tool in the LibreOffice Calc program included with Ubuntu 14.04 LTS has a bug with the x-axis information. This is a known bug in LibreOffice 4.2.x

https://bugs.freedesktop.org/show_bug.cgi?id=74549

I am posting it here in the hope that it will also be corrected in the Ubuntu package that is part of 14.04 LTS. I tested this on Ubuntu 14.04 LTS Beta 2 and the LibreOffice is version 4.2.3.2 build id: 420m0(Build:2)

Revision history for this message
In , Eneko Lacunza (elacunza) wrote :

Created attachment 93432
Simple spreadsheet that demonstrates the bug

We three lines of data, the first are date values and the other two count values (estimated ours - not relevant for the bug).

When creating a chart with first line for X-axis label, graph is good but the labels are not. Seems there is some type of misscalculation.

Please find attached spreadsheet that demonstrates the bug, there are some red-marked data that are not correctly shown in the chart.

ODS file is created with LibreOffice 3.5.7.2
Build ID: 350m1(Build:2) and it's shown correctly.

Revision history for this message
In , Dominique-boutry3 (dominique-boutry3) wrote :

Hi.

Please how did you manage to have:
- an X-axis showing 5 days per 7 (01-21, 01-24, 01-25... but no 01-22, 01-23)
- based on series which show these 2 days (all 7 days per 7) ?

Thanks

Revision history for this message
In , Eneko Lacunza (elacunza) wrote :

Hi Dominique,

The chart is based directly on spreadsheet data. Date calculus is made
using B2 as starting date, then dia.lab() function (WORKDAY()) is used
to calculate next bussiness day.

Spreadsheet show correct dates, but chart does not.

Revision history for this message
In , Gerard-fargeot (gerard-fargeot) wrote :

Reproducible with Version: 4.3.0.0.alpha0+
Build ID: f571104ef38ba9f7f6073e22c2374add7aa73887
TinderBox: Win-x86@39, Branch:master, Time: 2014-01-28_00:11:40
Sorry, don't have 4.2.0 for testing.

All dates in X-axis are offset by 693958 days. Show 0114-01-21 instead of 2014-01-17 for the 1st.

Format scale axis to "date" or "automatic" cure the problem.
It seems that setting date as "text" misinterpret the date.

Revision history for this message
In , Gerard-fargeot (gerard-fargeot) wrote :

Created attachment 93526
File with Histogram and X-axis date scale as text

Affect Line chart but also Histogram. All charts where you can scale Axis as "Date" or "Text".

It seems that the new date origin is not 31/12/1899 for chart but JC birth... :)

Revision history for this message
In , Gerard-fargeot (gerard-fargeot) wrote :

Raise importance to High/Critical.
I don't know if we should consider this as a blocker/mab as most of users use real date for X-asis and not text category.

Revision history for this message
In , Dominique-boutry3 (dominique-boutry3) wrote :

Results of my experiments:

The data type of X-Axis values is "Text" (and not Date: should it was, you would have seen the saturdays and sundays wihout data).
If you format the X-Axis values with "Number>Default", you see the repesentation of right numeric values (41656, 41659, and so on).
If you format the X-Axis values with "Date>31/12/99", you see "21/01/14, 24/01/14", and so on. The conversion into Date is false, too high by contant 4.

Step to reproduce :
- in a New spreadsheet,
- fill in A1 with 41676, C1 with "=A1" formatted as "Date" : 06/02/14, OK
- fill in A2 with 100, select A1:A2, Insert a Chart, Column-type, "Next", "Data series in rows", "First row as label" then "Finish",
- right click on the 41676 value in X-axis, "Format Axis", then "Date"
- Observe "10/02/14"!
- You have just been stolen 4 days... Quick, quick, close the doors...

Revision history for this message
In , Dominique-boutry3 (dominique-boutry3) wrote :

Similar conclusion... obtained at the same time (Mid-air collision).

Revision history for this message
In , Gerard-fargeot (gerard-fargeot) wrote :

*** Bug 74965 has been marked as a duplicate of this bug. ***

Revision history for this message
In , Libreoffice-commits (libreoffice-commits) wrote :

Markus Mohrhard committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=22c7da0ca5438b69165609db2a1ef219aa167dc2

the type in the Any is a util::Date and not a DateTime, fdo#74549

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds
Affected users are encouraged to test the fix and report feedback.

Revision history for this message
In , Markus Mohrhard (moggi) wrote :

attachment 93432 worked without a problem in master.

I fixed the issue that I saw with attachment attachment 93526. Hopefully that fixes also the issue that you see with 93432. Backport request for 4-2 pending in gerrit.

Please test in a daily build that it is really fixed.

Revision history for this message
In , Jorendc (jorendc) wrote :

@Markus: bug 76087 is related/a dupe?

Thanks for fixing :-)!

Revision history for this message
In , Libreoffice-commits (libreoffice-commits) wrote :

Markus Mohrhard committed a patch related to this issue.
It has been pushed to "libreoffice-4-2":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=d5580b252ad4cfea10422c044366c3c6c1ebed83&h=libreoffice-4-2

the type in the Any is a util::Date and not a DateTime, fdo#74549

It will be available in LibreOffice 4.2.4.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds
Affected users are encouraged to test the fix and report feedback.

Revision history for this message
In , Markus Mohrhard (moggi) wrote :

*** Bug 76087 has been marked as a duplicate of this bug. ***

Revision history for this message
In , Markus Mohrhard (moggi) wrote :

*** Bug 75711 has been marked as a duplicate of this bug. ***

Revision history for this message
In , Libreoffice-commits (libreoffice-commits) wrote :

Markus Mohrhard committed a patch related to this issue.
It has been pushed to "libreoffice-4-2-3":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=1b9f2f843723e45c0f5a8899b754f0dab01e5df6&h=libreoffice-4-2-3

the type in the Any is a util::Date and not a DateTime, fdo#74549

It will be available already in LibreOffice 4.2.3.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds
Affected users are encouraged to test the fix and report feedback.

Revision history for this message
In , Jorendc (jorendc) wrote :

*** Bug 76860 has been marked as a duplicate of this bug. ***

Revision history for this message
In , Jaime Carpenter (j.carpenter) wrote :

Created attachment 96738
x axis shows incorrect date information. Should be same as the selected cells

Revision history for this message
Jaime Carpenter (j.carpenter) wrote :
Revision history for this message
In , Jorendc (jorendc) wrote :

*** Bug 76969 has been marked as a duplicate of this bug. ***

penalvch (penalvch)
Changed in libreoffice (Ubuntu):
importance: Undecided → Medium
status: New → Triaged
tags: added: amd64 trusty
summary: - x-axis displays incorrect information in calc chart
+ [Upstream] x-axis displays incorrect information in calc chart
tags: added: cherry-pick
Changed in df-libreoffice:
importance: Unknown → Critical
status: Unknown → Fix Released
Revision history for this message
Jaime Carpenter (j.carpenter) wrote : Re: [Bug 1301725] Re: x-axis displays incorrect information in calc chart

Christopher,

I appreciate the response, however I do not understand your comment
about notifying the upstream developers. I did report the bug upstream
as well to the document foundation.

I reported the bug as 76860 and it was flagged as a duplicate of bug
74549
. The latter is being reported as "fixed" in version 4.3 or 4.2.3.

https://bugs.freedesktop.org/show_bug.cgi?id=76860
https://bugs.freedesktop.org/show_bug.cgi?id=74549

I reported it to Ubuntu/Launchpad because Ubuntu it preparing to release
14.04 (Trusty Tahr) and the beta that I am testing shows that the bug
exists in the charting tool of LibreOffice 4.2 included in Ubuntu
14.04. I am hoping that this can be addressed before the release.

Please let me know if I have made an error in reporting. It had
appeared to me that I have taken all the correct steps.

Sincerely,
Jaime Carpenter
Lexington, KY

On 04/03/2014 09:46 PM, Christopher M. Penalver wrote:
> Jaime Carpenter, thank you for taking the time to report this bug and
> helping to make Ubuntu better. The issue you are reporting is an
> upstream one. It would be nice if somebody having it could send the bug
> to the developers of the software by following the instructions verbatim
> at http://wiki.documentfoundation.org/BugReport . If you have done so,
> please tell us the number of the upstream bug (or the link), so we can
> add a bugwatch that will inform us about the status. Thanks in advance.
>
> Helpful bug reporting tips:
> https://wiki.ubuntu.com/ReportingBugs
>
> ** Changed in: libreoffice (Ubuntu)
> Importance: Undecided => Medium
>
> ** Changed in: libreoffice (Ubuntu)
> Status: New => Triaged
>
> ** Tags added: amd64 trusty
>
> ** Bug watch added: freedesktop.org Bugzilla #74549
> https://bugs.freedesktop.org/show_bug.cgi?id=74549
>
> ** Also affects: df-libreoffice via
> https://bugs.freedesktop.org/show_bug.cgi?id=74549
> Importance: Unknown
> Status: Unknown
>
> ** Summary changed:
>
> - x-axis displays incorrect information in calc chart
> + [Upstream] x-axis displays incorrect information in calc chart
>
> ** Tags added: cherry-pick
>

Revision history for this message
In , Björn Michaelsen (bjoern-michaelsen) wrote :

Hmm the x-axis label in attachment 96738 still look wrong to me in 4.2.3.2. Is that a different bug, or should this one be reopened?

Revision history for this message
In , Eneko Lacunza (elacunza) wrote :

I see this fixed in Ubuntu PPA 4.2.3rc3, thanks!!

Revision history for this message
Jaime Carpenter (j.carpenter) wrote :

Will this fix be included in the 14.04 LTS release on April 17, 2014?

Revision history for this message
Jaime Carpenter (j.carpenter) wrote :

I still do not see this issue fixed. I am using Ubuntu 14.04 LTS and it is still not working correctly. LibreOffice Version: 4.2.3.3
Build ID: 420m0(Build:3).

This issue is NOT fixed.

Changed in libreoffice (Ubuntu):
status: Triaged → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.