You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2013/05/14 01:18:41 UTC
[Bug 122306] New: Calc fails transforming galician month's names in
format DMY
https://issues.apache.org/ooo/show_bug.cgi?id=122306
Bug ID: 122306
Issue Type: DEFECT
Summary: Calc fails transforming galician month's names in
format DMY
Classification: Application
Product: Calc
Version: AOO 3.4.1
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: open-import
Assignee: issues@openoffice.apache.org
Reporter: meixome@certima.net
CC: issues@openoffice.apache.org
Problem description:
Calc not recognize month's names in galician when importing a list of ítems.
Only recognize the names been the same for english. In import dialog you can
set the language for import but Calc is not interpreting correctly.
Steps to reproduce it:
1. Look at this serie
1 Xan, 2012
2 Feb, 2012
3 Mar, 2012
4 Abr, 2012
5 Mai, 2012
6 Xuñ, 2012
7 Xul, 2012
You have the items in a txt document, without formating. Then, you copy the
serie and paste it inside a cell of Calc. Calc open import dialog. Set the
galician language. Set the type of data fron «Standard» to DMA (interface in
english=DMY).
Current behavior:
1 Xan, 2012
02/02/12
03/03/12
4 Abr, 2012
5 Mai, 2012
6 Xuñ, 2012
7 Xul, 2012
My actual default format for data is DD/MM/YY
Expected behavior:
01/01/12
02/02/12
03/03/12
04/04/12
05/05/12
06/06/12
07/07/12
I was testing if this is reproducible in spanish or portuguese and not. It's
only for galician names and in various versions. I don't know when this
behavior appeared.
Otherwise, I find a related question and I think this would be improved.
If you have a list with errors in names (e.g. if you merge names in different
languages or having misspelled words or the abreviations are inexact) Calc
accept if matching the english forms.
e.g.
Serie en portuguese with errors
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 admits in english "Abr" or "Mai" but
accepts "Feb" or "May" in portuguese.
What's the improve?
If you set the import language to "x" for a dataset Calc must refuse perform a
inaccurate filter with other language.
Of course, the bug is prior!
Operating System: All
Version: unspecified
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 122306] Calc fails transforming galician month's names in
format DMY
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122306
Ariel Constenla-Haile <ar...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|CONFIRMED |ACCEPTED
Assignee|issues@openoffice.apache.or |arielch@apache.org
|g |
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 122306] Calc fails transforming galician month's names in
format DMY
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122306
Ariel Constenla-Haile <ar...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
CC| |arielch@apache.org
Ever confirmed|0 |1
--- Comment #1 from Ariel Constenla-Haile <ar...@apache.org> ---
(In reply to comment #0)
> I was testing if this is reproducible in spanish or portuguese and not. It's
> only for galician names and in various versions. I don't know when this
> behavior appeared.
There is a bug in the locale data, abbreviate month names are using a dot:
http://svn.apache.org/viewvc/incubator/ooo/trunk/main/i18npool/source/localedata/data/gl_ES.xml?revision=1306262&view=markup#l241
After removing the dots, copy
1 Xan, 2012
2 Feb, 2012
3 Mar, 2012
4 Abr, 2012
5 Mai, 2012
6 Xuñ, 2012
7 Xul, 2012
paste into Calc as plain text. Set locale to Galician and date format as DMY,
you get
01/01/12
02/02/12
03/03/12
04/04/12
05/05/12
06/06/12
07/07/12
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 122306] Calc fails transforming galician month's names in
format DMY
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122306
Ariel Constenla-Haile <ar...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|ACCEPTED |RESOLVED
Resolution|--- |FIXED
--- Comment #8 from Ariel Constenla-Haile <ar...@apache.org> ---
Fixed on trunk
--
You are receiving this mail because:
You are on the CC list for the bug.
[Bug 122306] Calc fails transforming galician month's names in
format DMY
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122306
--- Comment #5 from Ariel Constenla-Haile <ar...@apache.org> ---
(In reply to comment #4)
> (In reply to comment #3)
> > @Antón: can you try with abbreviated day names? They have the same bug (a
> > dot at the end), but I cannot confirm this without installing a language
> > pack (and I'm lazy to do this right now).
>
> I can reproduce it in Writer, no need to install a langpack:
>
> Insert a data field, an apply the following format:
I meant a date field, from Insert - Fields - Date
--
You are receiving this mail because:
You are on the CC list for the bug.
[Bug 122306] Calc fails transforming galician month's names in
format DMY
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122306
Antón Méixome <me...@certima.net> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |meixome@certima.net
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 122306] Calc fails transforming galician month's names in
format DMY
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122306
--- Comment #3 from Ariel Constenla-Haile <ar...@apache.org> ---
@Antón: can you try with abbreviated day names? They have the same bug (a dot
at the end), but I cannot confirm this without installing a language pack (and
I'm lazy to do this right now).
--
You are receiving this mail because:
You are on the CC list for the bug.
[Bug 122306] Calc fails transforming galician month's names in
format DMY
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122306
Ariel Constenla-Haile <ar...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Component|open-import |localedata
Product|Calc |Internationalization
Target Milestone|--- |AOO 4.0
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 122306] Calc fails transforming galician month's names in
format DMY
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122306
Antón Méixome <me...@certima.net> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |data_loss, numbering
Latest|--- |AOO 3.4.0
Confirmation on| |
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 122306] Calc fails transforming galician month's names in
format DMY
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122306
--- Comment #2 from Ariel Constenla-Haile <ar...@apache.org> ---
(In reply to comment #0)
> I don't know when this behavior appeared.
It's been there since the beginning:
http://hg.services.openoffice.org/OOO340/log/c904c1944462/i18npool/source/localedata/data/gl_ES.xml
--
You are receiving this mail because:
You are on the CC list for the bug.
[Bug 122306] Calc fails transforming galician month's names in
format DMY
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122306
--- Comment #4 from Ariel Constenla-Haile <ar...@apache.org> ---
(In reply to comment #3)
> @Antón: can you try with abbreviated day names? They have the same bug (a
> dot at the end), but I cannot confirm this without installing a language
> pack (and I'm lazy to do this right now).
I can reproduce it in Writer, no need to install a langpack:
Insert a data field, an apply the following format:
Spanish (Argentina)
NN DD/MMM AA
lun 13/may 13
Emglish (USA)
NN DD/MMM YY
Mon 13/May 13
Galician
NN DD/MMM YY
lun. 13/mai 13
As seen, in Galician there is a dot in lun. but would belong to the format
"NN. DD/MMM YY"
--
You are receiving this mail because:
You are on the CC list for the bug.
[Bug 122306] Calc fails transforming galician month's names in
format DMY
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122306
--- Comment #6 from Ariel Constenla-Haile <ar...@apache.org> ---
Created attachment 80679
--> https://issues.apache.org/ooo/attachment.cgi?id=80679&action=edit
Writer document with Date field with format NN DD/MMM YY
In 3.4.1:
Format: NN DD/MMM YY
Locale: Galician
lun. 13/mai. 13
After the fix:
Format: NN DD/MMM YY
Locale: Galician
lun 13/mai 13
--
You are receiving this mail because:
You are on the CC list for the bug.
[Bug 122306] Calc fails transforming galician month's names in
format DMY
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=122306
--- Comment #7 from SVN Robot <sv...@dev.null.org> ---
"arielch" committed SVN revision 1482157 into trunk:
i122306 - Remove dot from abbreviate day and month names in Galician
--
You are receiving this mail because:
You are on the CC list for the bug.