[Libreoffice-bugs] [Bug 128200] New: Wrong translations of formula function names and identifiers

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: erack at redhat.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191017/e188261a/attachment.html>