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

Laurent Balland <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[email protected]

--- Comment #2 from Laurent Balland <[email protected]> ---
Reproduce with Version: 26.8.0.0.alpha0+ (X86_64)
Build ID: ee2fe6acdba158d48d1166562ce02752d35524d2
CPU threads: 8; OS: Linux 6.17; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: en-US
Calc: threaded

Conditions to reproduce:
- cell must be a formula (replacement in Values has no bug)
- element following the string to be replaced must be a decimal number
- replacement string must not contain whitespace
- the new formula must generate an error 509:"Operator missing". For instance,
replacing ",36/2" by "3" in "=11,36/2,5" gives "=113,5" without added '0' (no
bug), whereas replacing "36/2" by "3" in same formula gives "=11,30,5" (bug: a
'0' was added)

- a '0' is inserted left of the decimal separator

I was able to reproduce the bug with a point as decimal separator:
replace "36/2" by "3" in "=11.36/2.5" should give ="11.3.5" but gives
"=11.30.5" with an added '0'

'0' seems to be added in ScCompiler::CompileString
https://opengrok.libreoffice.org/xref/core/sc/source/core/tool/compiler.cxx?r=f3bd8077537646d4f2b9f4f3b98428c54673ec99#5017

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

Reply via email to