https://bugs.documentfoundation.org/show_bug.cgi?id=149356
--- Comment #36 from Colin <that.man.co...@gmail.com> --- (In reply to Colin from comment #35) > (In reply to Colin from comment #34) > > (In reply to ady from comment #33) > > > (In reply to Colin from comment #32) > > > > My original thought was for something as simple and obvious as > > > > Alt+double-click to prioritise the right column instead of the left > > > > column. > > > > > > > > > > > Note: It could be helpful (see comment 31) if someone with MS Excel > > > (and/or > > > other spreadsheet tools) could check the current behavior with at least 3 > > > columns and report it here. > > > > Excel > > 1 1 > > 1 1 > > 1 1 > > 1 > > 1 > > > > 1 > > 1 Excel fills to here ignoring both empty cells ie to the lowest > > occupied row > > I put a formula in the middle (blank) column Sorry, more haste less speed When column A has 1 blank and then continues to the same level as column C so they both have a blank cell it fills to the lowest extremity. If column A terminates as above it fills to the break in column C. ie right priority. -- You are receiving this mail because: You are the assignee for the bug.