Hi cporterbee,

Thanks for your report and sorry to read about the trouble.

Can you attach a file that we can test?

Can you try how it works with a fresh userprofile?
  https://wiki.documentfoundation.org/UserProfile

Regards, Cor

Created attachment 118659 [details]
.csv file used to show the blank drop downs

Hi Cor;

Using a fresh userprofile did not help.  I have attached the .csv file used to assist with the problem.  Let me know if more information is required.

Thanks

Thanks for your file, cporterbee.

So I start a spreadsheet, do file open, select filter Text (CSV) and your document.
Then set the delimiters fine so that a 6 column sheet is opened.
The I apply Data > Filter > Autofilter.

Now..

(In reply to cporterbee from comment #0)
> One column has the bulk of the entries the same (>95%).

Which column? 
(When I exclude thumbs.db from C, I start seeing problems. E.g. filter on column D is slow...
But that after quite some random filtering on other columns)

>  Deselecting this entry from the filter
> drop-down for that column successfully filters the rows.

> However, all the drop-downs for all the formatting/control selections 
> (File, View, buttons for borders etc) are then blank.
> [...]
> something does finally happen and the screen comes back.  Also, the
> drop-down for the filtered column DOES still display the list and
> re-selecting the item re-displays all the rows and all the other drop downs
> start functioning again.

So there is a big lag in performance..

Let's further test this.
By the way, I'm on Ubuntu 32 bits.

Tried in various versions.

_rough_ numbers below

         Open |  C: Filter thumbs.db  |  D: open filter  |  D: filter deskt.ini

4.0.6   Impossible                    |   -              |    -
4.1.5   90 sec   |    impossible      |   -              |    -
4.2.7    6 sec   |        7 sec       |   8              |    15
4.4.5    5 sec   |       10 sec       |   8              |    20
5.0.1    5 sec   |        8 sec       |   8              |    15


So there is progress, but still some work to do.
Especially on Windows maybe?

Anyway, I really appreciate to have a reproducible case on Linux here!

set version to earliest I tried.

Hi Cor;

Try filtering out column E for the "Exclude" items.  This really puts the system through the test.  Based on your information I did some more testing and here is what I found:

Windows 10, i7 processor, Libra Calc build 5.0.1.2, states it is "up to date"

Column D, thumgs.db, everything works immediately.
Column E, Exclude, it takes 10 seconds

Debian 8.2 (x86-64), Cinamon 2.2.16, Linux Kernel version 3.16.0-4-amd64, AMD Athlon(tm) 64 processor 3700+ x 1, memory 2.7G, Libra Calc 4.3.3.2, Build ID 430m0(Build:2)

Column D, thumbs.db, everything works immediately.
Column E, Exclude, everything works immediately.

So from my limited testing ability here, Windows 10 would "appear" to be the issue?  Though why yours showed the delays on Linux I don't know?

Thanks

Hi Cor;

A little more information.  My Windows 10 machine has 8GB or RAM and is running the 64 bit OS.

Thanks

Some additional info.  I have a VISTA 32bit machine running the same 5.0.1.2 Libre Office.

Intel(R) Core(TM)2 Duo CPU    T7100 @ 1.8GHZ, 2GB RAM, 32bit OS, all up to date with service pack 2 etc.

This takes 105 seconds for the drop downs to be fixed.

(In reply to Cor Nouws from comment #5)
> Tried in various versions.
> 
> _rough_ numbers below
> 
>   Open |  C: Filter thumbs.db  |  D: open filter  |  D: filter deskt.ini
> 
> 
> 4.0.6   Impossible                    |   -              |    -
> 4.1.5   90 sec   |    impossible      |   -              |    -
> 4.2.7    6 sec   |        7 sec       |   8              |    15
> 4.4.5    5 sec   |       10 sec       |   8              |    20
> 5.0.1    5 sec   |        8 sec       |   8              |    15


5.4 master   instant |    instant       |    instant       |    instant

Resolved in 5.2.4.2.  Was resolved in some earlier releases as well.