Bug 104559 - UI When editing a formula cell, the formula hides referenced cells
Summary: UI When editing a formula cell, the formula hides referenced cells
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: low minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 127486 159374 (view as bug list)
Depends on:
Blocks: Cell-Formula Cell-Reference
  Show dependency treegraph
 
Reported: 2016-12-10 15:19 UTC by Roland Illig
Modified: 2024-07-25 16:07 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
Screenshot showing the cells hidden by the formula (30.61 KB, image/png)
2016-12-10 15:19 UTC, Roland Illig
Details
Sample (11.02 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-12-11 02:07 UTC, m_a_riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Roland Illig 2016-12-10 15:19:50 UTC
Created attachment 129461 [details]
Screenshot showing the cells hidden by the formula

To reproduce:

1. Start with an empty table
2. Press Tab Tab =B1+D1+0+0+0+0+0+0+0+0+0+0+0+0 Enter Ctrl+E
3. Press F2

Expected:

* The referred cells B1 and D1 have corner marks

Actual:

* The referred cells are not visible because the formula hides them

Proposed solution:

* Move the formula editor to another nearby position so that all referred cells are visible
Comment 1 Joel Madero 2016-12-10 19:28:49 UTC
Version: 5.4.0.0.alpha0+
Build ID: 228ae90e9f2726195e48dbb0eba2320b6ead396d
CPU Threads: 2; OS Version: Linux 4.4; UI Render: default; VCL: gtk2; 
Locale: en-US (en_US.UTF-8); Calc: single

Confirmed.
Comment 2 m_a_riosv 2016-12-11 02:07:29 UTC
Created attachment 129478 [details]
Sample

Agree, even worse trying to modify the formula and those cells behind the formula are not selectable with the mouse.

If it were possible putting the formula between cells in a way that all cells were selectable.
Comment 3 QA Administrators 2018-07-12 02:43:37 UTC Comment hidden (obsolete)
Comment 4 m_a_riosv 2018-08-22 17:10:02 UTC
Repro
Version: 6.0.7.0.0+ (x64)
Build ID: c57538b2b3c9ffbb206590089c0a5ca69056304d
CPU threads: 4; OS: Windows 10.0; UI render: default; 
TinderBox: Win-x86_64@42, Branch:libreoffice-6-0, Time: 2018-08-20_19:58:40
Locale: es-ES (es_ES); Calc: CL
Comment 5 QA Administrators 2019-09-02 09:27:29 UTC Comment hidden (obsolete)
Comment 6 m_a_riosv 2019-09-02 19:50:33 UTC
Still
Version: 6.3.1.2 (x64)
Build ID: b79626edf0065ac373bd1df5c28bd630b4424273
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: es-ES (es_ES); UI-Language: en-US
Calc: CL
Comment 7 m_a_riosv 2019-09-11 12:09:37 UTC
*** Bug 127486 has been marked as a duplicate of this bug. ***
Comment 8 QA Administrators 2021-09-11 03:52:07 UTC Comment hidden (obsolete)
Comment 9 m_a_riosv 2021-09-11 10:13:23 UTC
Still
Version: 7.2.1.2 (x64) / LibreOffice Community
Build ID: 87b77fad49947c1441b67c559c339af8f3517e22
CPU threads: 4; OS: Windows 10.0 Build 21390; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL
Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 4cd3ce9848aa039b8d443a1257d1298231680b01
CPU threads: 4; OS: Windows 10.0 Build 21390; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL
Comment 10 QA Administrators 2023-09-12 03:05:43 UTC Comment hidden (obsolete)
Comment 11 m_a_riosv 2023-09-12 13:04:02 UTC
Still
Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: be9d7bee88eff89c0d361f23abb447ac2086c3b4
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded Jumbo
Comment 12 Stéphane Guillou (stragu) 2024-07-25 15:56:07 UTC
*** Bug 159374 has been marked as a duplicate of this bug. ***
Comment 13 Stéphane Guillou (stragu) 2024-07-25 16:07:06 UTC
Same in OOo 3.3.

As in duplicate bug 159374, also means it hides underlying cells for selection while populating the formula. But see discussion and workarounds in that report.