https://bugs.freedesktop.org/show_bug.cgi?id=80067
--- Comment #5 from [email protected] --- 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: [email protected] [mailto:[email protected]] Sent: Monday, June 16, 2014 10:49 AM To: [email protected] Subject: [Bug 80067] Chart axis in file created with Excel displays incorrect dates <mailto:[email protected]> GerardF changed bug 80067 <https://bugs.freedesktop.org/show_bug.cgi?id=80067> What Removed Added CC [email protected] 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:[email protected]> 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. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
