| Name | Description | |
|---|---|---|
 | SpreadsheetFindReplace | Initializes a new instance of the SpreadsheetFindReplace class. |
SpreadsheetFindReplace Class Members
In This Topic
The following tables list the members exposed by SpreadsheetFindReplace.
Public Constructors
Public Properties
| Name | Description | |
|---|---|---|
 | CurrentCell | Gets the cell reference that contains searched text. |
| CurrentCellIndexInSelectedCells | Gets the index of CurrentCell in SelectedCells. |
| CurrentWorksheet | Gets the workseet of CurrentCell. |
| Editor | Gets the spreadsheet editor. |
| FoundCellCount | Gets the count of found cells. |
| LookInComments | Gets or sets a value indicating whether text must be searched in cell comments. |
| LookInFormulas | Gets or sets a value indicating whether text must be searched in cell formulas or cells without formula. |
| LookInValues | Gets or sets a value indicating whether text must be searched in cell values. |
| MatchCase | Gets or sets a value indicating whether text must be searched in case sensitivity mode. |
| MatchEntireContent | Gets or sets a value indicating whether the entire text must be searched. |
| SearchByRows | Gets or sets a value indicating whether text must be searched in rows. |
| SearchInWorkbook | Gets or sets a value indicating whether text must be searched in all worksheets of workbook. |
| SelectedCells | Gets the cells, where text must be searched. |
| Text | Gets the text to find. |
Public Methods
| Name | Description | |
|---|---|---|
 | FindAll | Finds all cells, which contain Text. |
| FindNext | Finds the next cell that contains Text. |
| GetCurrentSpreadsheetCell | Returns the current spreadsheet cell. |
| Init | Initializes this class. |
| Replace | Replaces all occurrences of replaceText in formula of CurrentCell. |
| ReplaceAll | Replaces all occurrences of replaceText in all cells, which contain Text. |
Protected Methods
| Name | Description | |
|---|---|---|
 | CellMatch | Detects the match in specified cell. |
| CellReplace | Replaces the Text to replaceText in cell formula that is located at cellReference. |
| TextMath | Detects the match in specified text. |
| TextReplace | Replaces the Text to replaceText in cellText. |
See Also