Flash fill

Discuss the spreadsheet application

Flash fill

Postby lebyarules » Wed Apr 17, 2019 6:01 pm

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
open office org 3 on windows 7
lebyarules
 
Posts: 4
Joined: Mon Mar 31, 2014 12:16 pm

Re: flash fill

Postby Villeroy » Wed Apr 17, 2019 6:52 pm

No, you have to use spreadsheet formulas.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26555
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Flash fill

Postby RusselB » Wed Apr 17, 2019 11:00 pm

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.
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
RusselB
Volunteer
 
Posts: 4926
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON


Return to Calc

Who is online

Users browsing this forum: Colin-Campbell and 24 guests