https://bz.apache.org/ooo/show_bug.cgi?id=125778
Andreas Säger <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #7 from Andreas Säger <[email protected]> --- OpenOffice does it right. LibreOffice and Excel do it wrong. In LibreOffice (English locale) I enter this in A1, A2, A3: A1: '3.456 A2: '1.234 A3: =A1+B1 ==> 4.69 Let's simulate what happens when I send the file abroad. -- Switch Tools>Options>LanguageSettings>Languages>Locale from English to German (or French or Russian or Italian or ...). -- Reload the file or force recalculation by Ctrl+Shift+F9 Now the exact same formula using the exact same text values yields a completely different result 4690. -- You are receiving this mail because: You are the assignee for the issue.
