[Libreoffice-bugs] [Bug 137933] New: XLSX interoperability: not existing dates are handled different on date axis in chart

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: rb.henschel at t-online.de

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201102/d2be85eb/attachment.htm>