[Libreoffice-bugs] [Bug 140653] When import timestamp with "Import Text Dialog", timestamp is shifted.

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #3 from watanabe nobuo <watanove at noveltte.jp> ---

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.

-- 
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/20210225/689cb0a3/attachment.htm>