https://bugs.documentfoundation.org/show_bug.cgi?id=153539
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.documentfounda | |tion.org/show_bug.cgi?id=11 | |6040 --- Comment #4 from ady <[email protected]> --- (In reply to Stéphane Guillou (stragu) from comment #1) > No need for the final ENTER in each step from 6 to 9. Sorry about that. ... 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. [ArrowUp] to focus on C1 again. Note that one additional space character was also automatically added before the function name: "= AND (A1,B1)". 6. F2, Backspace, ENTER 7. ArrowUp, F2, Backspace, ENTER 8. ArrowUp, F2, Backspace, ENTER 9. ArrowUp, F2, Backspace, ENTER > > I confirm that any kind of edit to the formula adds an extra space between > the equal sign and the formula name, but only when there is a space between > the formula name and the opening parenthesis. E.g., I could add extra > elements (or remove them) to the formula after the function, to the same > effect. > Also, reopening/reloading the file also adds one extra leading space. You > can test doing Ctrl + S then File > Reload. > > I can reproduce the same behaviour in 6.0, although back then, a space would > be added both before *and* after the formula name: > > Version: 6.0.0.3 > Build ID: 64a0f66915f38c6217de274f0aa8e15618924765 > CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk2; > Locale: en-AU (en_AU.UTF-8); Calc: group > > Finally, in OOo 3.3, the spaces would be added before and after the formula > name even without changing the formula. Entering in edit mode is enough. > > OpenOffice.org 3.3.0 > OOO330m20 (Build:9567) The minor differences perhaps might indicate that at some point there was some effort to improve the behavior(?). Adding See Also bug 116040 involving same functions AND() and OR(). -- You are receiving this mail because: You are the assignee for the bug.
