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
Created attachment 165215 [details] Screenshot of the problem in Calc
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.