Apache OpenOffice (AOO) Bugzilla – Issue 121664
Wrong translation for Calc functions in pt-BR
Last modified: 2022-07-01 19:06:10 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.
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
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?
(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.
Adapting the subject: up to now, the bug is present in WEEKDAY() and MONTH() translations.
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
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.
(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.
(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
(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
Both strings was changed to "DIA.DA.SEMANA" and "MÊS".
(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.
Both functions "DIA.DA.SEMANA" and "MÊS" work as of version 4.0.0 Issue resolved, can be closed.
Closing as fixed per comment 12