Bug 74965 - FORMATTING: Wrong chart axis text using date values as text
Summary: FORMATTING: Wrong chart axis text using date values as text
Status: RESOLVED DUPLICATE of bug 74549
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Reported: 2014-02-14 08:12 UTC by sponkspam
Modified: 2015-01-23 14:04 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Bug in chart axis texts (46.45 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-02-14 08:12 UTC, sponkspam
x-axis scaling methods - bug when showing dates as text (wrong day/year) (114.25 KB, image/png)
2014-02-14 10:24 UTC, sponkspam

Note You need to log in before you can comment on or make changes to this bug.
Description sponkspam 2014-02-14 08:12:33 UTC
Created attachment 94049 [details]
Bug in chart axis texts

When using a column with datetime values as axis-text, scaled as TEXT (not date, because date can only handle intervals of whole days and not hours), the text string in the chart is completely wrong:
"01.02.2014 00:00" shows as "05.02.0114 00:00",
"10.02.2014 00:00" as "14.02.0114 00:00" and so on.

The time portion seems to be OK, but the date is wrong.
Charts seem to use 0000-1-1 as base date to add the days instead of 30.12.1899 and generate its own text value from that.

I'm not sure, but think it used to work in the previous release.
Operating System: Windows 7
Version: release
Comment 1 sophie 2014-02-14 10:03:52 UTC
Hi, what do you mean by scale as text? The X axis is formatted as date. I can see the wrong dates in your document, but I can't reproduce creating my own chart. Could you give some hints about where you format the data as text? Thanks - Sophie
Comment 2 sponkspam 2014-02-14 10:24:30 UTC
Created attachment 94057 [details]
x-axis scaling methods - bug when showing dates as text (wrong day/year)

The x-axis is not formatted as date, because that would work only with whole days. But as there are 4 values per day with different times, the chart would look completely different.
I attached a screenshot with two charts differing only in the scaling method of the x-axis.
Sorry, it's in German...
Comment 3 sophie 2014-02-14 11:10:35 UTC
Ok, thanks, I can reproduce now, confirmed using Version:
Build ID: 05dceb5d363845f2cf968344d7adab8dcfb2ba71 Ubuntu 13.10 x64.
Set as New, change plateform to All - Sophie
Comment 4 GerardF 2014-02-14 15:02:43 UTC
Already reported.

*** This bug has been marked as a duplicate of bug 74549 ***