Text import does not recognize some dates in YMD-format.
Steps to reproduce:
* open Calc
* enter some dates in YMD-format into first column
* select these cells
* copy this cells to clipboard
* move cursor to new cell
* press "Paste as Unformatted text" - this will open "Text import" window
* select for column type: "Date (YMD)"
* press "Ok" for start Import
As result - some dates are not recognized on import.
First (source column) Pasted column
1983-04-01 1983-04-01 <- was not recognized
1984-04-01 1984-04-01 <- was not recognized
Version checked: 188.8.131.52, 184.108.40.206
Created attachment 93897 [details]
Hi Ilya, thanks for reporting.
I can't reproduce with any version including 220.127.116.11.
Can you attach an "import window" screenshot or detail which are all the options?
Created attachment 93983 [details]
(In reply to comment #2)
> I can't reproduce with any version including 18.104.22.168.
This bug appears only on certain dates. I found only "YYYY-04-01". Does these values works normal in your case?
> Can you attach an "import window" screenshot or detail which are all the
With exactly your same options, works fine for me.
Please try resetting the user profile, sometimes solves strange issues.
If it doesn't work try changing your locale in Menu/Tools/Options/Language settings/Languages.
Created attachment 93984 [details]
(In reply to comment #5)
> Please try resetting the user profile, sometimes solves strange issues.
Tried on 4 clean virtual machines. LO configs were clean. (see Screenshot_2)
> try changing your locale in Menu/Tools/Options/Language
Tried - no luck. What can I try else?
Really I don't know.
Try changing the Character set and the Language in the import window.
> Try changing the Character set and the Language in the import window.
Did not help.
Can it be because of my operating systems are in Russian locale but yours not?
Additionally, I checked all dates (using autofill) from 0100-01-01 to 3000-01-01. Bug appears only on four dates:
And marking the option for Detect special numbers?
(In reply to comment #10)
> And marking the option for Detect special numbers?
Did not help too.
I tried to change many different options in "Text Import" dialog. May be I need some special combination of these options? But this does not answer the question why bug is reproduced on my machines only.
I have tens of virtual machines used for building projects on different Linux distribution. These VMs has almost default configuration. In comparison to default installation it just has few additional packages (mc, screen) and root-password. After all actions (build or test something) with VM I "reset" it back to "just-installed state". So these VMs are fully clean. There are no custom options.
And this bug is reproducing on these VMs. (see Screenshot_2)
Please take a look:
maybe some help can be found there.
Created attachment 94143 [details]
Just installed 3 VMs, in 3 locales: en, de, ru. Absolutely default installation. No options changed. Bug is still persists (see Screenshot_3).
(In reply to comment #5)
> With exactly your same options, works fine for me.
mariosv, please tell - what distribution, version, arch and locale do you use?
Found possible reason!
When I set timezone to London (GMT+0) - bug is not reproducing.
When I set timezone to my local (Russia, Yekaterinburg, GMT+6) or to Moscow (Russia, GMT+4) - bug is reproducing.
Hi Ilya, really a good job, thanks.
my system hour: (UTC+01:00) Bruselas, Copenhague, Madrid, París
Reproducible changing the system hour to:
(UTC+04:00) Moscú, S. Petersburgo, Volgogrado
Version: 22.214.171.124 Build ID: d7dbbd7842e6a58b0f521599204e827654e1fb8b
Change the status to NEW.
*** Bug 75404 has been marked as a duplicate of this bug. ***
Created attachment 99705 [details]
Sample file to test
Still reproducible for
UTC+04:00 Moscú, S. Petersburgo, Volgogrado
UTC+02:00 Helsinki, Kiev, Riika, Tallinna, Vilna
LibreOffice 3.4.5 OOO340m1 (Build:502)
Version: 126.96.36.199.0+ Build ID: f3ca9cc78e77dda656b5c39be928fdbb7f8babe8
TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-05-23_03:10:34
Versión: 188.8.131.52.beta1 Id. compilación: 2e39c7e59c8fc8b16a54c3d981dceef27fb0c07f
Version: 184.108.40.206.alpha0+ Build ID: e76dc5b422084f68cc4b27eea4cdbef3d3e7a1a9
TinderBox: Win-x86@39, Branch:master, Time: 2014-05-23_13:15:55
Last working for me:
LibreOffice 3.3.4 OOO330m19 (Build:401)tag libreoffice-220.127.116.11
The same issue opening from CSV (saving the test file as csv), selecting different character set doesn't solve the issue.
Change the version to the first where I can find the bug.
Set up as regression.
*** Bug 79663 has been marked as a duplicate of this bug. ***
On LibreOffice 18.104.22.168 OpenSUSE Linux 13.1 x64 following combination reproduces this bug:
| TZ environment variable | Input date |
| America/Montevideo | 1974-12-22 |
| Asia/Colombo | 1942-09-01 |
| Atlantic/Azores | 1942-04-25 |
| Atlantic/Azores | 1943-04-17 |
| Atlantic/Azores | 1944-04-22 |
| Atlantic/Azores | 1945-04-21 |
| Atlantic/Madeira | 1942-04-25 |
| Atlantic/Madeira | 1943-04-17 |
| Atlantic/Madeira | 1944-04-22 |
| Atlantic/Madeira | 1945-04-21 |
| Europe/Gibraltar | 1941-05-04 |
| Europe/Gibraltar | 1942-04-05 |
| Europe/Gibraltar | 1943-04-04 |
| Europe/Gibraltar | 1944-04-02 |
| Europe/Gibraltar | 1945-04-02 |
| Europe/Gibraltar | 1947-04-13 |
| Europe/Madrid | 1942-05-02 |
| Europe/Madrid | 1943-04-17 |
| Europe/Madrid | 1944-04-15 |
| Europe/Madrid | 1945-04-14 |
| Europe/Madrid | 1946-04-13 |
| Europe/Monaco | 1941-05-05 |
| Europe/Monaco | 1942-03-09 |
| Europe/Monaco | 1943-03-29 |
| Europe/Monaco | 1944-04-03 |
| Europe/Monaco | 1945-04-02 |
| Europe/Moscow | 1919-05-31 |
| Europe/Paris | 1945-04-02 |
| Pacific/Apia | 2011-12-30 |
| Pacific/Enderbury | 1995-01-01 |
| Pacific/Fakaofo | 2011-12-30 |
| Pacific/Kiritimati | 1995-01-01 |
| Pacific/Kwajalein | 1993-08-20 |
I think Bug 63230 is closely related to this bug because
the patch uploaded by Bug 63230 Comment 9 also fixes this bug.
Oops sorry, my bad, Comment 21 is incorrect. Please ignore it.
Should be fixed with bug 63230, please verify.
*** This bug has been marked as a duplicate of bug 63230 ***
Ubuntu 16.04 amd64
LibreOffice installed from PPA.
** Please read this message in its entirety before responding **
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/
If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.
Please DO NOT
Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not
appropriate in this case)
If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/
2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword
Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa
Thank you for helping us make LibreOffice even better for everyone!
Does not occur with recent 6.x releases and TZ=Europe/Moscow