Summary: | Chart axis in file created with Excel displays incorrect dates | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | bvieri |
Component: | Chart | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | QA Contact: | |
Severity: | normal | ||
Priority: | medium | CC: | gerard.fargeot, jorendc |
Version: | 4.2.3.3 release | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
i915 platform: | i915 features: | ||
Bug Depends on: | |||
Bug Blocks: | 75057 | ||
Attachments: |
original file
screenshot of file rendered by Calc Screenshot of file rendered by Excel |
Description
bvieri
2014-06-15 21:37:51 UTC
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. |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.