Bug 146843

Summary: EDITING: Can't undo autocorrect of text that matches formulas in cells that look like formulas
Product: LibreOffice Reporter: Dan Dascalescu <ddascalescu+freedesktop>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: minor CC: ilmari.lauhakangas
Priority: medium    
Version: 6.3.0.4 release   
Hardware: All   
OS: All   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=79404
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 105948    
Attachments: Screencast

Description Dan Dascalescu 2022-01-18 18:32:17 UTC
Created attachment 177639 [details]
Screencast

If you type in a cell "- preserve the meaning of columns" and press Enter, Calc will forcibly autocorrect "columns" to "COLUMNS()", and Undo won't work.

This seems like a corner case, but the way I found this bug was that I was entering a list of items one per cell, starting with "-".
Comment 1 Buovjaga 2022-01-20 13:24:00 UTC
Reproduced on Linux and Windows. Oldest tested was oldest of Linux 6.3 bibisect repository.

Arch Linux 64-bit
Version: 7.4.0.0.alpha0+ / LibreOffice Community
Build ID: a86669f4301541b446cab2e4fbbe1d86ba8a8a38
CPU threads: 8; OS: Linux 5.16; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 20 January 2022