If a cell is selected and then extended over cells which contain data, the data is overwritten by the autofill without any error message.
Steps to Reproduce:
1. put numeric data into several cells in a column or row.
2. select the first cell
3. extend the selection over the rest of the data
the data is overwritten with no warning
at least a warning message
User Profile Reset: No
I'm filing this on behalf of a fellow CIXen who is aiming to give up LibO because they seem to have had this problem.
It is not a bug, could be a request for enhancement, implying another option setting.
Making it as default, without an option to disable it, IMHO would break, with severity, the workflow.
I take your point about it being an enhancement request.
I don't quite get your second point, though. I'm suggesting a warning message on the lines of "You are trying to put data into a cell which already contains data. Do you want to continue?", which appears when you paste data into a cell. Why are Paste and Autofill treated differently here? How would that severely affect workflow?
A warning could be an added feature/UX improvement
Version: 126.96.36.199.alpha0+ / LibreOffice Community
Build ID: c54c576a5043dc5a0cc01f8c71897373516ae091
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-NG (en_NG); UI: en-US
There is an option in Menu/Tools/Options/LibreOffice calc/General - Show overwrite warning when pasting data. Maybe Autofill could follow it.
It's expected to overwrite content (and in alignment to competitors). In fact you can double click the rectangle at right bottom to auto fill the neighboring cells. Any warning is counterproductive to the very efficient workflow. I recommend to resolve this request as WF.
Some related tickets:
bug 66890 - Double-clicking fill handle should also overwrite down the entire range => WFM
bug 108209 - Autofill overwrites data with mixed empty and filled cells => FIX
bug 126767 - Autofill doesn't overwrite data in continuously filled cells => FIX
I go with comment 4 here. That way, people who are worried about accidentally overwriting data can have their workflow interrupted. Those who prefer not to have their workflow interrupted can opt not to do so.
While there is obviously a need to follow 'competitors' (surely 'MS Office' would be more accurate), I cannot see the reason to slavishly copy every design bug that MS have introduced. Surely we should be trying to produce a better product, not a carbon copy.
(In reply to Heiko Tietze from comment #5)
> fact you can double click the rectangle at right bottom to auto fill the
> neighboring cells.
Note this is not about double clicking the fill handle (which either stops at a cell with content, or overwrites all for an already filled range; which the mentioned bugs were about) but doing a manual drag fill ("extend the selection") with the fill handle.
Confusingly the term AutoFill seems to be used for both.
Current LO behavior is what majority of users expect.
Other also don't have a warning for fill/extend overwrite. Not just MSO, but WPS, SoftMaker.
So we may close as WontFix, it wouldn't be wrong.
But let's leave a room to add an option to warn when autofill overwrites existing data. Even so, that should be turned off by default.
It's a no-go to interrupt the workflow. Imagine you pull down the handle and Calc takes over to ask you whether you really want to do this (ending in the situation that you cannot continue anyway). The only solution I see is to inform the user once data got overwritten. But since you manually pull down the handle you should see what's going on.
> But let's leave a room to add an option to warn when autofill overwrites
> existing data. Even so, that should be turned off by default.
The topic was on the agenda of the design meeting but didn't receive further input.
Let's change the behavior and show an infobar when autofill (or paste) overwrites data with an option to undo. We should also consider an option to disable the non-interruptive warning.
(In reply to Heiko Tietze from comment #11)
> Let's change the behavior and show an infobar when autofill (or paste)
> overwrites data with an option to undo. We should also consider an option to
> disable the non-interruptive warning.