Issue 121664 - Wrong translation for Calc functions in pt-BR
Summary: Wrong translation for Calc functions in pt-BR
Status: CONFIRMED
Alias: None
Product: Native-Lang
Classification: NLC
Component: pt-br (show other issues)
Version: 3.4.1
Hardware: PC All
: P3 Major
Target Milestone: 3.4.1
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2013-01-23 18:19 UTC by Nathalio
Modified: 2013-01-29 18:07 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description Nathalio 2013-01-23 18:19:43 UTC
The formula DIA.DA.SEMANA, (Portuguese version of WEEKDAY) is disabled, or not implemented in AOO 3.4.1. Even if I open a spreadsheet with this formula, it is not recognized and left blank.
When I add a new formula using the wizard, the words "dia da semana" appears where the correct formula should be, but it is not possible to use it.
Finally, when i write =dia da semana(A2), Calc returns Error 509.
Comment 1 Ariel Constenla-Haile 2013-01-23 22:42:16 UTC
This is http://svn.apache.org/viewvc/openoffice/trunk/extras/l10n/source/pt-BR/localize.sdf?revision=1413471&view=markup#l934

formula source\core\resource\core_resource.src 0 string RID_STRLIST_FUNCTION_NAMES SC_OPCODE_GET_DAY_OF_WEEK 0 pt-BR Dia da semana 20120314 15:13:33

On Pootle:

https://translate.apache.org/pt_BR/OOo_34/translate.html?unit=5903124
Comment 2 Nathalio 2013-01-24 11:33:56 UTC
Thanks for your quick reply.
I found the same bug for formula MONTH (translated as Mês).
But as a user, is there a way to fix this?
Comment 3 Ariel Constenla-Haile 2013-01-24 12:30:25 UTC
(In reply to comment #2)
> Thanks for your quick reply.
> I found the same bug for formula MONTH (translated as Mês).

This is http://svn.apache.org/viewvc/openoffice/trunk/extras/l10n/source/pt-BR/localize.sdf?revision=1413471&view=markup#l705

formula source\core\resource\core_resource.src 0 string RID_STRLIST_FUNCTION_NAMES SC_OPCODE_GET_MONTH	0 pt-BR Mês 20120314 15:13:33

On Pootle:

https://translate.apache.org/pt_BR/OOo_34/translate.html?unit=5902895


> But as a user, is there a way to fix this?

May be there is some way of using the English names, at least when entering the function in the function input line. I'm not sure if this is possible, I will try to find someone in the know, on the development mailing list, and let you know.
Comment 4 Ariel Constenla-Haile 2013-01-24 12:33:02 UTC
Adapting the subject: up to now, the bug is present in WEEKDAY() and MONTH() translations.
Comment 5 Ariel Constenla-Haile 2013-01-24 15:07:10 UTC
String should be translated as before, for example revision 1162288 of trunk/extras/l10n/source/pt-BR/localize.sdf :

* DIA.DA.SEMANA 

http://svn.apache.org/viewvc/openoffice/trunk/extras/l10n/source/pt-BR/localize.sdf?revision=1162288&view=markup#l48685

formula source\core\resource\core_resource.src 0 string RID_STRLIST_FUNCTION_NAMES SC_OPCODE_GET_DAY_OF_WEEK 0 pt-BR DIA.DA.SEMANA 2002-02-02 02:02:02

* MES

http://svn.apache.org/viewvc/openoffice/trunk/extras/l10n/source/pt-BR/localize.sdf?revision=1162288&view=markup#l48456

formula source\core\resource\core_resource.src 0 string RID_STRLIST_FUNCTION_NAMES SC_OPCODE_GET_MONTH 0 pt-BR MES 2002-02-02 02:02:02
Comment 6 Andrea Pescetti 2013-01-24 22:47:03 UTC
We still accept the (officially unsupported!) OOO_CALC_USE_ENGLISH_FORMULAS environment variable. See http://wiki.openoffice.org/wiki/Environment_Variables#Environment_variables_for_users

Setting OOO_CALC_USE_ENGLISH_FORMULAS in the environment that calls OpenOffice will force the use of English names.

Note that this won't be good at all: for example, running
$ OOO_CALC_USE_ENGLISH_FORMULAS=1 soffice
(where "soffice" is OpenOffice 3.4.1 Italian)

leads to:
- f(x) icon still providing a list of Italian names, which are then not accepted
- the sum icon providing =SOMMA() (Italian) instead of =SUM() (the English version that would work)

but still this might be a workaround.

Otherwise, install the en-us language pack over the pt-br version and switch to the English interface when needed.
Comment 7 Nathalio 2013-01-25 01:20:55 UTC
(In reply to comment #5)
> String should be translated as before, for example revision 1162288 of
> trunk/extras/l10n/source/pt-BR/localize.sdf :
> 

That's right, just like BrOffice and LibreOffice has this translations working perfect.
I hope that this revision may be included in new version.
Comment 8 Nathalio 2013-01-25 01:25:05 UTC
(In reply to comment #6)
> We still accept the (officially unsupported!) OOO_CALC_USE_ENGLISH_FORMULAS
> environment variable. See
> http://wiki.openoffice.org/wiki/
> Environment_Variables#Environment_variables_for_users
> 
> Setting OOO_CALC_USE_ENGLISH_FORMULAS in the environment that calls
> OpenOffice will force the use of English names.
> 
> Note that this won't be good at all: for example, running
> $ OOO_CALC_USE_ENGLISH_FORMULAS=1 soffice
> (where "soffice" is OpenOffice 3.4.1 Italian)
> 
> leads to:
> - f(x) icon still providing a list of Italian names, which are then not
> accepted
> - the sum icon providing =SOMMA() (Italian) instead of =SUM() (the English
> version that would work)

Not only that, but the comma and dot in decimal notation are switched between English and other languages.
 
> but still this might be a workaround.
> 
> Otherwise, install the en-us language pack over the pt-br version and switch
> to the English interface when needed.

I will test this approach next week and update this entry
Comment 9 Marcus 2013-01-25 19:17:10 UTC
(In reply to comment #3)
> > But as a user, is there a way to fix this?
> 
> May be there is some way of using the English names, at least when entering
> the function in the function input line. I'm not sure if this is possible, I
> will try to find someone in the know, on the development mailing list, and
> let you know.

I've tried with AOO 3.4.1 German on Windows:

German: =SUMME(A1:B1) is recognized
English: =SUM(A1:B1) is not recognied

HTH
Comment 10 Claudio F Filho 2013-01-29 17:22:08 UTC
Both strings was changed to "DIA.DA.SEMANA" and "MÊS".
Comment 11 Nathalio 2013-01-29 18:07:07 UTC
(In reply to comment #10)
> Both strings was changed to "DIA.DA.SEMANA" and "MÊS".

Thanks Claudio, this changes will apply to next version, right?

In addition, I installed the English Language Pack like Andrea (comment #6) said, and it worked, but to change languages I must restart OO.

Thanks everybody for your attention.