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
[Solved] Filling series in filtered column
[Solved] Filling series in filtered column
Last edited by Hagar Delest on Thu Nov 07, 2019 2:27 pm, edited 1 time in total.
Reason: tagged solved
Reason: tagged solved
Open Office 4 -W10
Re: Filling series in filtered column
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.
Here is a sample file to demonstrate it. The range was filtered to the Red color, when I dragged the numbers.
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.
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.
Re: Filling series in filtered column
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
Thanks though.
*sheet in LibraOffice
Open Office 4 -W10