Bug 50489 - NL-version: some calc functions not available in English
Summary: NL-version: some calc functions not available in English
Status: RESOLVED DUPLICATE of bug 50118
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Localization (show other bugs)
Version:
(earliest affected)
3.5.3 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-05-29 23:25 UTC by Winfried Donkers
Modified: 2014-02-14 15:12 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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 ***