1) click a cell
2) type some text
3) press ^Z
result: a letter is undone
expected: some substantial portion of text is undone
Pressing 100x undo to get to the previous change is utterly useless and exhausts the very limited undo stack quickly.
Thanks for bugreport
This behaviour is only in last edited cell. All previous cells undo one cell at once. This done intendedly for more easy to fix last few typed digits.
What is the use case for undoing one digit at a time?
You can just delete them with backspace.
If LO had multilevel undo (as in you could pick to undo letter at a time, a word at a time, and a cell at at time) and unlimited undo stack this would be less off an issue but as it is now undo in spreadsheet is essentially useless duplication of the backaspace key.
As undo actions are very limited they should focus on larger higher level actions, not typing single letter. Other more sensible applications split undo actions on punctuation, pauses in typing (as in pauses in user input) or they separate when input type changes (typing vs selection vs performing other actions).
> As undo actions are very limited they should focus on larger ...
Indeed, only 999 steps, but developers working on increasing it to 10 000.
If You want to undo all changes to cell at once, just press enter and then Ctrl-Z.
In comparison, msExcel undoes all changes to cell immediately by pressing Ctrl-Z.
(In reply to comment #3)
> > As undo actions are very limited they should focus on larger ...
> Indeed, only 999 steps, but developers working on increasing it to 10 000.
> If You want to undo all changes to cell at once, just press enter and then
Now that's totally obvious.
As I said previously there are more sensible undo units than letters that can be used even inside single cell. Or does the Writer also undo a letter at a time? That would be equally ridiculous.
> Now that's totally obvious.
Also obvious that Calc is not text editor but calculation program
Changing to functionality request
it's still the same office?
Why should typing in calc behave differently than typing in writer?
There is no obvious reason for that.
You type text, numbers and equations in ether writer or calc. No difference there.
Build ID: c89294233b6a9ffc1bd75e6e9226ad723b7d5538
CPU Threads: 2; OS Version: Linux 3.16; UI Render: default;
Locale: en-US (en_US.UTF-8)
From what I can tell undo removes the entire previous word. I think that this is as far as this is going so I'm closing this as WFM.
The reason why delete and undo are different is because if you delete you add a new value to the undo chain, while if you undo, you're going back through your undo list. These are not the same.
Again, think that the current behavior is different from that described (a whole word is undone, not a single letter). It's not going any further than this so WFM.