[Libreoffice-bugs] [Bug 137086] New: Very slow deleting filtered rows in spreadsheet

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 137086
           Summary: Very slow deleting filtered rows in spreadsheet
           Product: LibreOffice
           Version: 6.4.6.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: suokunlong at 126.com

Created attachment 165902
  --> https://bugs.documentfoundation.org/attachment.cgi?id=165902&action=edit
test ODS file

The attached spreadsheet contains two simple columns with 10000 records. When
filter some records in the autofilter and then trying to delete those records,
the delete operation is very slow.

Steps to Reproduce:

1. Open the attached spreadsheet, filter the records by deselecting "0" in
column B using the autofilter.

2. Try to delete the filtered records by selecting all the whole rows.

Current Behaviour:
The delete operation takes 35s on my PC.

Expected:
The delete operation should be fast, within 5s. It takes only 5s in Microsoft
Excel 2020.

--------------------

Reproduced in both:

Version: 6.4.6.2
Build ID: 0ce51a4fd21bff07a5c061082cc82c5ed232f115
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3; 
Locale: zh-CN (zh_CN.UTF-8); UI-Language: en-US
Calc: threaded

Version: 7.1.0.0.alpha0+
Build ID: 2cddaa6e199ed8bb6185b7825791199f9da4a670
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: zh-CN (zh_CN.UTF-8); UI: zh-CN
Calc: threaded

Fedora 32 x64.

-- 
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/20200928/899557b5/attachment.htm>