Apache OpenOffice (AOO) Bugzilla – Issue 109407
[ES] Duplicate Spanish translation name of formulas
Last modified: 2013-08-07 15:02:22 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()
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.
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?
erminology Issue with some Calc formulas as they are all defined as BUSCAR() Originally states as: Search() Find() Lookup() Should be translated as: Hallar() - Busca un valor de texto dentro de otro sin reconocer mayusculas o minusculas 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.
@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?
I will investigate what we can do here best.
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?
Created attachment 67975 [details] This patch should fix the issue.
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?
Note: The attached patch fixes the function names in formulas. It does not change help content if there was any error.
.
Adding lang ID
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.
Patched installation sets have been distributed thru the mirror network. You can access the bits on the RC page at http://download.openoffice.org/all_rc.html#untested-full. For example: Windows at http://download.services.openoffice.org/files/extended/3.2.0rc5/OOo_3.2.0rc5_20100224_Win32Intel_install_wJRE_es.exe Linux RPM at http://download.services.openoffice.org/files/extended/3.2.0rc5/OOo_3.2.0rc5_20100224_LinuxIntel_install_wJRE_es.tar.gz MacOSX at http://download.services.openoffice.org/files/extended/3.2.0rc5/OOo_3.2.0rc5_20100224_MacOSXIntel_install_es.dmg and so on....
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 fixed)). 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!
Created attachment 68084 [details] ES Calc functions 3.1.1
Created attachment 68085 [details] ES Calc functions 3.2
Rafaella: 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, Santiago
Created attachment 68120 [details] New patched and gsichecked SDF file for spanish locale
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!
Rafaella: Yes, changes were uploaded to Pootle. I'm sending a diff patch for the formula/source/core/resource.po file. Best regards, Santiago
Created attachment 68142 [details] Diff patch for formula/source/core/resource.po
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 versión. 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.
*** Issue 109393 has been marked as a duplicate of this issue. ***
Reported changes are accepted and will be integrated. Please see attached .sdf containing all changes we will integrate for your reference.
Created attachment 68486 [details] ES fixes for 3.2.1
reassining
*** Issue 110468 has been marked as a duplicate of this issue. ***
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.
those had been fixed in pootle?!?
yeah please close
closing