Bug 50489

Summary:	NL-version: some calc functions not available in English
Product:	LibreOffice	Reporter:	Winfried Donkers <osc>
Component:	Localization	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	kohei, mondane.woodworker, timar74
Priority:	medium
Version:	3.5.3 release
Hardware:	Other
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:

Description Winfried Donkers 2012-05-29 23:25:47 UTC

The following functions can be called with the Dutch name only; the English name is not available:
EOMONTH (LAATSTE.DAG)
SQRTPI (WORTEL.PI)
WORKDAY (WERKDAG)
YEARFRAC (JAAR.DEEL)

steps to show the problem:
-open calc
-set options for calc-formula 'use English function names' (gebruik engelse functienamen) to checked
-open function wizard and locate the above functions

Comment 1 Andras Timar 2012-06-29 08:19:31 UTC

Why do you have these function names localized in the first place? These are not core functions, but addin functions. AFAIK they are not localized in Microsoft Excel (Analysis Toolpak). 

I cc Kohei, who developed the 'use English function names' feature, just in case.

Comment 2 Winfried Donkers 2012-07-01 22:54:35 UTC

(In reply to comment #1)


@Andras: When LibreOffice is installed in a non english environment, such as Dutch, not only yhe UI but all calc formulas are translated to dutch as well. (Being a developer, that is not my personal choice). When you set the formulas to the english names, some formulas are not reverted to english. This bug is entered from a user perspective, so knowledge of core and addin functions is not assumed.

I am very glad with the 'use English function names' option.
I shudder at the thought that I should have to use dutch names for C)++) or SQL commands and reserved words...

Comment 3 Kohei Yoshida 2012-07-02 10:43:07 UTC

I would say this request is valid.  It would be nice to be consistent with the add-in functions too.

Comment 4 mondane.woodworker 2012-09-07 07:51:08 UTC

This problem still exists in version 3.6.1.2 (Build-id: e29a214), ie for the function 'WEKEN'. It should be 'WEEKS' in English (See http://help.libreoffice.org/Calc/Add-in_Functions ).

For now, the option 'Use English function names' isn't usefull since the function names are now Dutch and English.

Comment 5 Winfried Donkers 2014-02-14 15:12:04 UTC


*** This bug has been marked as a duplicate of bug 50118 ***