Author Topic: Excel Soreadsheet Odd Behavior with Filter  (Read 1726 times)

arky

  • Pro Deluxe
  • Newbie
  • *
  • Posts: 14
    • View Profile
Excel Soreadsheet Odd Behavior with Filter
« on: November 09, 2017, 11:56:33 pm »
Version 4.0.1

Finally got filters working in Spreadsheets. But I have new  problem with what it filters.
Simple Filter

{                         
   type: "textbox",       
   listener: "keyup",     
   condition: 'contain'   
}                         

The cells contain multi-line text. The top row contains the word DEEP, the second row contains the word ATTENDEE.
As I enter DEEP a character at a time it properly filters. When I get to DEE it's matching two rows as it should.
When you get to DEEP all rows disappear even though the top row should match.

If I then go to DEEPP, It displays a message "No Rows to Display". Go back to DEEP and the message goes away but still no row. It's like it has selected the row but something is keeping it from displaying. Drop back to DEE and it's fine again.

I've built a simple display page you can view here that demonstrates the glitch.

http://linka.site/excel/

This page also demonstrates the extra columns problem.
It always creates 16,384 columns despite extraCols: 0.


paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: Excel Soreadsheet Odd Behavior with Filter
« Reply #1 on: November 10, 2017, 11:13:44 am »
Please use virtualY: false when height is 'flex'