Flash fill

Discuss the spreadsheet application
Post Reply
lebyarules
Posts: 4
Joined: Mon Mar 31, 2014 12:16 pm

Flash fill

Post 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
open office org 3 on windows 7
User avatar
Villeroy
Volunteer
Posts: 31264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: flash fill

Post by Villeroy »

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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Flash fill

Post 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.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
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.
Post Reply