[Libreoffice-bugs] [Bug 108006] New: Change of date

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 108006
           Summary: Change of date
           Product: LibreOffice
           Version: 5.2.6.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: guewey at pathcom.com

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

-- 
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/20170522/6c15c746/attachment.html>