Issue 109407 - [ES] Duplicate Spanish translation name of formulas
Summary: [ES] Duplicate Spanish translation name of formulas
Alias: None
Product: Internationalization
Classification: Code
Component: ui (show other issues)
Version: OOo 3.2
Hardware: All All
: P2 Trivial (vote)
Target Milestone: ---
Assignee: ivo.hinkelmann
QA Contact: issues@l10n
Keywords: regression, release_blocker
: 109393 110468 (view as issue list)
Depends on:
Reported: 2010-02-18 14:16 UTC by gorcci
Modified: 2013-08-07 15:02 UTC (History)
12 users (show)

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

This patch should fix the issue. (2.36 KB, patch)
2010-02-22 10:58 UTC, ooo
no flags Details | Diff
ES Calc functions 3.1.1 (30.47 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-03-01 16:02 UTC, rafaella.braconi
no flags Details
ES Calc functions 3.2 (30.88 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-03-01 16:03 UTC, rafaella.braconi
no flags Details
New patched and gsichecked SDF file for spanish locale (3.44 MB, application/x-gzip)
2010-03-02 19:51 UTC, santiago.bosio
no flags Details
Diff patch for formula/source/core/resource.po (1.06 KB, patch)
2010-03-04 09:54 UTC, santiago.bosio
no flags Details | Diff
ES fixes for 3.2.1 (67.53 KB, text/plain)
2010-03-22 15:30 UTC, rafaella.braconi
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description gorcci 2010-02-18 14:16:52 UTC
Terminology Issue with some Calc formulas as they are all translated as BUSCAR()

Originally states as:
Search()   should be translated as buscar()
Find()     should be translated as encontrar()
Lookup()   should be translated as búsqueda()
Comment 1 ooo 2010-02-18 14:37:17 UTC
Not an i18n locale data issue, but translation instead.

@sba: please reassign as appropriate.

I assume this is about the Spanish [es] translation, would had been nice if the
submitter indicated that.

Note: this renders 2 of the 3 Calc spreadsheet functions SEARCH(), FIND() and
LOOKUP() unusable in a Spanish localization and may break existing documents if
formulas are edited and result being compiled into a different function.
Comment 2 Risto Jääskeläinen 2010-02-18 15:57:00 UTC
Not so that I can help much but I just checked creating two formulas one with
search() another with find() (which are names used also in Finnish Calc). Then I
change language to Spanish and both was named BUSCAR(). They can show correct
results but if I try to edit I get error #N/A.  Changing back to Finnish and
changing goes well.

So what er says about difficulties seems to be true. Correction of this error is
muchos importantes. Maybe it is good to advice not to use this version for
spreadsheets before corrections?
Comment 3 acolorado 2010-02-18 16:10:56 UTC
erminology Issue with some Calc formulas as they are all defined as BUSCAR()

Originally states as:

Should be translated as:
Hallar() - Busca un valor de texto dentro de otro sin reconocer mayusculas o
ENCONTRAR() - Busca un valor de texto dentro de otro tomando en cuenta las
mayusculas y minusculas.
BUSCAR() - Busca valores de una referencia o matriz.

Both Hallar() and ENCONTRAR() belongs to the "Texto" category. 

BUSCAR() belongs to the "Hoja de Calculo" category.
Comment 4 ooo 2010-02-19 11:43:03 UTC
@jza: Alexandro, the Spanish localization team will have to fix this for
OOo3.2.1, upping to P2. Maybe you can convince Pavel to build a new Spanish
install set and langpack for OOo3.2 from a patched l10n/source/es/localize.sdf

@md: or may Hamburg RE be willing to do so?
Comment 5 mdxonefour 2010-02-19 13:04:20 UTC
I will investigate what we can do here best.
Comment 6 rt 2010-02-22 09:47:12 UTC
Sorry, but from the description in this issue I am not sure what to change.
Grepping for BUSCAR in l10n/source/es/localize.sdf results in 35 ccurrences.
Could someone on the know please provide a patch?
Comment 7 ooo 2010-02-22 10:58:41 UTC
Created attachment 67975 [details]
This patch should fix the issue.
Comment 8 rafaella.braconi 2010-02-22 11:01:51 UTC
Hi, the the UI, please correct FIND, SEARCH and LOOKUP in the below files:
[ Spanish ] [ OO.o PO UI ] formula / source / core / resource.po 
[ Spanish ] [ OO.o PO UI ] sc / source / ui / src.po

In the Help the functions are also wrong (reflecting the UI). Corrections should
be made all over the HC2/scalc Help module.

Does this help?
Comment 9 ooo 2010-02-22 11:02:45 UTC
Note: The attached patch fixes the function names in formulas. It does not
change help content if there was any error.
Comment 10 rafaella.braconi 2010-02-22 11:04:04 UTC
Comment 11 rafaella.braconi 2010-02-22 11:21:45 UTC
Adding lang ID
Comment 12 oliver.bolte 2010-02-22 15:24:10 UTC
New installation sets have been built. I've checked a MacOSX version and it
looks good now.
This issue should be set to "fixed" after the modified localize.sdf has been
commited for OOO320_m13.
Comment 14 rafaella.braconi 2010-03-01 16:00:45 UTC
Santiago, Alexandro: I am attaching 2 Calc documents reporting all Cal functions
based on the 3.1.1 version and the 3.2 (new binaries so the duplicate names are
With the Edit - Compare Document... - function it's quite easy to detect what
has been changed in the 3.2 version. Can you please review and confirm that all
changes made in the Calc functions are correct? Thx!
Comment 15 rafaella.braconi 2010-03-01 16:02:08 UTC
Created attachment 68084 [details]
ES Calc functions 3.1.1
Comment 16 rafaella.braconi 2010-03-01 16:03:09 UTC
Created attachment 68085 [details]
ES Calc functions 3.2
Comment 17 santiago.bosio 2010-03-02 19:47:19 UTC

Sadly, we have confirmed new duplications:
BDDESVEST, BDDESVESTP and REEMPLAZAR are also duplicated, so last builds didn't
fix this issue.

OTOH, changes seem to have been done directly on the SDF, and thus, all
modifications made to Pootle that improved the bad UI translations on other
areas were not imported, those errors constitute a show-stopper for us.

That was the reason why we used the builds from Pavel instead of the vanilla
ones from Sun Germany, because those weren't risky changes, just corrections on
UI strings. But this bigger problem of the duplicated names wasn't detected
until distribution, regretfully.

I will attach a patched SDF file to this issue, if a new build can be done. If
not, my personal opinion (that is different to the opinion of Alexandro) is to
take off all packages from distribution, because I think we can't distribute
them with this big error on formula names, nor with the bad UI translation.

Best regards,

Comment 18 santiago.bosio 2010-03-02 19:51:22 UTC
Created attachment 68120 [details]
New patched and gsichecked SDF file for spanish locale
Comment 19 rafaella.braconi 2010-03-03 16:10:33 UTC
Santiago: it's really too bad to hear that there are more duplicates. How did it
happen? The calc functions were correct in the 3.1.1. I see you have provided a
full SDF file. I would avoid to do a complete import again. Can you provide only
a patch, an sdf file containing the source/target strings which you have fixed?
Also, did you carry out the changes in Pootle as well? Thx!
Comment 20 santiago.bosio 2010-03-04 09:53:21 UTC
Rafaella: Yes, changes were uploaded to Pootle. I'm sending a diff patch for the
formula/source/core/resource.po file.

Best regards,

Comment 21 santiago.bosio 2010-03-04 09:54:29 UTC
Created attachment 68142 [details]
Diff patch for formula/source/core/resource.po
Comment 22 mariosv 2010-03-21 01:25:50 UTC
Es una grave regresión, muy preocupante desde el punto de vista de usuario. Y
debería estar claramente indicado para que este lo conozca antes de utilizar la
Es mejor una vez colorado que un ciento amarillo.
No informar con claridad es inaceptable.

It is a serious regression, concern from the user point of view. And it should
be clearly marked to know before using the version.
In Spanish we say, once red is better than a hundred yellow.
Failure to report clearly, is unacceptable.
Comment 23 santiago.bosio 2010-03-22 14:13:16 UTC
*** Issue 109393 has been marked as a duplicate of this issue. ***
Comment 24 rafaella.braconi 2010-03-22 15:27:19 UTC
Reported changes are accepted and will be integrated. Please see attached .sdf
containing all changes we will integrate for your reference.
Comment 25 rafaella.braconi 2010-03-22 15:30:46 UTC
Created attachment 68486 [details]
ES fixes for 3.2.1
Comment 26 rafaella.braconi 2010-03-22 15:31:30 UTC
Comment 27 ooo 2010-03-29 20:56:41 UTC
*** Issue 110468 has been marked as a duplicate of this issue. ***
Comment 28 thorsten.ziehm 2010-06-14 15:01:43 UTC
I clean up the open issues for OOo 3.2.1. This release is final and released. Is
this issue still valid? Is something missing or can this issue be closed with
resolved/fixed? Please do so or change the target of this issue accordingly.
Comment 29 ivo.hinkelmann 2010-06-14 15:38:11 UTC
those had been fixed in pootle?!?
Comment 30 acolorado 2010-06-14 16:01:43 UTC
yeah please close
Comment 31 ivo.hinkelmann 2010-06-14 16:10:24 UTC
Comment 32 ivo.hinkelmann 2010-06-14 16:10:49 UTC