Difference between revisions of "Documentation/DevGuide/Spreadsheets/Search and Replace"
From Apache OpenOffice Wiki
< Documentation | DevGuide
m |
|||
Line 12: | Line 12: | ||
* The method <code>createReplaceDescriptor()</code> creates a new descriptor that contains all data for the replace action. It returns the interface <idl>com.sun.star.util.XReplaceDescriptor</idl> of this descriptor. | * The method <code>createReplaceDescriptor()</code> creates a new descriptor that contains all data for the replace action. It returns the interface <idl>com.sun.star.util.XReplaceDescriptor</idl> of this descriptor. | ||
− | * The method <code>replaceAll()</code> performs a replacement in all cells according to the passed | + | * The method <code>replaceAll()</code> performs a replacement in all cells according to the passed replacedescriptor. |
The following example replaces all occurrences of "cell" with "text": | The following example replaces all occurrences of "cell" with "text": |
Latest revision as of 13:23, 5 March 2021
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.");
Content on this page is licensed under the Public Documentation License (PDL). |