Description: So If I have some expression in calc which results in some value like |=sum(somerange) + count(some range) | such that the expression's length exceedes that of the cell, it takes up the area of the next cell, making it impossible to click that cell and select it (to use it in some formula). Steps to Reproduce: 1.Write some long =expression in a calc cell. 2.When the length of expression exceeds that of the cell, try to select the next cell to use in the formula Actual Results: The next cell cannot be click selected to use in formula. Expected Results: There should be some way to click select and use the cell in the formula. Reproducible: Always User Profile Reset: Yes Additional Info: -
Same in Excel, and in Gnumeric, and in Google Sheets. I don't thing there's a solution to this. Just use workarounds like clicking to another cell (above/below/to the right), and then pressing arrow keys to correct it. I would welcome a smart idea how to solve this without infinite amount of regressions, but my opinion is: follow the lead of the Royal Academy of Sciences in Paris, which stopped accepting proposals concerning perpetual motion in 1775 [1], and declare this WF :-D [1] https://en.wikipedia.org/wiki/History_of_perpetual_motion_machines#Pre-19th_century
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?