Search and Replace

From Apache OpenOffice Wiki
Jump to: navigation, search



The cell range interface com.sun.star.util.XReplaceable is derived from com.sun.star.util.XSearchable providing search and replacement of text.

  • The method createReplaceDescriptor() creates a new descriptor that contains all data for the replace action. It returns the interface com.sun.star.util.XReplaceDescriptor of this descriptor.
  • The method replaceAll() performs a replacement in all cells according to the passed replacedescriptor.

The following example replaces all occurrences of "cell" with "text":

  // --- Replace text in all cells. ---
  com.sun.star.util.XReplaceable xReplace = (com.sun.star.util.XReplaceable)
      UnoRuntime.queryInterface(com.sun.star.util.XReplaceable.class, xCellRange);
  com.sun.star.util.XReplaceDescriptor xReplaceDesc = xReplace.createReplaceDescriptor();
  xReplaceDesc.setSearchString("cell");
  xReplaceDesc.setReplaceString("text");
  // property SearchWords searches for whole cells!
  xReplaceDesc.setPropertyValue("SearchWords", new Boolean(false));
  int nCount = xReplace.replaceAll(xReplaceDesc);
  System.out.println("Search text replaced " + nCount + " times.");
Documentation note.png The property SearchWords has a different meaning in spreadsheets: If true, only cells containing the whole search text and nothing else is found. If false, cells containing the search string as a substring is found.
Content on this page is licensed under the Public Documentation License (PDL).
Personal tools
In other languages