Summary: | Cell reference are highlighted black when putting = into a cell and clicking a different cell | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Telesto <telesto> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED NOTABUG | ||
Severity: | minor | CC: | erack, heiko.tietze |
Priority: | medium | ||
Version: | 3.5.0 release | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 108253, 108917, 109139 | ||
Attachments: | Screencast |
Description
Telesto
2021-11-21 12:03:59 UTC
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: 7.1.7.2 (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 Calc: CL Cannot follow, please do a screencast. Created attachment 176416 [details]
Screencast
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. |