Steps to Reproduce

1. load the attached file
2. use the filter in the sheet

Current Result

under the customer's environment":

1. 18000 rows X 250 columns
a. Click the filter column to popup Filter Dialog - about 3.5 - 4 seconds
b. Filter data - about 5 - 15 seconds
c. Clear Filter - about 15 seconds
2. 5000 rows X 250 columns
a. Click the filter column to popup Filter Dialog - about 1.5 -2 seconds
b. Filter data - about 1.5 - 4 seconds
c. Clear Filter - about 1.5 - 3 seconds

Expected Result

1. 18000 rows X 250 columns
a. Click the filter column to popup Filter Dialog - less than 1 seconds
b. Filter data - about 1 second
c. Clear Filter - about 1 - 1.5 seconds
2. 5000 rows X 250 columns
a. Click the filter column to popup Filter Dialog - less than 0.5 seconds
b. Filter data - about 0.5 seconds
c. Clear Filter - about 0.5 seconds

Debug Information

• This expected time is based on the customer's current applet/Web Start application. They hope a keikai-based application can perform as well as their existing application. So that their end users can accept the performance.
• Test file - 18000 rows

Related Technology

• https://www.infoq.com/news/2020/05/css-containment-web-standard-w3c/