Page 1 of 1

Flash fill

Posted: Wed Apr 17, 2019 6:01 pm
by lebyarules
hi

excel has something called flash fill.
open office/libre office has auto fill but its not quite the same as flash fill.
flash fill can take any letters, numbers, symbols and automatically recognize what is wanted in the next column.

is there anything like this available on openoffice/libreoffice

thanks

Re: flash fill

Posted: Wed Apr 17, 2019 6:52 pm
by Villeroy
No, you have to use spreadsheet formulas.

Re: Flash fill

Posted: Wed Apr 17, 2019 11:00 pm
by RusselB
You can enter a number into a cell, then click and drag the "handle" (small black square at the bottom right of the highlighted cell) across or down, and the range covered will auto-fill with an incremental number.
That's the closest that I can see with OpenOffice/LibreOffice Calc. It only works with numbers. If you want an increment of something other than one, there are ways of doing that.