Issue 91569 - formula names shouldn't be translated
Summary: formula names shouldn't be translated
Status: CLOSED DUPLICATE of issue 38765
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 2.4.1
Hardware: PC Windows XP
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: requirements
QA Contact: issues@sc
Depends on:
Reported: 2008-07-11 10:13 UTC by sophia
Modified: 2009-10-10 17:30 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

Property list for environment variable, put in ~/.MacOSX/ (250 bytes, text/xml)
2009-08-13 23:46 UTC, ovvldc
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description sophia 2008-07-11 10:13:49 UTC
I'm using Microsoft Excel with several language configuration.

I may be lost if the formula name would change each time as it is with OpenOffice.

This is a stopper which prevents me to switch to OpenOffice.
Comment 1 michael.ruess 2008-07-11 12:53:57 UTC
Changed to "Spreadsheet" component.
Comment 2 oc 2008-07-15 10:43:09 UTC
reassigning features and enhancements to user which
will be the default owner for those tasks (was introduced some time ago)
Comment 3 ovvldc 2009-08-11 12:54:05 UTC
It would be really nice if there were some way of specifying the language used
for formulae separately from the interface language. Default would be to follow
the language of the whole interface.

The underlying idea is that a change in interface language is easy to adapt to
(if you know the language), being passive understanding of the menu words and such.

In contrast, changing the formula language is similar to changing the syntax of
a programming language, because someone writing spreadsheets will be thinking
about formulae with the familiar names.

Given that the resources already exist for switching languages, decoupling UI
and formulae languages should be fairly trivial, depending on the number of
places where this preference is polled.
Comment 4 Regina Henschel 2009-08-11 16:34:30 UTC
You might try the environment variable OOO_CALC_USE_ENGLISH_FORMULAS.
Comment 5 ovvldc 2009-08-13 23:45:59 UTC
With some help from the folks at, I found a way to use the
environment variable for a Mac.

Add the attached file to ~/.MacOSX/
Comment 6 ovvldc 2009-08-13 23:46:49 UTC
Created attachment 64147 [details]
Property list for environment variable, put in ~/.MacOSX/
Comment 7 timar74 2009-10-07 19:37:35 UTC
I think this issue is duplicate of issue #38765

*** This issue has been marked as a duplicate of 38765 ***
Comment 8 Mechtilde 2009-10-10 17:30:03 UTC
duplicate -< closed