https://bugs.documentfoundation.org/show_bug.cgi?id=170926
--- Comment #15 from [email protected] --- (In reply to Heiko Tietze from comment #14) > Autofill continues a series. If C5 contains a validity list with 1,2,3 and > is set to 1, I can AF down to C9 that now still contains a validity of 1,2,3 > but the shown value of 5, which is not accepted. So either we block AF for > validity or modify and copy rather than continuing a series. > > Excel just copies the content by default (fill series: linear) but can also > grow when the ctrl modifier key is pressed. And then it happens to result in > the very same issue of content with wrong validity. > > (In reply to spaghetti from comment #13) > > workaround to exit error state > > Can you add a few words to explain the workaround? Hi, the explanation was in my previous comment (comment 12), but I"ll try to be more clear below. To summarize, the error state can be entered by clicking the space on the screen where the autofill icon (square in the bottom right of a cell) and the drop down icon (arrow to the right of a cell with data validation enabled) overlap, then clicking any possible value in the drop down list that appears. The behavior in the error state is as described in the "actual results" section of comment 1. I will also add that the most obvious error behavior I personally notice is that using the keyboard to navigate cells breaks while in the error state. As a workaround, the error state can be exited by clicking a portion of the autofill icon that does not overlap with the drop down icon. -- You are receiving this mail because: You are the assignee for the bug.
