https://bugs.documentfoundation.org/show_bug.cgi?id=171093

Laurent Balland <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|calc: Search replace of +   |Formula compiler wrongly
                   |add zeros to formula        |adds a zero to formula in
                   |(french, german locales...) |case of erroneous formula

--- Comment #3 from Laurent Balland <[email protected]> ---
I think I understand what is happening behind this strange behavior:
After replacement, the formula "=1plus2,5" is sent to formula compiler to
understand it. In some cases, compiler consider that an operator is missing
between "1plus2" (an unknown name of variable) and the end of the string ",5",
which is treated as a double and converted to "0,5".

So no need to make a replacement. Just type the erroneous formula with fr-FR
locale
=1PLUS2,5
and the formula compiler will transform it in
=1plus20,5
for the same reason
Or with en-US, type formula
=11.3.5
and the formula compiler will transform it in
=11.30.5

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to