[Search Engine] The performance issue when working on empty Rows/Columns

[Search Engine] The performance issue when working on empty Rows/Columns

Posted by: anh.pham on 21 October 2024, 2:48 am EST

• 

  anh.pham

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 21 October 2024, 2:48 am EST - Updated 21 October 2024, 2:53 am EST

  Hi team,
  
  We are experiencing a significant performance issue with the search function when working on a spreadsheet with many empty rows and columns. Specifically, we have an Excel file with a small amount of data but a large number of empty rows and columns, which is causing the search function to be extremely slow and unresponsive (Columns Count: 16139, Row Count: 983189). When we use the ‘search all’ function for the workbook, it causes the web browser to crash. Could you please help us resolve this issue? Please refer to the attachment to get details

  

  

  1920×953 77.9 KB

  DataForTest.zip

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 21 October 2024, 3:11 am EST

  Hi,

  It looks like the same issue as mentioned in the following forum case: https://developer.mescius.com/forums/spreadjs/hang-browser-issue-when-using-the-search-method

  Kindly refer to the mentioned forum case. Further, when there is an update on this from the dev team, I will let you know.

  Regards,

  Ankit