Calc search not working in read mode

[sergioatzori]

Describe the bug Calc search doesn't jump to line if edit is not enabled

To Reproduce Steps to reproduce the behavior:

1. Go to a xls/csv document (read mode)
2. Use hamburger menu to trigger search on mobile
3. Try to search
4. Nothing happens (if the item is not in current view)
5. Activate edit mode
6. try to search: obtain result

Expected behavior Search should scroll to item even in view document mode

Actual behavior User cannot search on a Calc document if he doesn't enable edit mode

Desktop (please complete the following information)

• OS: Linux
• Browser: Firefox/Opera(webkit)
• Collabora version: 22.0.5 on Debian 11

Smartphone (please complete the following information)

• Device: Oneplus 6
• OS: Android 11
• Browser: Firefox/Opera
• Collavora version: 22.0.5 on Debian 11

Screenshots

• Search text in current viewport:
• Search text not in viewport (read mode):
• Search text not in viewport (edit mode):

[Ezinnem]

I do not encounter this issue on my end.

Please can you share the COOLWSD version that you are using @sergioatzori ?

[sergioatzori]

I do not encounter this issue on my end.

Please can you share the COOLWSD version that you are using @sergioatzori ?

Yes of course: coolwsd 22.05.7 but the example you show doesn't matter about my issue: the point is that the search item must not be in the current viewport (the viewport must scroll to highlight the element found at search trigger): this behavior happens when in read mode.

[pedropintosilva]

I tested, confirmed.

Searching for a text outside of the current view is not possible. This bug only happens in spreadsheet documents (when in readonly mode) --> search return no results (which is not true)