Created attachment 101121 [details]
System: Libreoffice 18.104.22.168 and Ubuntu 14.04 LTS
The xlsx file created with Excel 2010 contains a scatter chart with a y-axis marked with m:ss time values which Calc shows incorrectly.
Attached is the original file. The y axis marks should read from 2:00 to 3:40 at 0:10 intervals. Calc shows them from 00:00 to 50:00 then 00:00 again to 40:00 at 10:00 intervals.
Note that Excel handles time values clumsily. Charts require range and intervals selections as fractions of 24 hours. see:
Created attachment 101122 [details]
screenshot of file rendered by Calc
Created attachment 101123 [details]
Screenshot of file rendered by Excel
Reproducible, tested using Mac OSX 10.9 with LibreOffice Version: 22.214.171.124.beta2
Build ID: a06aa316117a6ff0f05c697c82831c227812d810
What is the number format of Y-axis in Excel? (I don't have Excel for checking).
When opening the file with LO, Y-axys show data formated MM:SS while the data in the sheet are HH:MM
If I check the "use format source" box, the display is correct (and same as Excel).
The number format of the y-axis data in the Excel .xlsx file is Custom/h:mm
(I don't think it's relevant to the bug but the m:s/500m label reflects the
actual meaning of the data. The history is that the data were obtained and
logged in .csv by an Android cellphone running the BoatCoach app using the
format General, e.g. as 2:30/500m meaning a speed equivalent to 500 meters
in 2m 30s The .csv file was opened in Excel, the /500 "tails" were deleted
manually and the cells reformatted as hh:mm because if mm:ss was selected
(or any other format tried) Excel changed the data. I think it's because
Excel recognizes only date and clock time and not elapsed time, which is the
case here. The file was saved as .xlsx)
Sent: Monday, June 16, 2014 10:49 AM
Subject: [Bug 80067] Chart axis in file created with Excel displays
<mailto:email@example.com> GerardF changed bug 80067
Comment # 4 <https://bugs.freedesktop.org/show_bug.cgi?id=80067#c4> on bug
80067 <https://bugs.freedesktop.org/show_bug.cgi?id=80067> from
What is the number format of Y-axis in Excel? (I don't have Excel for
When opening the file with LO, Y-axys show data formated MM:SS while the
in the sheet are HH:MM
If I check the "use format source" box, the display is correct (and same as
You are receiving this mail because:
* You reported the bug.
Seems to work correctly in master. MIght have been fixed by one of the many ooxml chart commits recently.