https://bugs.documentfoundation.org/show_bug.cgi?id=159374
--- Comment #2 from ady <[email protected]> --- This is not really a bug; at best it could be an enhancement request. It is a limitation that has been probably mentioned in one way or another who knows how many times. The formula text has to go somewhere in the cell, and if the cell is too small in relation to the formula's length, the text needs to continue in some direction. Otherwise, you could not see the formula that you are writing within the cell while you are writing it. One simple workaround is, while you are still editing the formula, to press the "wrap text" icon, then select the range you want as argument, and press the same icon once again. If the initial status was not to wrap text, then the text of the formula initially blocks the cell(s) to the side of the current active cell. After pressing "Wrap text" once, those cells will be visible while the text will cover the area below the current active cell. You can guess the rest. Similarly, press the "Align right" and the text display to the left of the active cell (while you are still editing the formula), leaving the right side visible in order to select a range; then click the same icon once more. Those are simple and already-available methods. Alternative: Add an option to hide the formula from within the cell itself while in cell's edition mode. The formula will be shown in the input box formula bar, but not in the cell, at least until you complete the formula (i.e. exit cell's edit mode). The problem with this is that the possible combinations that users could end up requesting is more than ON/OFF. Just as examples: always hide in cell, always hide in formula bar, hide only when editing, hide only when the formula is too long (in relation to cell's size), hide only when zoom is %100, and so on. Considering the simplicity of the already-available workarounds, is it really worth any additional effort? -- You are receiving this mail because: You are the assignee for the bug.
