[Libreoffice-bugs] [Bug 136535] New: EDITING “Fill Cells” onto autofiltered cells destroys autofilter

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Sep 7 07:06:22 UTC 2020


https://bugs.documentfoundation.org/show_bug.cgi?id=136535

            Bug ID: 136535
           Summary: EDITING “Fill Cells” onto autofiltered cells destroys
                    autofilter
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
                CC: nemeth at numbertext.org, szucs.attila3 at nisz.hu
            Blocks: 113499

Created attachment 165214
  --> https://bugs.documentfoundation.org/attachment.cgi?id=165214&action=edit
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 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


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=113499
[Bug 113499] [META] AutoFill bugs and enhancements
-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200907/8acedade/attachment-0001.htm>


More information about the Libreoffice-bugs mailing list