Re: [libreoffice-l10n] Paste column with data format (DMY) fails

2013/5/7 Sérgio Marques <smarquespt@gmail.com>:
> 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.




> 2013/5/7 Anton Meixome <meixome@certima.net>
> > 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
> >
> >
> > --
> > Antón Méixome - Galician Native Lang Coordination
> > Galician community LibO & AOO
> >
> > --
> > To unsubscribe e-mail to: l10n+unsubscribe@global.libreoffice.org
> > Problems?
> > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > List archive: http://listarchives.libreoffice.org/global/l10n/
> > All messages sent to this list will be publicly archived and cannot be
> > deleted
>
>
>
>
> --
> Sérgio Marques



--
Antón Méixome - Galician Native Lang Coordination
Galician community LibO & AOO

-- 
To unsubscribe e-mail to: l10n+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/l10n/
All messages sent to this list will be publicly archived and cannot be deleted