Created attachment 53034 [details]
Screenshot of the long formula that gets in a way
Problem description: I often cannot select the adjacent cell to add it to the formula when the last one is too long. It depends on the formatting but I didn't found the formatting that will constrain the formula within it's cell.
Steps to reproduce:
See the attached screenshot. I cannot add B2 cell to the formula using just a pointer.
The formula should leave cell boundaries only when the formula bar is not visible.
Platform (if different from the browser):
Browser: Mozilla/5.0 (X11; Linux i686; rv:7.0.1) Gecko/20100101 Firefox/7.0.1
(In reply to comment #0)
> didn't found
> add B2 cell
Thanks for bugreport
Reproducible in 3.3.4 and 3.5.2 on Fedora 64 bit and Windows 32 bit
Currently it is not a bug but functionality request. Something like this:
If A1 contains long formula, A2 contains some content, we placed cursor into formula bar (not into cell), then do not expand formula from A1 to A2.
@ Сергій Загорія
Workaround: According to screenshot, suppose we need add cell B1. First, add C1. Then press arrow to left on keyboard, C1 will changed to B1. But do not place cursor into formula or it method will not work. This works on Windows and Linux.
*** Bug 48383 has been marked as a duplicate of this bug. ***
This becomes more of an issue the longer your formulas are. With some of the formulas I am using, it can consume a large portion of the page, hiding many cells I would like to be able to click on to add to the formula. This forces me to save the formula incomplete, lookup the cell addresses that I need to add and re-edit the formula. Since some of them requires 10 cells or more, this is a major pain.
This bug is still present in LibreOffice 22.214.171.124.0.
*** Bug 145040 has been marked as a duplicate of this bug. ***