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

Stéphane Guillou (stragu) <stephane.guil...@libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Blocks|                            |108827, 108253
            Version|unspecified                 |Inherited From OOo
         Whiteboard| QA:needsComment            |
     Ever confirmed|0                           |1
                 CC|                            |stephane.guillou@libreoffic
                   |                            |e.org
             Status|UNCONFIRMED                 |NEW
            Summary|EDITING Some Calc functions |EDITING Some Calc functions
                   |add extra space character   |get extra leading space
                   |for each cell's edition     |character every time the
                   |                            |formula is edited (same
                   |                            |with save + reload)

--- Comment #1 from Stéphane Guillou (stragu) 
<stephane.guil...@libreoffice.org> ---
Reproduced:

Version: 7.5.0.3 (X86_64) / LibreOffice Community
Build ID: c21113d003cd3efa8c53188764377a8272d9d6de
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

No need for the final ENTER in each step from 6 to 9.

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)


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108253
[Bug 108253] [META] Calc cell formula bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827
[Bug 108827] [META] Calc functions bugs and enhancements
-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to