| Summary: | FORMATTING: Wrong chart axis text using date values as text | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | sponkspam |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | normal | CC: | gerard.fargeot, sophi |
| Priority: | medium | ||
| Version: | 4.2.0.4 release | ||
| Hardware: | Other | ||
| OS: | All | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
Bug in chart axis texts
x-axis scaling methods - bug when showing dates as text (wrong day/year) |
||
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 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...
Ok, thanks, I can reproduce now, confirmed using Version: 4.2.0.4 Build ID: 05dceb5d363845f2cf968344d7adab8dcfb2ba71 Ubuntu 13.10 x64. Set as New, change plateform to All - Sophie |
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: 4.2.0.4 release