Download it now!
Bug 92543 - add ability to use non-native formulas (such as using English formulas in Italian locale)
Summary: add ability to use non-native formulas (such as using English formulas in Ita...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: low enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-UX Cell-Formula
  Show dependency treegraph
 
Reported: 2015-07-04 15:43 UTC by boicottms
Modified: 2020-08-13 03:42 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description boicottms 2015-07-04 15:43:59 UTC
I use calc in italian, an I use italian locale for formulas, but sometimes it would be easier to use english (such when copying a formula from the web) directly instead of searching the translation. 
So I would like the ability to use a symbol to tell to calc that I'm using english.
In Autocad there's something similar when inserting commands from the keyboard: you use an underscore to tell it that you're using english.
I do not want to change the language for all the formulas.
Thank you
Comment 1 Joel Madero 2015-07-04 16:00:54 UTC
Seems reasonable although it's not likely to be implemented soon. I believe that the ODF committee would have to approve something like this and it would break interoperability with our competitor when saving in their format.

That being said, valid request - just no clue if or when it would be implemented.

Thanks for the suggestion!
Comment 2 m.a.riosv 2015-07-04 21:24:41 UTC
Hi @boiconttms,

the option is there from a long time ago.

Menu/Tools/Options/Libreoffice calc/Formula - Formula Options - Use English function names.
Comment 3 Joel Madero 2015-07-04 21:37:17 UTC
But that option is an "either/or" isn't it? If you select it aren't you forced to only use English formulas? I think the request is to allow simultaneous use
Comment 4 m.a.riosv 2015-07-04 21:40:54 UTC
Then please reopen the bug.
Comment 5 boicottms 2015-07-06 19:09:38 UTC
(In reply to Joel Madero from comment #3)
> But that option is an "either/or" isn't it? If you select it aren't you
> forced to only use English formulas? I think the request is to allow
> simultaneous use

exactly
Comment 6 Mike Kaganski 2019-04-15 21:09:04 UTC
I'd say it would be nice to allow both sets of function names (localized *and* English) simultaneously, without any decorations (i.e., for Russian locale, I's like to be able to use both "=SUM(1;2;3)" and "=СУММА(1;2;3)") - is there some problem here? are there localisations that reassign some names that are used for English function names?
Comment 7 Mike Kaganski 2019-04-15 21:24:37 UTC
Or alternative suggestion: add a button to left of formula bar, to toggle English/localized names (=shortcut to the setting from comment 2, which would allow doing that "on the fly")
Comment 8 boicottms 2019-04-18 14:52:37 UTC
sample solution:
in AutoCAD you nomally use localized commands, but just adding "_" at the beginning it understands english. This is also foundamental to easilly write macros and scripts that are language agnostic.