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 -- 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
