Bug Hunting Session
Bug 93992 - Typos in Calc function names and error codes, test documents for different releases, load to check localized versions.
Summary: Typos in Calc function names and error codes, test documents for different re...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Localization (show other bugs)
Version:
(earliest affected)
5.0.0.5 release
Hardware: Other All
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-09-07 14:26 UTC by Daniel Rentz
Modified: 2019-05-29 12:19 UTC (History)
10 users (show)

See Also:
Crash report or crash signature:


Attachments
Test document for function translations (32.24 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-09-09 07:46 UTC, Daniel Rentz
Details
Test document for function translations in 5.1 (29.21 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-06-29 16:54 UTC, Eike Rathke
Details
Test document for function translations in 5.2 (29.57 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-06-29 17:06 UTC, Eike Rathke
Details
Test document for function name translations in 5.4 (29.61 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-09-04 18:29 UTC, Eike Rathke
Details
Test document for function name translations in 5.4 (29.24 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-09-04 18:35 UTC, Eike Rathke
Details
Test document for function name translations in 6.2 (29.58 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-04-18 13:58 UTC, Eike Rathke
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Daniel Rentz 2015-09-07 14:26:48 UTC
The translations of Calc functions and error codes contain a few typos:


Arabic UI:
- The functions AVERAGEIF, GAMMA, RATE are translated to Arabic (but none of the other functions). Arabic should consistently use English function names.


French UI:
- The functions WORKDAY and WORKDAY.INTL have both been translated to "SERIE.JOUR.OUVRE".


Swedish UI:
- The error code #N/A has been translated to "#Saknas" which is not upper-case as all other error codes (in all languages).


Dutch UI:
- The functions GAMMA.INV and GAMMAINV have been translated to "GAMMA.INV".
- The functions NORM.INV and NORMINV have been translated to "NORM.INV".
- The functions T.INV and TINV have been translated to "T.INV".


Portuguese (Portugal) UI:
- The functions ERROR.TYPE and ERRORTYPE have been translated to "TIPO.ERRO".
(no such problem in pt_BR though).


Romanian UI:
- The functions IFERROR and ISERROR have been translated to "ISERROR" (ouch!).
Comment 1 Jacques Guilleron 2015-09-07 14:53:00 UTC
Right for the french UI, Daniel,

This was seen a couple days ago, and corrected now.
Second function SERIE.JOUR.OUVRE was renamed SERIE.JOUR.OUVRE.INTL
and will be available in the master and next LO 4.4 and 5.0.

I don't knows how you proceeded to detect them, but will be happy to learn a bit more about.
Comment 2 Julien Nabet 2015-09-07 19:34:05 UTC
I checked Dutch and Portuguese on Pootle server (eg https://translations.documentfoundation.org/pt/libo_ui/translate/#search=ERRORTYPE&sfields=source,target), I confirm the pb.

Sophie/Adolfo: thought you might be interested in this one. Should we cc the different language teams or should we just try to fix this in our brand new Pootle server? (or perhaps another idea on mind?)
Comment 3 Adolfo Jayme 2015-09-07 20:27:47 UTC
Julien, this is best tackled by each language team. I will send a message to the l10n list to let them know about this.
Comment 4 Niklas Johansson 2015-09-08 07:30:28 UTC
I can confirm the Swedish part and have now made the change in Pootle.
Thanks for the report.
Comment 5 Daniel Rentz 2015-09-09 07:46:06 UTC
@Jacques, I have built a test document to check the translated strings used in formulas. I will attach this document to this issue. Feel free to reuse it as you want, and to forward it to the other l10n teams (I did not check all locales supported in LO by myself).
Comment 6 Daniel Rentz 2015-09-09 07:46:49 UTC
Created attachment 118542 [details]
Test document for function translations
Comment 7 Daniel Rentz 2015-09-09 07:51:32 UTC
The test document contains a column with formulas using all functions supported in LO 5.0, and another column that extracts the translated function names using the FORMULA() function. Just open the document with a specific UI language, and it will show the translated function names.
Comment 8 Cor Nouws 2015-09-13 17:41:29 UTC
(In reply to Daniel Rentz from comment #6)
> Created attachment 118542 [details]
> Test document for function translations

Thanks! Dutch strings corrected.
Comment 9 Julien Nabet 2016-06-25 16:24:47 UTC
Nagy: thought you might be interested for Romanian part
Adriano: thought you might be interested for Portuguese part

For Arabic part, email declared in this page https://wiki.documentfoundation.org/Language_Teams doesn't seem to work.
Comment 10 Adriano Afonso 2016-06-25 17:20:04 UTC
Julian Thanks
Awesome. Correct translation.
Comment 11 Ákos 2016-06-26 09:59:47 UTC
Thanks.
Correct translations (LO-50-UI, LO-51-UI, LO-Master-UI).
Comment 12 Julien Nabet 2016-06-26 10:53:01 UTC
Following Nagy and Adriano's feedback (thank you to them), there's still only Arabic UI to confirm.
Daniel: could you give an update with recent LO version? (last one is 5.1.4)
Comment 13 Daniel Rentz 2016-06-28 13:32:42 UTC
Arabic seems to work as expected in the meantime, all function names are in English now. The only difference is that the English "WEEKNUM" has been translated to "ISOWEEKNUM".
Comment 14 Eike Rathke 2016-06-29 16:54:42 UTC
Created attachment 125986 [details]
Test document for function translations in 5.1

Note that for 5.1 four functions with *WEEKNUM* name exist in the UI, see https://wiki.documentfoundation.org/ReleaseNotes/5.1#Compatibility_with_ODF_1.2

ISOWEEKNUM
WEEKNUM
WEEKNUM_EXCEL2003
WEEKNUM_OOO

These when saved and reloaded with 5.1 are mapped to

ISOWEEKNUM
WEEKNUM
WEEKNUM
ISOWEEKNUM

so unfortunately updating the attached document accordingly with all four function names doesn't help.

However, I added ISOWEEKNUM. And disabled regular expressions so a . dot in the function name doesn't lead to duplicates anymore ;-)
Comment 15 Eike Rathke 2016-06-29 17:06:19 UTC
Created attachment 125987 [details]
Test document for function translations in 5.2

Updated with new function names in 5.2, see https://wiki.documentfoundation.org/ReleaseNotes/5.2#New_spreadsheet_functions
Comment 16 Daniel Rentz 2016-07-20 08:48:48 UTC
Korean language contains two typos (LO 5.1.4.2)

IFERROR is translated to ISERROR (collides with real ISERROR)
IFNA is translated to ISNA (collides with real ISNA)
Comment 17 Daniel Rentz 2016-07-20 08:57:29 UTC
Thai UI:
- The functions DAYSINMONTH, DAYSINYEAR, DELTA, DISC, ISLEAPYEAR, MONTHS, PRICE, WEEKS, WEEKSINYEAR, YEARS, YIELD are translated to Thai (but none of the other functions). Thai should consistently use English function names instead.
Comment 18 Julien Nabet 2016-07-23 08:48:03 UTC
Since I don't have more questions, I put it back to NEW
Comment 19 QA Administrators 2017-09-01 11:16:22 UTC Comment hidden (obsolete)
Comment 20 Eike Rathke 2017-09-04 18:29:02 UTC Comment hidden (obsolete)
Comment 21 Eike Rathke 2017-09-04 18:35:10 UTC
Created attachment 136017 [details]
Test document for function name translations in 5.4

Erroneously in the previous attachment included the *_ADD and *_EXCEL2003 names of duplicated functions that lead to duplicate names when reloaded. Removed.
Comment 22 QA Administrators 2018-09-07 02:43:39 UTC Comment hidden (obsolete)
Comment 23 Eike Rathke 2019-03-14 17:02:26 UTC
FWIW, as this is an ongoing check I'll come up with a new document updated for 6-2 function names.
Comment 24 Eike Rathke 2019-04-18 13:58:07 UTC
Created attachment 150855 [details]
Test document for function name translations in 6.2

New since 5.4:

6.0:
FINDB
REPLACEB
SEARCHB

6.2:
REGEX
Comment 25 Jacques Guilleron 2019-05-29 12:19:27 UTC
Hello Eike,

See "Bug 125501 - Several function names seems not translatable", solved now for French UI.

Jacques