ONLYOFFICE Workspace 12.5: enhanced security, optimized document management, Dark theme, and more
ONLYOFFICE Workspace 12.5 released

Macros to replace characters in XLS

Please tell me a simple script to implement the replacement of characters. You need to replace the wrong characters throughout the document. Thanks in advance.

Hello @Freddy651

Unfortunately, we don’t have ready-to-use examples of such macros.
The list of available macros samples you can find here:

Perhaps you can tell me a part of the code that will work with tables. I found an example that only works with text documents, not with tables. Can you give a couple of hints on how to implement similar code in tables?!

Code -
var oDocument = Api.GetDocument();
oDocument.SearchAndReplace({“searchString”: “first”, “replaceString”: “second”});

Hello @Freddy651

Unfortunately, mentioned method SearchAndReplace works with Document Editor only.