GrapeCity.Documents.Excel.ReplaceOptions.SearchFormat

SearchFormat Property

SearchFormat

Gets or sets the display format used as the search criterion during a replace operation.

Returns the IDisplayFormat used by Replace(object, object, ReplaceOptions) to limit matching to cells whose displayed formatting matches the specified format. The default value is null.

Declaration

public IDisplayFormat SearchFormat { get; set; }

Public Property SearchFormat As IDisplayFormat

Examples

worksheet.Range["A1"].Value = "Draft";
worksheet.Range["A1"].NumberFormat = "$0.00";
ReplaceOptions options = new ReplaceOptions();
options.SearchFormat = worksheet.Range["A1"].DisplayFormat;
IDisplayFormat searchFormat = options.SearchFormat;