https://bugs.documentfoundation.org/show_bug.cgi?id=154947
Bug ID: 154947
Summary: Editing a formula should not remove the range
overlays; instead they should be updated
Product: LibreOffice
Version: 7.6.0.0 alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
In Calc, suppose you enter a formula in cell A2:
=SUMPRODUCT(B2:B9;C2:C9)
After you press enter, the formula result is displayed.
Now suppose you want to edit the formula. For that you either double-click cell
A2 or select cell A2 and press F2. When you do this, two overlays are shown for
each of the ranges in the formula:
B2:B9 => Blue overlay
C2:C9 => Red overlay
Now the cursor is blinking, allowing to edit the formula.
The problem is that, as soon as the user types anything, both overlays are
removed. This is a pain when working with formulas with multiple ranges, and
you want to keep track of what is and what is not included in the formula yet.
In Excel, when you start editing the formula, all overlays are maintained and
updated while the formula is edited, which is super handy.
In Google Sheets the same happens, with the added benefit that the range where
the cursor is positioned gets a special highlight.
OnlyOffice behaves exactly as Excel and WPS has a similar behavior as Google
Sheets, giving special highlight to the range where the cursor is positioned.
I propose we add this feature to Calc as well... it makes editing formulas much
more productive.
--
You are receiving this mail because:
You are the assignee for the bug.
