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
Flash fill
Re: flash fill
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Flash fill
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.
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.
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.