GrapeCity.Documents.Excel.FindOptions.SearchFormat

SearchFormat Property

SearchFormat

Gets or sets the search format.

Returns the IDisplayFormat used to match cell formatting during a find operation. The default value is null.

Declaration

public IDisplayFormat SearchFormat { get; set; }

Public Property SearchFormat As IDisplayFormat

Examples

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