2013/5/8 Anton Meixome <meix...@certima.net>: > 2013/5/7 Sérgio Marques <smarque...@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. >
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) > > > >> >> >> 2013/5/7 Anton Meixome <meix...@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+unsubscr...@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 -- Antón Méixome - Galician Native Lang Coordination Galician community LibO & AOO -- To unsubscribe e-mail to: l10n+unsubscr...@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
