Description: To autofill a column the user can double click on the square on the bottom right corner of the cell selection. This should refill the cells down as far the end if all cells are filled. (related to Bug 108209 or Bug 126676) Steps to Reproduce: 1. correct the contents of the top cell in a contiguous column 2. use double-click to re-fill the filled cells under the repaired cell 3. Actual Results: refill does not work Expected Results: refill (same as in older versions LO) Reproducible: Always User Profile Reset: No Additional Info:
Hmm, it is true this should work for contiguous data. Excel behaves as requested. Setting to NEW
*** Bug 126676 has been marked as a duplicate of this bug. ***
What does Excel do for these constellations when double clicking the fill handle on B1 (b)? A B a b x y x y x A B a b x y x y y Also, for the same two constellations selecting A1:B1 and double clicking B1 (b)? And here when selecting A1:C1 and double clicking handle on C1 (c)? A B C a c x y z x y z x y A B C a b c x z x y z x y z x y
(In reply to Eike Rathke from comment #3) > What does Excel do for these constellations when double clicking the fill > handle on B1 (b)? > > A B > a b > x y > x y > x b b b > A B > a b > x y > x y > y b b b b > Also, for the same two constellations selecting A1:B1 and double clicking B1 > (b)? First one: a b a b a b x Second one: a b a b a b y > > > And here when selecting A1:C1 and double clicking handle on C1 (c)? > > A B C > a c > x y z > x y z > x y a c a c a c x y > A B C > a b c > x z > x y z > x y z > x y a b c a b c a b c a b c x y Tested with MSO 365 on Win 10.
My first test (at the time of comment 1) was with a single column with no neighbouring columns - LibreOffice refused to fill.
Thanks. These samples are meant to identify the behaviour if and how neighbouring columns affect the fill of filled columns. Seems they don't, and furthermore for a range/row selection up to the minimum row of filled columns is filled. That at least gives some orientation. One more dumb question ;-) What happens for a selection of A1:B1 (empty cells) A B x y x y
(In reply to Eike Rathke from comment #6) > One more dumb question ;-) > What happens for a selection of A1:B1 (empty cells) > > A B > > x y > x y Nothing happens.
autofill is different (Calc vs Excel) too when I need to fill cells to end of table (to new lines): A B C D m n formula formula2 o p formula formula2 q r s u v w x When selecting C2:D2 and double clicking on D2, Calc fills the formula up to row number 3 (empty cell in B4). Excel fills formulas by the end of the table.
(In reply to kabilo from comment #8) > autofill is different (Calc vs Excel) too when I need to fill cells to end > of table (to new lines): > A B C D > m n formula formula2 > o p formula formula2 > q r > s > u v > w x > When selecting C2:D2 and double clicking on D2, Calc fills the formula up to > row number 3 (empty cell in B4). Excel fills formulas by the end of the > table. Confirmed with Excel 365
That is a different topic and handled in bug 126189, please do not intermix.
The old Excel's behaviour (I'm not sure what they did to enhance it in 2013 and later) is: In each column, beginning with just below the selection, we count the number of cells until it changes from empty to non-empty or vice versa (0 if not found*). Let x be the minimum of the above list of numbers. Let y = x if x>0, otherwise y = max of the number of consecutive non-empty cells for the adjacent columns. Fill down y more rows below the selection.
(In reply to p199999991 from comment #11) > The old Excel's behaviour (I'm not sure what they did to enhance it in 2013 > and later) is: > In each column, beginning with just below the selection, we count the number > of cells until it changes from empty to non-empty or vice versa (0 if not > found*). > Let x be the minimum of the above list of numbers. > Let y = x if x>0, otherwise y = max of the number of consecutive non-empty > cells for the adjacent columns. > Fill down y more rows below the selection. I forgot to mention that we can make it even better by ignoring the 0's in the list.
*** Bug 127876 has been marked as a duplicate of this bug. ***
Is there a way to get AutoFill to overwrite data in a column again? Making changes in a formula and trying to apply it to all other rows got really time-consuming and cumbersome
Yes, that is really the more troubling point, a significant regression for usability and efficiency. Any effort to revert to the previous behavior would be heaven sent!
One more please: A B C --------- a b c x z x y z x y z x z Select A1:C1 and click handle on C1 (c)
Nothing happens (Excel 2013)
Compared with ... (In reply to Buovjaga from comment #4) > > > A B C > > a b c > > x z > > x y z > > x y z > > x y > > a b c > a b c > a b c > a b c > x y > > Tested with MSO 365 on Win 10. ... that nothing happens for this case doesn't make sense to me. I'd expect either A B C --------- a b c a b c a b c a b c x z (likely), or even A B C --------- a b c a b c a b c a b c x b z (probably not because data in column B ends earlier). Can someone test with Excel 365 please?
Sorry, second (less likely) one should had been A B C --------- a b c a b c a b c a b c a b c
A B C --------- a b c a b c a b c a b c x z updates the first four lines = nothing happens for fifth line (tested in Excel 2013 and Excel 2016). Office 365 not available for me.
Thanks, but.. that's not what I asked though. That was one of the possible results after AutoFill of A B C --------- a b c x z x y z x y z x z from comment 16.
(In reply to Eike Rathke from comment #16) > One more please: > > A B C > --------- > a b c > x z > x y z > x y z > x z > > Select A1:C1 and click handle on C1 (c) nothing happens (Comment 17) - tested in Excel 2013 and Excel 2016. It looks like the first empty any cell in the indicated columns ends the autofill.
That first empty cell can't be the criteria, given my comment 18 with the result from comment 4 that A B C a b c x z x y z x y z x y for A1:C1 results in a b c a b c a b c a b c x y
you need to ask buovjaga to confirm the result from Office 365 from Comment 4 . I confirm the desktop versions (Excel 2013 and 2016) in this case do nothing.
all other results are identical. Thanks
Hi, with Office 365: > A B C > --------- > a b c > x z > x y z > x y z > x z if I select A1:C1 and double click on the handle at the bottom right of C1 nothing happens. However, if I select the same cells and drag the handle down to C5 I get: a b c a b c a b c a b c a b c > What does Excel do for these constellations when double clicking the fill > handle on B1 (b)? > > A B > a b > x y > x y > x Here I get: a b x b x b x > A B > a b > x y > x y > y And here: a b x b x b b > And here when selecting A1:C1 and double clicking handle on C1 (c)? > > A B C > a c > x y z > x y z > x y a c a c a c x y > A B C > a b c > x z > x y z > x y z > x y Nothing happens: a b c x z x y z x y z x y Tested on Microsoft Excel for Mac. Version 16.30. Office 365.
(In reply to mirko.pieropan from comment #26) > Hi, with Office 365: > > > A B C > > --------- > > a b c > > x z > > x y z > > x y z > > x z > > if I select A1:C1 and double click on the handle at the bottom right of C1 > nothing happens. > However, if I select the same cells and drag the handle down to C5 I get: > a b c > a b c > a b c > a b c > a b c hi, yes the results all the tests may be different when dragging (it isn't autofill). The cells are filled with the value of the selection, that is the standard. Autofill worked the same way until version 6.2.6. I would like to add this original autofill eg Alt+doubleclick and Ctrl+Alt+doubleclick (it's another version of autofill).
@Mirko: thanks for trying! So I think we can indeed recap that any blank cell immediately below the selection disables the overwriting fill. Makes sense.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/667287228143519f4a91109924787ad169676ab8 Resolves: tdf#126767 Overwriting autofill if data immediately below selection It will be available in 6.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review https://gerrit.libreoffice.org/81055 for 6-3
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-6-3": https://git.libreoffice.org/core/commit/09fb258853448b89d40a950df639d9a0fe06ebf5 Resolves: tdf#126767 Overwriting autofill if data immediately below selection It will be available in 6.3.4. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
thanks
*** Bug 127545 has been marked as a duplicate of this bug. ***