Ok. Now I´ve got it. In my case the imported data result:
19-04-2013 21-04-2013 20-05-2013 6 Xuñ, 2013 08-08-2013 26-08-2013 26-08-2013 26-08-2013 22-09-2013 1 Xan, 2014 23 Xan, 2014 27 Xan, 2014 31 Xan, 2014 14-02-2014 15-03-2014 11-05-2014 My format is DD-MM-AAAA. Even if I want to change between formats the cells that don´t have this format remain as is. It could be a bug. You should fill a bug report or ask for someone with an bugzilla account to do it. I don´t have so I can´t do it for You. Or You can try to write an email to Eike to see if he can do it. Regards 2013/5/7 Anton Meixome <[email protected]> > 2013/5/7 Sérgio Marques <[email protected]>: > > 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 <[email protected]> > >> > >> 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: [email protected] > >> 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 > -- Sérgio Marques -- To unsubscribe e-mail to: [email protected] 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
