Bug 136535

Summary: EDITING “Fill Cells” onto autofiltered cells destroys autofilter
Product: LibreOffice Reporter: NISZ LibreOffice Team <libreoffice>
Component: CalcAssignee: Attila Szűcs <attila.szucs>
Status: RESOLVED FIXED    
Severity: normal CC: attila.szucs, nemeth
Priority: medium    
Version: Inherited From OOo   
Hardware: All   
OS: All   
Whiteboard: target:7.1.0
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 103512    
Attachments: Autofilter before Fill Left
Screenshot of the problem in Calc

Description NISZ LibreOffice Team 2020-09-07 07:06:22 UTC 
Created attachment 165214 [details]
Autofilter before Fill Left

Using Sheet – Fill Cells – Fill Left (or Right) can destroy existing autofilter.


Steps to reproduce:
    1. Have a few columns of data in Calc and apply autofilter on them. I noticed this  with attachment #137778 [details] from bug #113785
    2. As an example in this file I filtered out test1 from column B
    3. Enter text in D1
    4. Select D1:A1
    5. Use Sheet – Fill Cells – Fill Left (this also happens when autofiltered columns are to the right, so Fill Right is also bad)

Actual results:
Autofilters disappear from A:C columns. Rows hidden by the filtering stay hidden, but  now you need to use Show Rows command from the context menu of the row numbers.
This does not happen if the D1 cells content is copied with the autofill square.

Expected results:
Fill Left / Right keeps existing autofilter.

LibreOffice details:
Version: 7.1.0.0.alpha0+ (x64)
Build ID: baa84b5b4d287da0f00fc3fbf11f464f267c9202
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL

Also happens in:
Verzió: 6.0.0.3
Build az.: 64a0f66915f38c6217de274f0aa8e15618924765
CPU szálak: 4; OS: Windows 6.3; Felületmegjelenítés: alapértelmezett; 
Területi beállítások: hu-HU (hu_HU); Calc: CL

Version: 5.0.0.5
Build ID: 1b1a90865e348b492231e1c451437d7a15bb262b
Locale: hu-HU (hu_HU)

Verzió: 4.0.0.3 (Build az.: 7545bee9c2a0782548772a21bc84a9dcc583b89)

LibreOffice 3.5.0rc3 
Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735
Comment 1 NISZ LibreOffice Team 2020-09-07 07:07:03 UTC 
Created attachment 165215 [details]
Screenshot of the problem in Calc
Comment 2 Commit Notification 2020-09-10 12:41:54 UTC 
Attila Szűcs committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/789abce00bbb1139eb4005f78b82478a17342048

tdf#53431 tdf#136535 sc: fix Fill Cells with Autofilter

It will be available in 7.1.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.