Paste column with data format (DMY) fails

Anton_Meixome · May 7, 2013, 7:57pm

I suspect we (galician) have a bug in Calc

If I have a list of data in a text file items as

19 Abr, 2013
21 Abr, 2013
20 Mai, 2013
6 Xuñ, 2013
8 Ago, 2013
26 Ago, 2013
26 Ago, 2013
26 Ago, 2013
22 Set, 2013
1 Xan, 2014
23 Xan, 2014
27 Xan, 2014
31 Xan, 2014
14 Feb, 2014
15 Mar, 2014
11 Mai, 2014

and I paste it on Calc, this results

19 Abr, 2013
21 Abr, 2013
20 Mai, 2013
6 Xuñ, 2013
8 Ago, 2013
26 Ago, 2013
26 Ago, 2013
26 Ago, 2013
22 Set, 2013
1 Xan, 2014
23 Xan, 2014
27 Xan, 2014
31 Xan, 2014
14/02/14
15/03/14
11 Mai, 2014

Obviously is incorrect. If somebody compares with month names in english

19 Apr, 2013
21 Apr, 2013
20 May, 2013
6 Jun, 2013
8 Aug, 2013
26 Aug, 2013
26 Aug, 2013
26 Aug, 2013
22 Sep, 2013
1 Jan, 2014
23 Jan, 2014
27 Jan, 2014
31 Jan, 2014
14 Feb, 2014
15 Mar, 2014
11 May, 2014

Results correctly

19/04/13
21/04/13
20/05/13
06/06/13
08/08/13
26/08/13
26/08/13
26/08/13
22/09/13
01/01/14
23/01/14
27/01/14
31/01/14
14/02/14
15/03/14
11/05/14

I have perfoms various test with spanish, portuguese, diferents
formats (with dot, uppercase...)

This problem is no related with auto fill cells in galician. In fact
if I introduce

xan
feb

and extend the autofill lists in the sheet (Tools→Options→LibreOffice
Calc→ Sort lists) results

xan
feb
Mar
Abr
Mai
Xuñ
Xul
Ago
Set
Out
Nov
Dec
Xan

(correct)
Working correctly even if the calc interface is set in english

Compare

Portuguese

19 Abr, 2013
21 Abr, 2013
20 Mai, 2013
6 Jun, 2013
8 Ago, 2013
26 Ago, 2013
26 Ago, 2013
26 Ago, 2013
22 Set, 2013
1 Jan, 2014
23 Jan, 2014
27 Jan, 2014
31 Jan, 2014
14 Feb, 2014
15 Mar, 2014
11 Mai, 2014

or Spanish

19 Abr, 2013
21 Abr, 2013
20 May, 2013
6 Jun, 2013
8 Ago, 2013
26 Ago, 2013
26 Ago, 2013
26 Ago, 2013
22 Sep, 2013
1 Ene, 2014
23 Ene, 2014
27 Ene, 2014
31 Ene, 2014
14 Feb, 2014
15 Mar, 2014
11 May, 2014

Results

19/04/13
21/04/13
20/05/13
06/06/13
08/08/13
26/08/13
26/08/13
26/08/13
22/09/13
01/01/14
23/01/14
27/01/14
31/01/14
14/02/14
15/03/14
11/05/14

Can somebody test and guide me for filling the bug?

Thanks

Sergio_Marques · May 7, 2013, 9:16pm

Hi Anton

I´m from Portuguese team. Can You explain me how to reproduce this? I can´t
do it.

If I Copy/paste the results are the same:

19 Abr, 2013
21 Abr, 2013
20 Mai, 2013
6 Jun, 2013
8 Ago, 2013
26 Ago, 2013
26 Ago, 2013
26 Ago, 2013
22 Set, 2013
1 Jan, 2014
23 Jan, 2014
27 Jan, 2014
31 Jan, 2014
14 Feb, 2014
15 Mar, 2014
11 Mai, 2014

Anton_Meixome · May 7, 2013, 10:20pm

Hi Anton

I´m from Portuguese team. Can You explain me how to reproduce this? I can´t
do it.

If I Copy/paste the results are the same:

19 Abr, 2013
21 Abr, 2013
20 Mai, 2013
6 Jun, 2013
8 Ago, 2013
26 Ago, 2013
26 Ago, 2013
26 Ago, 2013
22 Set, 2013
1 Jan, 2014
23 Jan, 2014
27 Jan, 2014
31 Jan, 2014
14 Feb, 2014
15 Mar, 2014
11 Mai, 2014

Yes, Sérgio

1. In a text editor, copy the items, as simple text (it's important)
2. Select all with mouse, and copy
3. Open Calc
4. Paste inside a cell

Then, appears a dialog (Importación de texto)

- Select the language for import (personalizado) : Portugués
- Inside section "campos", select type of column : Data (DMA), as
tipical for galician or portuguese vs. english (AMD)
- Accept

The result is

19/04/13
21/04/13
20/05/13
06/06/13
...

because the default format for data in my case is «31/12/99 (= D/MM/YY)»

After, if you want change this format, is simple, you must go to
Format→Cells and in the tab «Númbers» you can choose what you want:
i.e. NNNND "de" MMMM "de" YYYY, etc.

Calc can change correctly between formats because the source data went
correctly recognized.

Anton_Meixome · May 7, 2013, 10:56pm

Hi Anton

I´m from Portuguese team. Can You explain me how to reproduce this? I can´t
do it.

If I Copy/paste the results are the same:

19 Abr, 2013
21 Abr, 2013
20 Mai, 2013
6 Jun, 2013
8 Ago, 2013
26 Ago, 2013
26 Ago, 2013
26 Ago, 2013
22 Set, 2013
1 Jan, 2014
23 Jan, 2014
27 Jan, 2014
31 Jan, 2014
14 Feb, 2014
15 Mar, 2014
11 Mai, 2014

Yes, Sérgio

1. In a text editor, copy the items, as simple text (it's important)
2. Select all with mouse, and copy
3. Open Calc
4. Paste inside a cell

Then, appears a dialog (Importación de texto)

- Select the language for import (personalizado) : Portugués
- Inside section "campos", select type of column : Data (DMA), as
tipical for galician or portuguese vs. english (AMD)
- Accept

The result is

19/04/13
21/04/13
20/05/13
06/06/13
...

because the default format for data in my case is «31/12/99 (= D/MM/YY)»

After, if you want change this format, is simple, you must go to
Format→Cells and in the tab «Númbers» you can choose what you want:
i.e. NNNND "de" MMMM "de" YYYY, etc.

Calc can change correctly between formats because the source data went
correctly recognized.

Look this serie

1 Jan, 2012
2 Feb, 2012
3 Mar, 2012
4 Abr, 2012
5 May, 2012
6 Jun, 2012
7 Jul, 2012

seen in Calc

01/01/12
02/02/12
03/03/12
04/04/12
05/05/12
06/06/12
07/07/12

Calc transforms it correctly, even when there are some errors (Feb→Fev; May→Mai)
but, ... these "errors" matchs with english forms...

Reverse ? No, of course. Look

Serie for english with "errors" in portuguese

1 Jan, 2012
2 Feb, 2012
3 Mar, 2012
4 Abr, 2012
5 Mai, 2012
6 Jun, 2012
7 Jul, 2012

Results

01/01/12
02/02/12
03/03/12
4 Abr, 2012
5 Mai, 2012
06/06/12
07/07/12

This is the probe. Calc refuse admit in english "Abr" or "Mai" but
accepts "Feb" or "May" in portuguese.

What do you think about?

The case for galician is worst, because there are more different
nomenclature for months (Xan/Jan, Abr/Apr, Mai/May, Xuñ/Jun, Xul/Jul,
Ago/Aug, Set/Sep, Out/Oct)

Sergio_Marques · May 8, 2013, 8:03am

This one is ok in my calc sheet. No problem here.

sophi · May 8, 2013, 9:47am

Hi Anton,

I suspect we (galician) have a bug in Calc

If I have a list of data in a text file items as

19 Abr, 2013
21 Abr, 2013
20 Mai, 2013
6 Xuñ, 2013
8 Ago, 2013
26 Ago, 2013
26 Ago, 2013
26 Ago, 2013
22 Set, 2013
1 Xan, 2014
23 Xan, 2014
27 Xan, 2014
31 Xan, 2014
14 Feb, 2014
15 Mar, 2014
11 Mai, 2014

and I paste it on Calc, this results

19 Abr, 2013
21 Abr, 2013
20 Mai, 2013
6 Xuñ, 2013
8 Ago, 2013
26 Ago, 2013
26 Ago, 2013
26 Ago, 2013
22 Set, 2013
1 Xan, 2014
23 Xan, 2014
27 Xan, 2014
31 Xan, 2014
14/02/14
15/03/14
11 Mai, 2014

Obviously is incorrect. If somebody compares with month names in english

I can reproduce your bug using Galician in the import dialog, I got the
same result. I'm under debian using LO 4.0.3. To fill your issue, you
can use the BSA (Bug Submission Assistant). I've also quickly chech
under Bugzilla and your bug doesn't seem to exist.
The BSA is reachabl from here :
https://www.libreoffice.org/get-help/bug/
the form will guide you to give all the necessary details, but you did
it already well in your message. Just don't forget to indicate your
system and your LibreOffice version.

Kind regards
Sophie

Anton_Meixome · May 8, 2013, 4:36pm

Thanks Sérgio and Sophie.

The bug is not depending OS nor recent version.

I have fill a bug.

sophi · May 8, 2013, 7:40pm

Thanks Sérgio and Sophie.

The bug is not depending OS nor recent version.

Yes but in general, QA requests it

I have fill a bug.

Great and thanks

Kind regards
Sophie