| A | B |
|------|------|
| 1 | 2 |
| 2 | 4 |
| 3.1 | 6,1 |
| 4 | 8 |
| SUM^ | SUM^ |
What happens
In column A the calculation is correct but 3.1 is in the wrong locale notation.
In column B 6,1 is in locale de-DE notation. The sum is calculated wrong.
The sum is always displayed in the correct locale.
What should happen
The locale setting should also apply to the operands of the SUM operation.
I'm using the following settings
