The problem I found is in LibreOffice Calc Version: 7.5.3.2 (X86_64) / LibreOffice Community Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3 CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-CA (en_CA); UI: en-US Calc: threaded I've been transcribing a census listing into a spreadsheet. There are no formulas, and I've entered all numbers (ages, etc.) as text -- eg.'25 -- so they will sort alphabetically. When I type over text which was previously in a cell and try to use 'Control-Z' to undo, the contents of the cell are erased permanently rather than replaced with the previous contents. Thanks, Charles Dobie cdobie@superaje.com
Because overtyping clears the cell and in the fresh cell enters new content, which Undo only leads to the fresh cell again. Either hit Esc to abort editing, or confirm new content with Enter and then hit Ctrl+Z Or start editing with placing the cell into edit mode first (F2), then you can use in-cell Undo. Confirming, but I doubt this will get changed.
This has been the case since OOo 3.3, so marking as inherited. Editing a cell has its own undo stack, and exiting edit mode will take that whole stack as one single change. - Office.com and Google Sheets do the same as LO - OnlyOffice can undo back to the overwritten contents (what OP wants) - Gnumeric doesn't have an "in-cell" undo stack Design team, should "Select cell > Type" give access to the same undo stack as "Edit mode > Select all > Type"? I think that could make things more consistent.
(In reply to Stéphane Guillou (stragu) from comment #2) > "Edit mode > Select all > Type"? F2 + type wont delete content but add at the end. In most situations you want to replace the cell content with what you type. Which makes the first in-cell undo step clearing the content. Ultimately it's not a big deal I guess. You press enter/escape anyway, which either returns to the original value (esc) or allows to undo. => NAB