https://bugs.freedesktop.org/show_bug.cgi?id=80067
Priority: medium
Bug ID: 80067
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: Chart axis in file created with Excel displays
incorrectly with Calc
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: bvi...@ieee.org
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 4.2.3.3 release
Component: Chart
Product: LibreOffice
Created attachment 101121
--> https://bugs.freedesktop.org/attachment.cgi?id=101121&action=edit
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
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
