Bug 140653 - When import timestamp with "Import Text Dialog",timestamp is shifted.
Summary: When import timestamp with "Import Text Dialog",timestamp is shifted.
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.4.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-02-24 22:01 UTC by watanabe nobuo
Modified: 2021-02-26 21:44 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Dialogs and Cells (144.03 KB, image/png)
2021-02-24 22:01 UTC, watanabe nobuo 		Details
fig2 (399.73 KB, image/png)
2021-02-25 21:43 UTC, watanabe nobuo 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description watanabe nobuo 2021-02-24 22:01:57 UTC 
Created attachment 170039 [details]
Dialogs and Cells

Hi, calc is  very useful tool!
 I use calc in Japan.
 I am very grateful for developers.

I found one little something like bug.
when I import text with "Import Text Dialog",
timestamp string will be shifted.

Original Text is like

 2021-02-20 15:46:19.01233
 2021-02-20 15:46:19.01233
 2021-02-20 15:46:19.01233

After I copied these lines ,I paste it on Calc.
Calc Open "Text Import Dialog".

The dialog display imported datas.That is correct;

But cells have shifted data
 25/02/21 15:46
 25/02/21 15:46
 25/02/21 15:46

When I used the Dialog , if I changed the type of data 'Standard' to  'Date(DMY)' or 'Date(MDY)' or 'Date(YMD)' ,
Cells will be have correct data.


Is this designed or ?


Please watch attachd file,too.

Sinceryly
Comment 1 m_a_riosv 2021-02-25 18:06:05 UTC 
Have you verified it is only a change of format or also a change of data.

Please test applying the desired format on the cells with shifted data.
Comment 2 watanabe nobuo 2021-02-25 21:43:41 UTC 
Created attachment 170063 [details]
fig2
Comment 3 watanabe nobuo 2021-02-25 21:53:02 UTC 
Thank you!

Original datas are
2021-02-26 06:03:05.64733
2021-02-26 06:03:05.64733
2021-02-26 06:03:05.64733

And dialog dislplay correct datas.

But cells have shifted data.
2025/2/27 6:03:05
2025/2/27 6:03:05
2025/2/27 6:03:05

I tried change the format of cells.
but thers is no change.

It is not like format problem.

And I import another datas
(They don't have mili seconds)
2021-02-26 06:03:05
2021-02-26 06:03:05
2021-02-26 06:03:05

But result is same.
2025-02-27 06:03:05
2025-02-27 06:03:05
2025-02-27 06:03:05
shifted 4Years.


And I import another datas
(I replaced '-' to '/')
2021/02/26 06:03:05
2021/02/26 06:03:05
2021/02/26 06:03:05

But result is same.
2025/2/27 6:03:05
2025/2/27 6:03:05
2025/2/27 6:03:05
shifted 4Years.

I attached fig2.

Please watch it,too.
Comment 4 QA Administrators 2021-02-26 04:11:59 UTC Comment hidden (obsolete)
Comment 5 m_a_riosv 2021-02-26 09:14:36 UTC 
Shifted four year, sure it is in relation with:

Menu/Tools/Options/LibreOffice calc/Calculate - Date, maybe you have the 01/01/1904 option marked.
Comment 6 watanabe nobuo 2021-02-26 21:44:55 UTC 
Thank you so much,
And I am sorry very so much.

I had marked the option to '01/01/1904',as you wrote.

After I changed the option to '12/30/1899',
the datas are imported correctly.

I can't understand why I had marked this option.
And I didn't know that there are calenders started with 12/30/1899 and 1904/1/1.

This is not bug,is my wrong setting.

I changed the Status to RESOLVED NOTABUG.

Thank you so much!