Bug 153750 - EDITING a formula in a Calc cell with Insert mode enabled does not delete previous chars
Summary: EDITING a formula in a Calc cell with Insert mode enabled does not delete pre...
Status: RESOLVED DUPLICATE of bug 82599
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.0.3 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-02-20 04:48 UTC by Loren Amelang
Modified: 2023-03-06 18:13 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Four screenshots, bottom one first, editing steps above it (152.48 KB, image/png)
2023-02-20 04:48 UTC, Loren Amelang
Details
A row x col cell way outside the Calc window ??? (103.82 KB, image/png)
2023-02-20 05:03 UTC, Loren Amelang
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Loren Amelang 2023-02-20 04:48:09 UTC
Created attachment 185481 [details]
Four screenshots, bottom one first, editing steps above it

I happened to open Calc with the Insert key on my Windows keyboard enabled. Went to edit a formula in a cell, and found chaos! The top data entry bar looks like it is working as expected, but replaced characters are not removed from the actual cell and formula! Except + and - are replaced...  

Took me awhile to comprehend what was happening, since I never use Insert mode in Calc sheets, and didn't even realize it was on - finally remembered seeing the wide cursor in text apps. If it had been properly replacing characters, I'd have caught on much sooner. 

See the sequence of staged screenshots, bottom one first, upper ones later. 

Version: 7.5.0.3 (X86_64) / LibreOffice Community
Build ID: c21113d003cd3efa8c53188764377a8272d9d6de
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: default; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

No idea if this happened in older versions, never tried it before.
Comment 1 Loren Amelang 2023-02-20 05:03:49 UTC
Created attachment 185482 [details]
A row x col cell way outside the Calc window ???
Comment 2 Loren Amelang 2023-02-20 05:08:17 UTC
Ooops - Adding the "row x col" screenshot before sending my comment about it deleted the comment. It was sitting above my browser homepage when I closed the previous bug report. Or by itself over my Windows wallpaper. Clicking out of the error cell I'd been editing hid it. Editing didn't bring it back.
Comment 3 Stéphane Guillou (stragu) 2023-03-06 18:13:16 UTC
Thank you for your report, Loren! This has been reported here already: bug 82599

*** This bug has been marked as a duplicate of bug 82599 ***