search

ONLYOFFICE / DocumentServer

ONLYOFFICE Docs is a free collaborative online office suite comprising viewers and editors for texts, spreadsheets and presentations, forms and PDF, fully compatible with Office Open XML formats: .docx, .xlsx, .pptx and enabling collaborative editing in real time.
https://www.onlyoffice.com
GNU Affero General Public License v3.0
4.72k stars 1.07k forks source link

Sheet search result doesn't update after cell editing or deleting #2596

Open Turab opened 7 months ago

Turab commented 7 months ago

This issue is unique.

Operating System

Windows 10 / 8.1 / 7

Version information

8.0.0.99

Expected Behavior

When a cell which includes the searched term gets deleted, search results should be updated to match the new situation.

Actual Behavior

It remembers the search result (count of found items) before deletion; which is wrong. And since it remembers the cell it found previously, it incorrectly marks non-matching cell which took place of the order number of the deleted cell. (See the screenshot.)

Reproduction Steps

  1. Open a spreadsheet.
  2. Fill some data, having some cells exact same content but not consecutively.
  3. CTRL + F to search for a content
  4. Type-in a term which is included in more than one cell
  5. It will find for example 3 results.
  6. While the search box is open, delete one row which is marked by the search operation.
  7. Focus on the search box and hit enter.
  8. It won't update the found result count and when cycled between results, it will incorrectly focus on the place of the deleted row, in which there is now new data, which is not matching the searched term.

image

Additional information

Note how it removes yellow marking after the row deletion. At first, it marks all the found cells with yellow background but after you delete one of them, that marking is also gone.

Gingetsu commented 6 months ago

Hello, @Turab! I created issue 66475 in our issue tracker. Thank you for report! The issue is actual in DocumentServer.