Bug 95667 - Sluggish performance with filters
Summary: Sluggish performance with filters
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.2.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-11-07 23:14 UTC by Ramon Es
Modified: 2015-11-08 01:14 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Ramon Es 2015-11-07 23:14:54 UTC 
I have an Excel spreadsheet with a few filters, six columns (two date/time, the rest is text) and ~3200 rows. Performance is very sluggish bordering on unusable. I've seen spreadsheets with tens of thousands of rows in it that need to be worked on. Calc seems not to be up to the task for that.
I will see to updating this report with a sample file after finishing my work and removing any proprietary information.
Comment 1 Ramon Es 2015-11-08 00:36:34 UTC 
After opening a spreadsheet with similar data but only 57 rows the performance issues were still there. So it is not a matter of the amount of data.
The only thing that might gunk up the works are the column data filters. Even the ones from LO (auto filter) seem not to work right, at least what sorting ascending and descending is concerned.
Comment 2 Ramon Es 2015-11-08 01:14:16 UTC 
Setting this to invalid because using the most current version drastically improved the performance issues. Asc/desc filter sorts still don't work, but that might have been reported already and should go into a new bug report.

Sorry!