Its better to keep it to one language.
I cant say how many times i have used bad words to describe that excel translates the formulas to your locale, i hope someone was fired for that decision.
Do you mean the function names? If so, then unfortunately, "Libre Office Calc" also suffers from the same disease.
Ok, to get that misconception out of the way:
Excel (and probably Calc) store formulas in both ways: locale and „original“ (english?)
And before you disagree: i know that for a fact, since i‘ve used both in my VBA code
If you don't believe me, do the following:
Fire up Excel
in A1 enter a Formula (doesn't matter which one, or if it returns something, but should be syntactically correct).
I entered
"=SUMMEWENN(F1:F7;"=Test")"
(german Excel)
Go to the VBA-Editor (ALT+F11)
In The project-Explorer double-click on that sheet, or the Workbook-Object
Paste this code there:
Sub main()
Debug.Print Worksheets(1).Range("A1").FormulaLocal
Debug.Print Worksheets(1).Range("A1").Formula
End Sub
With your Cursor inside that "Sub" hit F8 for single-stepping through the code
Call up your immediate Window with CTRL+G
You'll see something like
=SUMMEWENN(F1:F7;"=Test") --> Locale version
=SUMIF(F1:F7,"=Test") --> Original version
NOTE: Look closely at the Argument-Separators: The german locale uses semicolon, but internally Excel translates that to comma for the "original"
And the thing is: Assigning formulas from VBA-Code works both ways:
Assign to FormulaLocal if you want to use the "locale" Version
Assign to Formula if you want to use the "original", and i've used this to actually find out what the "locale" Formula is called, when i only could find the "original" during research