Cell reference are highlighted black when putting = into a cell and clicking a different cell
Steps to Reproduce:
1. Open Calc
2. Type 5 in A1
3. Enter cell A2
4. Type & click cell A1
5. A1 will be put into cell A2 but appears highlighted/black.
6. Type say A. Notice this being put behind A1. Which is expected, except the highlighting suggested 'overwrite' mode
Cell background or if this some 'feature', make a different color
User Profile Reset: No
Version: 188.8.131.52.alpha1+ (x64) / LibreOffice Community
Build ID: 214fa233338c09156c67f85818b6a2ea6b3235bd
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: en-US
UX needed because the current behaviour being present for a long long time.
See for comparison MSO
The "highlighting suggested 'overwrite' mode" works for clicking, not for typing nor backspace.
Version: 184.108.40.206 (x64) / LibreOffice Community
Build ID: c6a4e3954236145e2acb0b65f68614365aeee33f
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: default; VCL: win
Locale: es-MX (es_ES); UI: en-US
Cannot follow, please do a screencast.
Created attachment 176416 [details]
Literally my exact steps (different location on the sheet), but the fact the the selected cell becomes 'black' is unfamiliar for me. And well the mixture of 'black' meaning you will overwrite and cases where this isn't the case is rather confusing in my perception.
LibreOffice is here clearly different from MSO, but no clue if there is a some this is not a bug but feature logic behind it. So I complain about the mere presence of this behaviour, or the implementation of the feature.
For sake of consistency we should respect the overwrite mode and delete the whole selection on keypress. However, this was probably implemented intentionally as a convenience feature. Imagine you have to press arrow right when you want to create a formula like =a1+a2+a3+a4...
We discussed this topic in the design meeting.
+ convenience feature if one can click another cell to overwrite
but at the same time + to continue a formula
+ MS Excel does behave the same but does not show the selection
+ complaints are rare, behavior exists forever
+ not showing the selection shouldn't hurt too much
+ difference to Excel is that we highlight only the last cell
while Excel shows a color coding for all, eg. =A1+A2+A3 makes
the border of A1 red, A2 green, A3 blueish
+ Excel highlighting is also not straight-forward as it misses
the overwrite aspect
+ lot of effort for not much benefit
Putting all together we decided to keep the current behavior.