https://bugs.documentfoundation.org/show_bug.cgi?id=171093
--- Comment #1 from Fab Stz <[email protected]> --- confirmed on IRC #libreoffice 2026-03-01. It happens also on 26.2.1 [18:40] <bastif_> I have a very weird behavior in calc. Take formula "=1+2.5" (or a comma instead of a dot, since I'm on french locale). [18:40] <bastif_> Then do a search/replace. Search "+" replace by "PLUS" [18:40] <bastif_> The formula becomes "=1PLUS20.5" [18:42] <bastif_> The additional 0 is very unexpected. Tested on LO 25.2.3 and 26.2.0 [18:42] <mikekaganski> bastif_: so - that looks exactly what you did? Unless you wanted to search not in formulas, which is possible in Find/Replace dialog? [18:42] <mikekaganski> aha [18:43] <bastif_> Did you notice the additonal zero ? [18:43] <mikekaganski> bastif_: seems to work here using 26.2.1 [18:44] <mikekaganski> without 0 [18:44] <mikekaganski> but "plus" is lowercase in the result (because it's not a known function) [18:44] <bastif_> Which locale do you have? [18:44] <mikekaganski> =1plus2.5 [18:44] <mikekaganski> en-GB [18:47] <bastif_> Ok, I tried with your locale and it's works like you. Can you try fr-FR locale and a comma instead of a dot "=1+2,5" ? [18:51] <bastif_> no need to restart, it can be changed in options / languages & locales / general / locale setting. [18:52] <bastif_> It is also wrong with german locale. "=1+2,5" becomes "=1plus20,5" [19:05] <bastif_> mikekaganski: could you try ^ and confirm the issue is you swith the locale ? [19:05] <bastif_> s/is you swith/if you switch/ [19:07] <mikekaganski> bastif_: yes, repro [19:08] <bastif_> thanks! -- You are receiving this mail because: You are the assignee for the bug.
