Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


This one is ok in my calc sheet. No problem here.



2013/5/7 Anton Meixome <meixome@certima.net>

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




-- 
Sérgio Marques

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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.