GemBox.Spreadsheet
  • Overview
  • Examples
  • Free version
  • Support
  • Pricelist

    Show / Hide Table of Contents

    IgnoredError Class

    Namespace:
    GemBox.Spreadsheet
    Assembly:
    GemBox.Spreadsheet.dll

    Represents a single ignored error for a range of cells.

    • C#
    • VB.NET
    public sealed class IgnoredError
    Public NotInheritable Class IgnoredError
    Inheritance:
    System.Object
    IgnoredError
    Remarks

    A cell is considered to have an error condition when it meets one of the conditions specified in the ErrorTypes member. For example, if a cell is formatted as text but contains a numeric value, this is considered to be a potential error because the number won't be treated as a number, for example, in calculations.

    Note that this is simply a guess by the implementing application, and a recommendation to the user. Cells with the errors specified in IgnoredErrorTypes may have perfectly valid reasons for being in such a state, for example a cell formatted as text which contains numeric Postal Codes or Order numbers. It is useful to format these cells as text so that leading zeros remain as part of the value instead of being removed.

    Properties

    AppliesTo

    Gets or sets the sequence of references to cell ranges over which this ignored error is applied.

    • C#
    • VB.NET
    public string AppliesTo { get; set; }
    Public Property AppliesTo As String
    Property Value
    System.String

    The sequence of references to cell ranges over which this ignored error is applied.

    Exceptions
    System.ArgumentException

    Parameter is null or System.String.Empty.

    ErrorTypes

    Gets or sets the ignored error types.

    • C#
    • VB.NET
    public IgnoredErrorTypes ErrorTypes { get; set; }
    Public Property ErrorTypes As IgnoredErrorTypes
    Property Value
    IgnoredErrorTypes

    The ignored error types.

    Methods

    ToString()

    Returns a System.String that represents this IgnoredError instance.

    • C#
    • VB.NET
    public override string ToString()
    Public Overrides Function ToString As String
    Returns
    System.String

    A System.String that represents this IgnoredError instance.

    Overrides
    System.Object.ToString()
    Remarks

    This method should be used primarily for debugging purposes and should be considered volatile (format of its return value might change in future versions).

    Back to top

    Facebook • Twitter • LinkedIn

    © GemBox Ltd. — All rights reserved.