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: [email protected]
Reporter: [email protected]
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.
