https://bugs.freedesktop.org/show_bug.cgi?id=84808
Bug ID: 84808
Summary: Date Formatting leads to change in values
Product: LibreOffice
Version: 4.1.4.2 release
Hardware: Other
OS: Windows (All)
Status: UNCONFIRMED
Severity: critical
Priority: medium
Component: Libreoffice
Assignee: [email protected]
Reporter: [email protected]
I had a very bad experience which led to huge impact while formatting the date
column in csv file using LibreOffice Calc.
The csv file has around 40000 recs with one of the column CREATE_DT having
dates in the format MM/DD/YYYY.
I used the format cell option (Right Click -> Format Cell -> Date) to change
the format of the first cell in CREATE_DT column to English (AUS) YYYY-MM-DD.
In order to apply this format change in the remaining 39999 dates below, I
simply double-clicked the bottom right corner of the first cell.
Dates changed to English AUS format, but all the values are wrong. Some of them
whose dates were 2014 in actual, changed to 2089!!
To make things worse, I deployed it in Production, and things went haywire!!
Please take this issue as a serious problem, because, if changing format
changes the data, only few would trust LibreOffice Calc for serious
assignments.
Appreciate your response.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
