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)
Version:
(earliest affected)
3.3.4 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
: 48383 145040 (view as bug list)
Depends on:
Blocks: Cell-Formula
  Show dependency tree / graph
 
Reported: 2011-11-01 23:37 UTC by Сергій Загорія
Modified: 2023-04-06 21:48 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:

Attachments
Screenshot of the long formula that gets in a way (5.98 KB, image/png)
2011-11-01 23:37 UTC, Сергій Загорія 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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 
*find

> add B2 cell 
*B1
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 6.0.2.1.0.
Comment 6 m_a_riosv 2021-10-11 10:25:21 UTC 
*** Bug 145040 has been marked as a duplicate of this bug. ***
Comment 7 m_a_riosv 2023-04-06 21:48:45 UTC 
Still
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: d408e940630d131ab886a1d4619671fa0299c03e
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Jumbo