Download it now!
Bug 48274 - EDITING: Fill disabled if hidden (or filtered) cells in range instead of filling omitting invisible cells
Summary: EDITING: Fill disabled if hidden (or filtered) cells in range instead of fill...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Blocks: Calc-Cells
  Show dependency treegraph
Reported: 2012-04-03 22:31 UTC by Vlad
Modified: 2019-03-02 17:53 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Vlad 2012-04-03 22:31:54 UTC
Problem description: 
Fill down (Ctrl-D) does not work if selected visible and hidden cells.

Steps to reproduce:
1. cells A1=Header, A2=1, A3=empty, A4=1, A5=1
2. enable filter by Header=not empty
3. change value A2 to "2"
4. select A2:A5
5. click Ctrl-D and nothing happen

Current behavior:
Fill down (Ctrl-D) does not work if selected visible and hidden cells.

Expected behavior:
Fill down (Ctrl-D) must fill down all visible selected cells and skip all hidden (even selected) cells.

Platform (if different from the browser): 
Ubuntu 11.10

Browser: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:11.0) Gecko/20100101 Firefox/11.0
Comment 1 Rainer Bielefeld Retired 2012-04-09 00:03:56 UTC
Menu also is greyed out, so shortcut can't work, expected behavior for now.

But reporter's expected behavior is correct, and I am pretty sure that this already has been reported somewhere among all those "hidden cells handling" Bugs. 

Can you please help to check whether this problem has already been reported?
Comment 2 Rainer Bielefeld Retired 2013-04-14 06:50:23 UTC
Still [Reproducible] with parallel Dev-installation of  "Version (Build ID: 049ce78144650d92eb6bd73292868f73d37c901) TinderBox: Win-x86@6, Branch:master, Pull Time: 2013-03-29_23:59:42" ENGLISH UI / German Locale on German WIN7 Home Premium (64bit) with LODev/4 Masters User Profile 

Already [Reproducible] with Server Installation of "LibreOffice 3.3.3  English UI/ German Locale [OOO330m19 (Build:301) tag libreoffice-] on German WIN7 Home Premium (64bit) 

I can't find a DUP, so NEW.

Additional info:
Same with AOOo 3.4.0, so probably inherited from OOo
Same with Symphony and still with AOOo 4 Master
Softmaker FreeOffice: Fill is active, but overwrites hidden cells, even worse!
(Old) Gnumeric: Copa/past overwrites hidden cells, I did not find a "Fill" function

@Spreadsheet Team
Please change  Status to ASSIGNED and add yourself to "Assigned To" if you accept this Bug or forward the Bug if it's not your turf (and remove others in team from CC).
Comment 3 Eike Rathke 2013-04-15 17:39:52 UTC
Probably a fall-out of behavior when filtered rows are selected, maybe the change for bug 35345 (2c2ea10d446b32d24f6268116093969b454f47b8) is also related, see also

Note that filtered is different from hidden, on purpose, and material in the wiki and bug comments confuse these a lot. Please stick to the term filtered in this case, thanks.

Comment 4 Eike Rathke 2015-12-16 16:24:16 UTC
Oops, noticing that this is still assigned to me but I never got around to work on it. Releasing for those who want to tackle it.
Comment 5 QA Administrators 2017-01-03 19:48:12 UTC Comment hidden (obsolete)
Comment 6 pavelz 2017-04-18 11:18:46 UTC
Still present in and on Fedora 25.

Copying to selected visible cells works as expected, but it warns about overwriting cells which are not empty, even if there are only empty selected visible cells.
Comment 7 QA Administrators 2018-06-18 02:42:57 UTC Comment hidden (obsolete)
Comment 8 elmonster18 2019-03-02 17:52:39 UTC
There are definitely still some bugs here.
1. Following the reproduction steps, an autofilter with Header=not empty does not do anything.
2. if I put A3 = 0  (instead of empty as in step 1) and then filter so that it only shows 1, the filter works and following steps 3, 4, 5 reproduces the same behavior as in the original bug report

Build ID: 6.2.0-3
CPU threads: 8; OS: Linux 4.20; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded