Search and replace for special characters works fine in the Document Editor but fail in Spreadsheet Editor - Githubissues

ONLYOFFICE / DesktopEditors

An office suite that combines text, spreadsheet and presentation editors allowing to create, view and edit local documents

https://www.onlyoffice.com

Other

2.65k stars 312 forks source link

Search and replace for special characters works fine in the Document Editor but fail in Spreadsheet Editor #1520

Open jpberdejo opened 4 months ago

jpberdejo commented 4 months ago

This issue is unique.

[X] I have used the search tool and did not find an issue describing my bug.

Operating System

Windows 10 / 8.1 / 7

Version information

8.0.1

Expected Behavior

The Spreadsheet Editor search for special characters works the same as in Document Editor.

Actual Behavior

The Spreadsheet Editor doesn’t search for special characters, but this function works fine in Document Editor.

Reproduction Steps

Open an xlsx file with line breaks or tabs inside some cells.
Open search and replace (ctrl+H).
Search for ^l or ^t.

Additional information

No response

rsnegirev commented 3 months ago

Hi @jpberdejo

Searching for special characters is also not possible in other spreadsheet editors such as Excel, LibreOffice or Google Sheets.