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.
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!
the option is there from a long time ago.
Menu/Tools/Options/Libreoffice calc/Formula - Formula Options - Use English function names.
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
Then please reopen the bug.
(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
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?
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")
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.