Description: There is currently no option to turn off "autocorrect while typing" as exists in LO Writer (Tools | Autocorrect | While Typing). This means that one either needs to "undo" locally-undesirable autocorrections, or turn them off completely while doing a certain task and then turn them back on later. Neither is a great solution -- the former is time-consuming, and the latter is both time-consuming and can result in forgetting to re-enable the disabled option. I can't think of a reason not to add this option to Calc. Steps to Reproduce: 1. Go to Tools | Autocorrect Options. Actual Results: There is no option to disable autocorrect while typing. Expected Results: There should be an option to disable autocorrect while typing. Reproducible: Always User Profile Reset: No Additional Info: Version: 7.5.3.2 (X86_64) / LibreOffice Community Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3 CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded
Sounds fair, but as there is no distinction between "while typing" and "apply" like there is in Writer, it would be a single on/off switch for the whole of the AutoCorrect rules.
Hi Stephane, can you say more about there being "no distinction between "while typing" and "apply" like there is in Writer" in Calc? Conceptually, at least, it seems like such a distinction is easily retained: 1) Autocorrect could apply as I'm typing in a cell. 2) Autocorrect could apply to the current cell after I move to the next cell. 3) Autocorrect could be applied on command to a cell or group of cells. I admit that the first two cases are functionally equivalent, even if they act differently (the person sees the autocorrections in "real time" versus seeing them applied after the fact), but it still seems that one could wish to turn off Autocorrect in general, but subsequently wish to apply autocorrect to a particular group of cells but not to others. I hope such functionality would be implemented.
(In reply to William Friedman from comment #2) > Hi Stephane, can you say more about there being "no distinction between > "while typing" and "apply" like there is in Writer" in Calc? Conceptually, > at least, it seems like such a distinction is easily retained: What I meant was that there is currently no separate "M" and "T" columns in Tools > AutoCorrect Options > Options and Localized Options. Therefore, the switch could be a simple on/off that does not need to specify "while typing". But you're right, I can see how having the same options as Writer ("While typing" for live changes, "Apply" for select cells or existing file, and "Apply and Edit Changes" for reviewing) would be useful, despite the lack of M vs T distinction in the rules.