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
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!
Hi @boiconttms, 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 exactly
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")
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.
(In reply to Mike Kaganski from comment #6) > are there localisations that reassign some names > that are used for English function names? You never know.. and it's already hard enough that *one* localization does not translate two or more function names to the same localized name. Yes it happened. Yes it happens again. Such things when recompiling a formula can destroy the original meaning and at best delivers an error but worst silently calculates something different. So *either* one language *or* the other (maybe even per cell input toggled by whatever) but not a mix of both.
*** Bug 153239 has been marked as a duplicate of this bug. ***