https://bugs.freedesktop.org/show_bug.cgi?id=64367
Priority: medium
Bug ID: 64367
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: FORMATTING: Calc fails transforming galician month's
names in format DMY
Severity: normal
Classification: Unclassified
OS: All
Reporter: meix...@certima.net
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: unspecified
Component: Spreadsheet
Product: LibreOffice
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 the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
