Replace question mark in search/replace menu

Suggestions Spreadsheet editor
1

I have a .xlsx file and in one column my numbers looks like “1256.15?”

I want to replace the question mark “?” by euro symbol “€”, but i can’t. If I replace “?” by “€” it replaces every char. In Excel I can escape “?” with “~?” but in Onlyoffice it doesn’t works.

How can I do this replacement without editing xlsx file at xml level?

3

Hey @gandres, :wave:

Thanks for sharing your suggestion about replacing the question mark in ONLYOFFICE!

I’m not sure of a direct way to replace “?” with “€” in the search/replace menu without touching the .xlsx at the XML level. As a workaround for a simple document, you could try converting the .xlsx to CSV, opening it in Notepad or Notepad++, making the replacement, and converting back to .xlsx.

Regarding the issue with escaping “?” (like using “~?” in Excel) not working in ONLYOFFICE, I’ll check with our team about regular expressions. I’ll get back to you with an update as soon as I have more info!