Checking translation of function names in Calc

Hi all,

If you want to check the translation of function names in Calc, Eike has
uploaded a document here:
https://bugs.documentfoundation.org/show_bug.cgi?id=93992

Some errors are also reported on the issue by Daniel. Thanks to both of
them :slight_smile:
Cheers
Sophie

Is there a way we can make sure these are not translated in Hebrew?

Yaron Shahrabani

<DevOps - Hebrew translator>

Hi Yaron

Is there a way we can make sure these are not translated in Hebrew?

Open the document and see what is translated and what's not :slight_smile:
If you don't want to have them translated, then just copy the source to
the translation in Pootle.
Cheers
Sophie

I see, thanks.

Yaron Shahrabani

<DevOps - Hebrew translator>

Hi all,

If you want to check the translation of function names in Calc, Eike has
uploaded a document here:
https://bugs.documentfoundation.org/show_bug.cgi?id=93992

Some errors are also reported on the issue by Daniel. Thanks to both of
them :slight_smile:
Cheers
Sophie

What about function names in Pivot tables? Croatian doesn't have translated any of the functions from that test file but when creating pivot tables functions when double click in data field are translated. They are probably not written in all caps so we miss them in Pootle (Sum > Zbroj).

Should that be treated as the rest of the functions or they have special status?

Kruno

Hi Krunose,

What about function names in Pivot tables? Croatian doesn't have translated
any of the functions from that test file but when creating pivot tables
functions when double click in data field are translated. They are probably
not written in all caps so we miss them in Pootle (Sum > Zbroj).

Those aren't strictly function names, but rather labels of (subtotal)
functions, to be picked from the dialog and also inserted to the
resulting pivot table as document content. (though overwritten if the
pivot table is refreshed using another UI language).

Should that be treated as the rest of the functions or they have special
status?

They're independent of the actual function names, though some look
similar. Likely to be translated. The list is:

    NC_("SCSTR_DPFUNCLISTBOX", "Sum"),
    NC_("SCSTR_DPFUNCLISTBOX", "Count"),
    NC_("SCSTR_DPFUNCLISTBOX", "Average"),
    NC_("SCSTR_DPFUNCLISTBOX", "Median"),
    NC_("SCSTR_DPFUNCLISTBOX", "Max"),
    NC_("SCSTR_DPFUNCLISTBOX", "Min"),
    NC_("SCSTR_DPFUNCLISTBOX", "Product"),
    NC_("SCSTR_DPFUNCLISTBOX", "Count (Numbers only)"),
    NC_("SCSTR_DPFUNCLISTBOX", "StDev (Sample)"),
    NC_("SCSTR_DPFUNCLISTBOX", "StDevP (Population)"),
    NC_("SCSTR_DPFUNCLISTBOX", "Var (Sample)"),
    NC_("SCSTR_DPFUNCLISTBOX", "VarP (Population)")

(that's in master, in 5.4 it's a StringArray SCSTR_DPFUNCLISTBOX with
ItemList

        < "Sum" ; Default ; > ;
        < "Count" ; Default ; > ;
        < "Average" ; Default ; > ;
        < "Median" ; Default ; > ;
        < "Max" ; Default ; > ;
        < "Min" ; Default ; > ;
        < "Product" ; Default ; > ;
        < "Count (Numbers only)" ; Default ; > ;
        < "StDev (Sample)" ; Default ; > ;
        < "StDevP (Population)" ; Default ; > ;
        < "Var (Sample)" ; Default ; > ;
        < "VarP (Population)" ; Default ; > ;

)

  Eike

Oh, I see. Thanks!.

This will help me re-check all of them again in Pootle.

Kruno