<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:xiscofauli@libreoffice.org" title="Xisco Faulí <xiscofauli@libreoffice.org>"> <span class="fn">Xisco Faulí</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - FILEOPEN: XLSX: wrong dates shown with weekdays ( see comment 11 )"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=129980">bug 129980</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEW
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>xiscofauli@libreoffice.org
</td>
</tr>
<tr>
<td style="text-align:right;">Keywords</td>
<td>
</td>
<td>filter:xlsx
</td>
</tr>
<tr>
<td style="text-align:right;">Version</td>
<td>6.3.3.2 release
</td>
<td>Inherited From OOo
</td>
</tr>
<tr>
<td style="text-align:right;">Summary</td>
<td>FILEOPEN: wrong dates shown with weekdays
</td>
<td>FILEOPEN: XLSX: wrong dates shown with weekdays ( see comment 11 )
</td>
</tr>
<tr>
<td style="text-align:right;">OS</td>
<td>Windows (All)
</td>
<td>All
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr>
<tr>
<td style="text-align:right;">Hardware</td>
<td>IA64 (Itanium)
</td>
<td>All
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - FILEOPEN: XLSX: wrong dates shown with weekdays ( see comment 11 )"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=129980#c12">Comment # 12</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - FILEOPEN: XLSX: wrong dates shown with weekdays ( see comment 11 )"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=129980">bug 129980</a>
from <span class="vcard"><a class="email" href="mailto:xiscofauli@libreoffice.org" title="Xisco Faulí <xiscofauli@libreoffice.org>"> <span class="fn">Xisco Faulí</span></a>
</span></b>
<pre>(In reply to Oliver Brinzing from <a href="show_bug.cgi?id=129980#c11">comment #11</a>)
<span class="quote">> (In reply to Wolfgang Schweitzer from <a href="show_bug.cgi?id=129980#c0">comment #0</a>)
> > 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</span >
Yep, same problem here. Reproduced back to
LibreOffice 3.3.0
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>