[Libreoffice-bugs] [Bug 140653] New: 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

            Bug ID: 140653
           Summary: When import timestamp with "Import Text
                    Dialog",timestamp is shifted.
           Product: LibreOffice
           Version: 7.0.4.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: watanove at noveltte.jp

Created attachment 170039
  --> https://bugs.documentfoundation.org/attachment.cgi?id=170039&action=edit
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

-- 
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/20210224/ac156567/attachment.htm>