<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Change of date"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108006">108006</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Change of date
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.2.6.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>guewey@pathcom.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
LibreOffice, now two days ahead of time
---------------------------------------
Attached are two LibreOffice spreadsheets named "Fido call history 2017.ods"
and "Temporary copy.ods", from now on referred to as "file F" anf "file T".
They deal with my habit of keeping track of my cellphone calls with Fido, my
cellphone service provider. Creation of file F was started on 04 March 2017 and
updated on 21 May 2017. File T was "created" on 21 May 2017 by just copying the
latest call data (not yet listed in file F) from my Fido account website. After
doing this, I copied the contents of file T to file F. Please, open both files
and take a close look at the date - i.e. the left-most - column: Do you notice
that for each call, the date in file F is two days ahead from the equivalent
date in file T?
I have the strong suspicion that there is a problem with your latest
spreadsheet update. I am not sure if the following observation is of any help
in solving the problem: When I right-click any of the dates in either of the
two files, then select "Format/Cells.../Numbers", "Date" is shown as "Category"
and "Default - English (USA)" as "Language". However, in file T, "01/02/00
01:37PM" is shown as "Format" while in file F, "12/31/99 01:37PM" is the
"Format".
I would greatly appreciate an explanation, and even more, a solution to the
above-described problem,
Guenter Wey, a user of LibreOffice since the days of Staroffice
Steps to Reproduce:
1. See 2 attachments
2.
3.
Actual Results:
Dates are changed by 2 days.
Expected Results:
That dates are not changed.
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:53.0) Gecko/20100101
Firefox/53.0</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>