Class TextCleansingOptions

Options controlling a Worksheet.CleanText operation.

Inheritance

object

TextCleansingOptions

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: DRIT.Spreadsheet.DataCleansing

Assembly: DRIT.Spreadsheet.dll

Syntax

public class TextCleansingOptions

Constructors

TextCleansingOptions()

Initializes a new instance of the TextCleansingOptions class with default settings. Mode must be set before use.

Declaration

public TextCleansingOptions()

TextCleansingOptions(TextCleansingMode)

Initializes a new instance of the TextCleansingOptions class with the specified transformation mode.

Declaration

public TextCleansingOptions(TextCleansingMode mode)

Parameters

Type	Name	Description
TextCleansingMode	mode	The text transformation to apply.

Properties

Mode

Specifies the transformation to apply.

Declaration

public TextCleansingMode Mode { get; set; }

Property Value

Type	Description
TextCleansingMode

SkipFormulaCells

Indicates whether cells containing formulas are skipped — their values are computed and should not be overwritten. Default: true. When false, formula cells are still skipped (a formula's result cannot be meaningfully trimmed); the option is retained for future use.

Declaration

public bool SkipFormulaCells { get; set; }

Property Value

Type	Description
bool

SkipNonStringCells

Indicates whether only cells whose value is a string are processed. Numbers, dates, booleans, and errors are left untouched. Default: true. When false, non-string values are converted to strings before applying the transformation.

Declaration

public bool SkipNonStringCells { get; set; }

Property Value

Type	Description
bool