[Libreoffice-bugs] [Bug 129980] FILEOPEN: XLSX: wrong dates shown with weekdays ( see comment 11 )

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=129980

Xisco Faulí <xiscofauli at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
                 CC|                            |xiscofauli at libreoffice.org
           Keywords|                            |filter:xlsx
            Version|6.3.3.2 release             |Inherited From OOo
            Summary|FILEOPEN: wrong dates shown |FILEOPEN: XLSX: wrong dates
                   |with weekdays               |shown with weekdays ( see
                   |                            |comment 11 )
                 OS|Windows (All)               |All
     Ever confirmed|0                           |1
           Hardware|IA64 (Itanium)              |All

--- Comment #12 from Xisco Faulí <xiscofauli at libreoffice.org> ---
(In reply to Oliver Brinzing from comment #11)
> (In reply to Wolfgang Schweitzer from comment #0)
> > Actual Results:
> > All weekdays in column A appear 1 line shifted up. They don't match the
> > dates shown in column B - look up a calendar to verify. 13 Jan 2020 is a
> > Monday, not a Tuesday as shown, etc.. 
> > Expected Results:
> > Weekdays shown in column A match the dates shown in column B.
> 
> Cells in column A do not reference date values in column B, they contain
> static text, e.g. Di,Mi,Do.
> 
> Cells in column B contain dates, but 13.01.1900 instead 13.01.2020.
> 
> What i noticed opening the file with:
> Excel:  cell A2:B2 -> Di 14. Jan
> LO6402: cell A2:B2 -> Di 13. Jan

Yep, same problem here. Reproduced back to

LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4

-- 
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/20200217/31b67872/attachment.htm>