https://bugs.documentfoundation.org/show_bug.cgi?id=153539
Bug ID: 153539 Summary: EDITING Some Calc functions add extra space character for each cell's edition Product: LibreOffice Version: unspecified Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: adylo811...@gmail.com 1. New Calc document (using comma as argument separator in the following steps) 2. A1: 1 3. C1: =AND(A1,B1) (do not press [ENTER] yet) 4. ENTER, ArrowUp, F2, Backspace, ENTER 5. In C1, add (at least) one space character between the function name and the first opening bracket: C1: =AND (A1,B1) (and [ENTER]) 5.1. Go back to focus on C1 (i.e. click once on C1). Note that one additional space character was also automatically added before the function name: "= AND (A1,B1)". 6. ENTER, ArrowUp, F2, Backspace, ENTER 7. ENTER, ArrowUp, F2, Backspace, ENTER 8. ENTER, ArrowUp, F2, Backspace, ENTER 9. ENTER, ArrowUp, F2, Backspace, ENTER Now it is clear that between the equal sign and the function name "AND", (what seems to be) a space character is being automatically added for each edition. (Why? What for? What is Calc trying to correct, or enhance, or compensate for? Anyway...) To trigger the behavior, step 5 above is the key. The specific function, "AND" in this case, is semi-circumstantial. The same behavior can be seen with "OR" too, but not with XOR, IF, SUM... Tested in: Version: 7.4.5.1 (x64) / LibreOffice Community Build ID: 9c0871452b3918c1019dde9bfac75448afc4b57f CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: default; VCL: win Locale: en-US (es_AR); UI: en-US Calc: CL Also tested in: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 9d44236a62bf59d120dda89924d0d1407b2bd52b CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-US (es_AR); UI: en-US Calc: CL threaded Repro also by: https://listarchives.libreoffice.org/global/users/2023/msg00046.html -- You are receiving this mail because: You are the assignee for the bug.