Created attachment 101121 [details] original file System: Libreoffice 4.2.3.3 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: http://rnm1978.wordpress.com/2011/09/08/labelling-time-axes-in-excel/ Thank you. Bruno
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: 4.3.0.0.beta2 Build ID: a06aa316117a6ff0f05c697c82831c227812d810 Kind regards, Joren
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) Best regards, Bruno https://play.google.com/store/apps/details?id=com.eiref.boatcoach From: bugzilla-daemon@freedesktop.org [mailto:bugzilla-daemon@freedesktop.org] Sent: Monday, June 16, 2014 10:49 AM To: bvieri@ieee.org Subject: [Bug 80067] Chart axis in file created with Excel displays incorrect dates <mailto:gerard.fargeot@orange.fr> GerardF changed bug 80067 <https://bugs.freedesktop.org/show_bug.cgi?id=80067> What Removed Added CC gerard.fargeot@orange.fr 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 <mailto:gerard.fargeot@orange.fr> GerardF 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). _____ 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.