In Calc, suppose you enter a formula in cell A2:
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.
I think it is already reported, but I can't find.
+1, and I found the duplicate :-)
*** This bug has been marked as a duplicate of bug 38304 ***