https://bugs.documentfoundation.org/show_bug.cgi?id=128200
Bug ID: 128200
Summary: Wrong translations of formula function names and
identifiers
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Localization
Assignee: [email protected]
Reporter: [email protected]
Created attachment 155069
--> https://bugs.documentfoundation.org/attachment.cgi?id=155069&action=edit
l10n-wrong-function-names-1.txt function names
There's quite some mess in general in the formula module's
translations. Specifically, names in
msgctxt "RID_STRLIST_FUNCTION_NAMES":
* Translated function names MUST NOT contain spaces, parentheses,
hyphens, or anything else that would be an operator in
spreadsheet formula context. Function names may only contain
letters (of any alphabet or script of course, not just ASCII) or
digits or '.' dot or '_' underscore, and must start with
a letter.
* Attached is l10n-wrong-function-names-1.txt that hopefully
caught all, created by the command line
grep -E -A1 'msgid "[A-Z0-9._]+"'
translations/source/*/formula/messages.po|grep -B1 'msgstr ".*[-+*/ ()~]'
(all on one line) also repeated on top of the attached list.
* Translated identifiers like "#All" or "#Headers" if they start
with a '#' hash character MUST start with a '#' character also
in the translation, this is vital to recognize them as table
reference identifiers (or error constants possibly).
* Attached is l10n-wrong-function-names-2.txt that hopefully
caught all, created by the command line
grep -E -A1 'msgid "#' translations/source/*/formula/messages.po | grep -B1
'msgstr "[^#"]'
(all on one line) also repeated on top of the attached list.
While these wrong translations display correctly when loading
a document, any attempt to compile such formula expression that does not
meet the criteria will fail.
PLEASE, check the attached lists for your language's translation (the
list is sorted by language codes between translations/source/ and
/formula/messages.po) and correct errors ASAP; corrections should also
end up in the 6-3 branch, Cloph probably can help with that.
Also, (possibly after any change) please load the 6.2 attachment
https://bugs.documentfoundation.org/attachment.cgi?id=150855 of
https://bugs.documentfoundation.org/show_bug.cgi?id=93992 in your
translated UI, to check for duplicated function names.
Thanks
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
