https://bugs.documentfoundation.org/show_bug.cgi?id=69479
--- Comment #30 from Eike Rathke <[email protected]> --- Fwiw, for me the same happens in cs-CZ locale with en-US UI and in fi-FI locale with en-US UI and in cs-CZ locale with cs-CZ UI and in de-DE locale with de-DE UI and in de-DE locale with en-US UI. A difference to 2018 or 2013 might be that IIRC back in time you could force the function parameter to ',' comma even if the decimal separator was ',' comma as well, which makes no sense and is not possible anymore. fi-FI and cs-CZ and de-DE locales have ',' comma decimal separator => function parameter separator is ';' semicolon. Smallest reproducer: =5,11,2 What happens is that 5,11 is parsed as numeric value 5.11 stopping at the second ',' comma and the following ,2 is parsed as numeric value 0.2 with a missing operator in between resulting in error (Err:509, operator missing), the so far parsed and tokenized formula is displayed and concatenating values 5.11 and 0.2 as string with a decimal ',' comma separator results in 5,110,2 Not much we can do about, unless we ditch the requirement that ,2 can be parsed as 0.2 (i.e. a leading 0 would have to be present). Or throw yet more logic at it to remember the original input for each token. -- You are receiving this mail because: You are the assignee for the bug.
