https://bugs.documentfoundation.org/show_bug.cgi?id=137933
Bug ID: 137933
Summary: XLSX interoperability: not existing dates are handled
different on date axis in chart
Product: LibreOffice
Version: 7.1.0.0.alpha0+ Master
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Chart
Assignee: [email protected]
Reporter: [email protected]
Created attachment 166934
--> https://bugs.documentfoundation.org/attachment.cgi?id=166934&action=edit
example with manually set date start and interval
Open attached document in Excel and in LibreOffice.
The first date category is set to 2019-12-31, the main grid to 1 month. With
this setting you get the non existing date 31.Feb.2020.
Excel resolves non existing dates so that it uses the next previous date in
that month, and use the original day number for the next months.
LibreOffice resolves a non existing date so, that it goes a distance forward as
if 31.Feb.2020 exists but use the really existing date then. For further months
this new date it taken as start.
I think, that the way Excel does it, is the better way.
I come along this problem, when discussing the still open issue
https://issues.oasis-open.org/browse/OFFICE-2119 in the OASIS ODF TC.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
