There are also several search/replace options for SearchDescriptor.

The user can specify the files or an entire folder to be processed. OpenOfficeReplace('file:///C:/File.odt', 'Search', 'Replace') By Sobolsoft This software offers a solution to users who want to find and replace text in one or more OpenOffice Calc files. ShowMessage('Replace has been finished') Īnd the usage of the example procedure TForm1.Button1Click(Sender: TObject) StarDocument := StarDesktop.LoadComponentFromURL(AFileURL, '_blank', 0, FileParams) įileReplace := StarDocument.CreateReplaceDescriptor įileReplace.SearchCaseSensitive := False StarDesktop := StarOffice.CreateInstance('.Desktop') įileParams := VarArra圜reate(, varVariant) įileProperty := StarOffice.Bridge_GetStruct('.PropertyValue') Procedure OpenOfficeReplace(const AFileURL: string ASearch: string const AReplace: string)

I've tested it with LibreOffice writer and it works fine for me.

Please note, that there's no error handling. If you want to do wholesale changes to your spreadsheet, use the Search and Replace functionality of Calc. You should take a focus on XReplaceable interface.

Openoffice calc find and replace