This one is ok in my calc sheet. No problem here.
2013/5/7 Anton Meixome <[email protected]> > 2013/5/8 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. > > > > > 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 <[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 > > > > -- > 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 -- 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
