2013/5/8 Anton Meixome <meixome@certima.net>:
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, 2014Yes, 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 <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
-- 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