[Solved] Filling series in filtered column

Discuss the spreadsheet application
Post Reply
eezyrider
Posts: 2
Joined: Tue Nov 05, 2019 11:57 pm

[Solved] Filling series in filtered column

Post by eezyrider »

I have filtered a column and I'm now trying to fill a series in the remaining cells (dates) however the fill series option is greyed out. I can do this in other Office equivalents - what am I doing wrong in Open Office?

Thanks
Last edited by Hagar Delest on Thu Nov 07, 2019 2:27 pm, edited 1 time in total.
Reason: tagged solved
Open Office 4 -W10
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Filling series in filtered column

Post by Zizi64 »

The 1, 2, 3... numerical serias works on my filtered (autofilter) range in my LibreOffice 6.2.8. I just typed in the first number, and dragged it to the bottom of the desired range on the filtered range.

Here is a sample file to demonstrate it. The range was filtered to the Red color, when I dragged the numbers.
Fill filtered range with series.ods
(9.69 KiB) Downloaded 100 times
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
eezyrider
Posts: 2
Joined: Tue Nov 05, 2019 11:57 pm

Re: Filling series in filtered column

Post by eezyrider »

Thanks for that. Clicking and dragging down using the fill handle works as you say. I was trying to filter, the click on edit*> fill> series.

Thanks though.




*sheet in LibraOffice
Open Office 4 -W10
Post Reply