https://bugs.documentfoundation.org/show_bug.cgi?id=165733
Bug ID: 165733
Summary: Some BC dates cannot be saved In Calc
Product: LibreOffice
Version: 25.2.1.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I found that some BC dates in LibreOffice 25.2 could not be saved When the
"Paste" operation is used to fill in the cell, it will be displayed as
"1899-12-30 00:00:00". After manual correction, save and exit. When the table
file is opened again, they will become the error status of "1899-12-30
00:00:00"
However, if it is stored as Double, it can be referenced in the form of a
formula in the cell (for example: "=D2"), And set the display format to date,
which will not restore to the error value after the second opening after saving
Note: I use version 25.2. I haven't tested other versions. I don't know if this
problem also exists.
Thank you very much. I use LibreOffice every week. It's great!!!
The list of problems I found is as follows:
-1517-03-14 20:39:09
-1381-03-12 04:49:14
-1229-03-11 08:48:24
-1153-03-11 01:31:43
-1077-03-10 13:17:58
-0925-03-09 20:14:03
-0485-03-05 18:38:01
-0409-03-05 22:13:10
-0189-03-03 06:03:03
Steps to Reproduce:
I have described in detail above.
Actual Results:
1899-12-30 00:00:00
1899-12-30 00:00:00
1899-12-30 00:00:00
1899-12-30 00:00:00
1899-12-30 00:00:00
1899-12-30 00:00:00
1899-12-30 00:00:00
1899-12-30 00:00:00
1899-12-30 00:00:00
Expected Results:
-1517-03-14 20:39:09
-1381-03-12 04:49:14
-1229-03-11 08:48:24
-1153-03-11 01:31:43
-1077-03-10 13:17:58
-0925-03-09 20:14:03
-0485-03-05 18:38:01
-0409-03-05 22:13:10
-0189-03-03 06:03:03
Reproducible: Always
User Profile Reset: No
Additional Info:
This is a serious problem, which will lead to the rework of last week's work,
and such data loss is difficult to find in the massive data.
Please notify me after solving the problem. Thank you!!!
[email protected] Lee.
--
You are receiving this mail because:
You are the assignee for the bug.
