https://bugs.freedesktop.org/show_bug.cgi?id=55269

          Priority: medium
            Bug ID: 55269
          Assignee: libreoffice-bugs@lists.freedesktop.org
           Summary: Calc AutoFilter Performance Affected by Windows 7
                    Settings
          Severity: normal
    Classification: Unclassified
                OS: Windows (All)
          Reporter: preec...@gmail.com
          Hardware: All
            Status: UNCONFIRMED
           Version: 3.6.1.2 release
         Component: Spreadsheet
           Product: LibreOffice

In Calc, when I perform AutoFilter on a column with large number of distinct
values (almost 30,000 values), it takes forever, in certain condition, to
generate the dropdown list. 

On another machine, the dropdown list is generated in a few seconds (less than
5 seconds, which is very acceptable). 

I compared the two machines found that the Windows 7 performance option named
"Use visual styles on windows and buttons" is different on the two machines. 
(You can find this setting in System Properties -> Performance Options.) 

With the option turned off, the AutoFilter dropdown list is generated fast. 
With the option turned on, it is never generated successfully with 30,000
distinct values. 

Can this be fixed? 
Most Windows 7 users leave this performance option turned on by default.

Note: This problem does not occur in Windows XP even if the visual setting is
turned on.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to