Bug 42496 - Calc EDITING: improve functionality when Formula gets in a way while editing and prevents selection of the adjacent cell.
Summary: Calc EDITING: improve functionality when Formula gets in a way while editing ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.3.4 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Whiteboard: BSA
: 48383 (view as bug list)
Depends on:
Blocks: Cell-Formula
  Show dependency treegraph
Reported: 2011-11-01 23:37 UTC by Сергій Загорія
Modified: 2018-03-17 12:47 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Screenshot of the long formula that gets in a way (5.98 KB, image/png)
2011-11-01 23:37 UTC, Сергій Загорія

Note You need to log in before you can comment on or make changes to this bug.
Description Сергій Загорія 2011-11-01 23:37:56 UTC
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.

Expected behavior:
The formula should leave cell boundaries only when the formula bar is not visible.

Platform (if different from the browser): 
All platforms
Browser: Mozilla/5.0 (X11; Linux i686; rv:7.0.1) Gecko/20100101 Firefox/7.0.1
Comment 1 Сергій Загорія 2011-11-01 23:40:26 UTC
(In reply to comment #0)
> didn't found 

> add B2 cell 
Comment 2 sasha.libreoffice 2012-04-19 02:06:27 UTC
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.
Comment 3 ign_christian 2014-07-22 08:37:00 UTC
*** Bug 48383 has been marked as a duplicate of this bug. ***
Comment 4 David 2016-03-14 02:17:26 UTC
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.
Comment 5 Severo Raz 2018-03-17 12:47:09 UTC
This bug is still present in LibreOffice