menu

Xamarin.Forms

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Class NameImpl - Xamarin.Forms API Reference | Syncfusion

    Show / Hide Table of Contents

    Class NameImpl

    Represents named range in the excel.

    Inheritance
    System.Object
    CommonObject
    NameImpl
    Implements
    IName
    INameIndexChangedEventProvider
    IParseable
    INativePTG
    ICloneParent
    ICombinedRange
    IRange
    IParentApplication
    System.Collections.Generic.IEnumerable<IRange>
    System.Collections.IEnumerable
    System.IDisposable
    Inherited Members
    CommonObject.AddReference()
    CommonObject.AppImplementation
    CommonObject.Application
    CommonObject.CheckDisposed()
    CommonObject.Dispose()
    CommonObject.Finalize()
    CommonObject.FindParent(Object, Type)
    CommonObject.FindParent(Object, Type, Boolean)
    CommonObject.FindParent(Type)
    CommonObject.FindParent(Type, Boolean)
    CommonObject.FindParent(Type[])
    CommonObject.FindParents(Type[])
    CommonObject.m_bIsDisposed
    CommonObject.OnDispose()
    CommonObject.Parent
    CommonObject.ReferenceCount
    CommonObject.ReleaseReference()
    CommonObject.SetParent(Object)
    Namespace: Syncfusion.XlsIO.Implementation
    Assembly: Syncfusion.XlsIO.Portable.dll
    Syntax
    public class NameImpl : CommonObject, IName, INameIndexChangedEventProvider, IParseable, INativePTG, ICloneParent, ICombinedRange, IRange, IParentApplication, IEnumerable<IRange>, IEnumerable, IDisposable

    Constructors

    NameImpl(IApplication, Object)

    Creates a new Name object.

    Declaration
    public NameImpl(IApplication application, object parent)
    Parameters
    Type Name Description
    IApplication application

    Application object for the new Name object.

    System.Object parent

    Parent object for the new Name object.

    NameImpl(IApplication, Object, NameRecord)

    Creates a new Name object.

    Declaration
    public NameImpl(IApplication application, object parent, NameRecord name)
    Parameters
    Type Name Description
    IApplication application

    Application object for the new Name object.

    System.Object parent

    Parent object for the new Name object.

    NameRecord name

    NameRecord that contains information about the new Name object.

    NameImpl(IApplication, Object, NameRecord, Int32)

    Creates a new Name object.

    Declaration
    public NameImpl(IApplication application, object parent, NameRecord name, int index)
    Parameters
    Type Name Description
    IApplication application

    Application object for the new Name object.

    System.Object parent

    Parent object for the new Name object.

    NameRecord name

    NameRecord that contains information about the new Name object.

    System.Int32 index

    Index of the Name object in the workbook's Names collection.

    NameImpl(IApplication, Object, String, IRange, Int32)

    Creates a new Name object.

    Declaration
    public NameImpl(IApplication application, object parent, string name, IRange range, int index)
    Parameters
    Type Name Description
    IApplication application

    Application object for the new Name object.

    System.Object parent

    Parent object for the new Name object.

    System.String name

    Name of the new Name object.

    IRange range

    Range that will be associated with the specified name.

    System.Int32 index

    NameImpl(IApplication, Object, String, IRange, Int32, Boolean)

    Creates a new Name object.

    Declaration
    public NameImpl(IApplication application, object parent, string name, IRange range, int index, bool bIsLocal)
    Parameters
    Type Name Description
    IApplication application

    Application object for the new Name object.

    System.Object parent

    Parent object for the new Name object.

    System.String name

    Name of the new Name object.

    IRange range

    Range that will be associated with the specified name.

    System.Int32 index
    System.Boolean bIsLocal

    NameImpl(IApplication, Object, String, Int32)

    Creates new Name object.

    Declaration
    public NameImpl(IApplication application, object parent, string name, int index)
    Parameters
    Type Name Description
    IApplication application

    Application object for the new Name object.

    System.Object parent

    Parent object for the new Name object.

    System.String name

    Name of the new Name object.

    System.Int32 index

    Current index.

    NameImpl(IApplication, Object, String, Int32, Boolean)

    Creates new Name object.

    Declaration
    public NameImpl(IApplication application, object parent, string name, int index, bool bIsLocal)
    Parameters
    Type Name Description
    IApplication application

    Application object for the new Name object.

    System.Object parent

    Parent object for the new Name object.

    System.String name

    Name of the new Name object.

    System.Int32 index

    Current index.

    System.Boolean bIsLocal

    Indicates whether name is local.

    Fields

    DEF_NAME_SHEET_INDEX

    Represents removed sheet index.

    Declaration
    public const int DEF_NAME_SHEET_INDEX = 65534
    Field Value
    Type
    System.Int32

    Properties

    Address

    Returns the range reference in the language of the macro. Read-only String.

    Declaration
    public string Address { get; }
    Property Value
    Type
    System.String

    AddressGlobal

    Returns range Address in format "'Sheet1'!$A$1".

    Declaration
    public string AddressGlobal { get; }
    Property Value
    Type
    System.String

    AddressGlobal2007

    Gets address global in the format required by Excel 2007.

    Declaration
    public string AddressGlobal2007 { get; }
    Property Value
    Type
    System.String

    AddressGlobalWithoutSheetName

    Returns range address in format "$A$1".

    Declaration
    public string AddressGlobalWithoutSheetName { get; }
    Property Value
    Type
    System.String

    AddressLocal

    Returns the range reference for the specified range in the language of the user. Read-only String.

    Declaration
    public string AddressLocal { get; }
    Property Value
    Type
    System.String

    AddressR1C1

    Returns the range reference using R1C1 notation. Read-only String.

    Declaration
    public string AddressR1C1 { get; }
    Property Value
    Type
    System.String

    AddressR1C1Local

    Returns the range reference using R1C1 notation. Read-only String.

    Declaration
    public string AddressR1C1Local { get; }
    Property Value
    Type
    System.String

    Boolean

    Gets / sets boolean value that is contained by this range.

    Declaration
    public bool Boolean { get; set; }
    Property Value
    Type
    System.Boolean

    Borders

    Returns a Borders collection that represents the borders of a style or a range of cells (including a range defined as part of a conditional format).

    Declaration
    public IBorders Borders { get; }
    Property Value
    Type
    IBorders

    BuiltInStyle

    Gets/sets built in style.

    Declaration
    public Nullable<BuiltInStyles> BuiltInStyle { get; set; }
    Property Value
    Type
    System.Nullable<BuiltInStyles>

    CalculatedValue

    Returns the calculated value of a formula using the most current inputs.

    Declaration
    public string CalculatedValue { get; }
    Property Value
    Type
    System.String

    Cells

    Returns a Range object that represents the cells in the specified range. Read-only.

    Declaration
    public IRange[] Cells { get; }
    Property Value
    Type
    IRange[]

    CellsCount

    Number of cells in the range

    Declaration
    public int CellsCount { get; }
    Property Value
    Type
    System.Int32

    CellStyle

    Returns a Style object that represents the style of the specified range. Read/write IStyle.

    Declaration
    public IStyle CellStyle { get; set; }
    Property Value
    Type
    IStyle

    CellStyleName

    Returns name of the Style object that represents the style of the specified range. Read/write String.

    Declaration
    public string CellStyleName { get; set; }
    Property Value
    Type
    System.String

    Column

    Returns the number of the first column in the first area in the specified range. Read-only.

    Declaration
    public int Column { get; }
    Property Value
    Type
    System.Int32

    ColumnGroupLevel

    Column group level. Read-only. -1 - Not all columns in the range have same group level. 0 - No grouping, 1 - 7 - Group level.

    Declaration
    public int ColumnGroupLevel { get; }
    Property Value
    Type
    System.Int32

    Columns

    For a Range object, returns an array of Range objects that represent the columns in the specified range.

    Declaration
    public IRange[] Columns { get; }
    Property Value
    Type
    IRange[]

    ColumnWidth

    Returns or sets the width of all columns in the specified range. Read/write Double.

    Declaration
    public double ColumnWidth { get; set; }
    Property Value
    Type
    System.Double

    Comment

    Comment assigned to the range. Read-only.

    Declaration
    public ICommentShape Comment { get; }
    Property Value
    Type
    ICommentShape

    ConditionalFormats

    Collection of conditional formats.

    Declaration
    public IConditionalFormats ConditionalFormats { get; }
    Property Value
    Type
    IConditionalFormats

    Count

    Returns the number of objects in the collection. Read-only.

    Declaration
    public int Count { get; }
    Property Value
    Type
    System.Int32

    DataValidation

    Data validation for the range.

    Declaration
    public IDataValidation DataValidation { get; }
    Property Value
    Type
    IDataValidation

    DateTime

    Gets / sets DateTime contained by this cell. Read-write DateTime.

    Declaration
    public DateTime DateTime { get; set; }
    Property Value
    Type
    System.DateTime

    Description

    Gets/sets the comment associated with the named range.

    Declaration
    public string Description { get; set; }
    Property Value
    Type
    System.String

    DisplayText

    Returns cell value after number format application. Read-only.

    Declaration
    public string DisplayText { get; }
    Property Value
    Type
    System.String

    End

    Returns a Range object that represents the cell at the end of the region that contains the source range.

    Declaration
    public IRange End { get; }
    Property Value
    Type
    IRange

    EntireColumn

    Returns a Range object that represents the entire column (or columns) that contains the specified range. Read-only.

    Declaration
    public IRange EntireColumn { get; }
    Property Value
    Type
    IRange

    EntireRow

    Returns a Range object that represents the entire row (or rows) that contains the specified range. Read-only.

    Declaration
    public IRange EntireRow { get; }
    Property Value
    Type
    IRange

    Error

    Gets / sets error value that is contained by this range.

    Declaration
    public string Error { get; set; }
    Property Value
    Type
    System.String

    Formula

    Returns or sets the object's formula in A1-style notation and in the language of the macro. Read/write Variant.

    Declaration
    public string Formula { get; set; }
    Property Value
    Type
    System.String

    FormulaArray

    Represents array-entered formula.

    Declaration
    public string FormulaArray { get; set; }
    Property Value
    Type
    System.String

    FormulaArrayR1C1

    Returns or sets the formula array for the range, using R1C1-style notation.

    Declaration
    public string FormulaArrayR1C1 { get; set; }
    Property Value
    Type
    System.String

    FormulaBoolValue

    Returns the calculated value of the formula as a boolean.

    Declaration
    public bool FormulaBoolValue { get; set; }
    Property Value
    Type
    System.Boolean

    FormulaDateTime

    Get / set formula DateTime value contained by this cell. DateTime.MinValue if not all cells of the range have same DateTime value.

    Declaration
    public DateTime FormulaDateTime { get; set; }
    Property Value
    Type
    System.DateTime

    FormulaErrorValue

    Returns the calculated value of the formula as a string.

    Declaration
    public string FormulaErrorValue { get; set; }
    Property Value
    Type
    System.String

    FormulaHidden

    True if the formula will be hidden when the worksheet is protected. False if at least part of formula in the range is not hidden.

    Declaration
    public bool FormulaHidden { get; set; }
    Property Value
    Type
    System.Boolean

    FormulaNumberValue

    Gets / sets number value evaluated by formula.

    Declaration
    public double FormulaNumberValue { get; set; }
    Property Value
    Type
    System.Double

    FormulaR1C1

    Returns or sets the formula for the range, using R1C1-style notation.

    Declaration
    public string FormulaR1C1 { get; set; }
    Property Value
    Type
    System.String

    FormulaStringValue

    Gets / sets string value evaluated by formula.

    Declaration
    public string FormulaStringValue { get; set; }
    Property Value
    Type
    System.String

    HasBoolean

    Indicates whether range contains bool value. Read-only.

    Declaration
    public bool HasBoolean { get; }
    Property Value
    Type
    System.Boolean

    HasDataValidation

    Indicates whether specified range object has data validation. If Range is not single cell, then returns true only if all cells have data validation. Read-only.

    Declaration
    public bool HasDataValidation { get; }
    Property Value
    Type
    System.Boolean

    HasDateTime

    Indicates whether range contains DateTime value. Read-only.

    Declaration
    public bool HasDateTime { get; }
    Property Value
    Type
    System.Boolean

    HasExternalFormula

    Indicates is current range has external formula. Read-only.

    Declaration
    public bool HasExternalFormula { get; }
    Property Value
    Type
    System.Boolean

    HasFormula

    True if all cells in the range contain formulas; False if at least one of the cells in the range doesn't contain a formula. Read-only Boolean.

    Declaration
    public bool HasFormula { get; }
    Property Value
    Type
    System.Boolean

    HasFormulaArray

    Indicates whether range contains array-entered formula. Read-only.

    Declaration
    public bool HasFormulaArray { get; }
    Property Value
    Type
    System.Boolean

    HasFormulaBoolValue

    Indicates if current range has formula bool value. Read-only.

    Declaration
    public bool HasFormulaBoolValue { get; }
    Property Value
    Type
    System.Boolean

    HasFormulaDateTime

    Indicates if current range has formula value formatted as DateTime. Read-only.

    Declaration
    public bool HasFormulaDateTime { get; }
    Property Value
    Type
    System.Boolean

    HasFormulaErrorValue

    Indicates if current range has formula error value. Read-only.

    Declaration
    public bool HasFormulaErrorValue { get; }
    Property Value
    Type
    System.Boolean

    HasFormulaNumberValue

    Indicates if current range has formula value formatted as number. Read-only.

    Declaration
    public bool HasFormulaNumberValue { get; }
    Property Value
    Type
    System.Boolean

    HasFormulaStringValue

    Indicates if current range has formula value formatted as string. Read-only.

    Declaration
    public bool HasFormulaStringValue { get; }
    Property Value
    Type
    System.Boolean

    HasNumber

    Indicates whether the range contains number. Read-only.

    Declaration
    public bool HasNumber { get; }
    Property Value
    Type
    System.Boolean

    HasRichText

    Indicates whether cell contains formatted rich text string.

    Declaration
    public bool HasRichText { get; }
    Property Value
    Type
    System.Boolean

    HasString

    Indicates whether the range contains String. Read-only.

    Declaration
    public bool HasString { get; }
    Property Value
    Type
    System.Boolean

    HasStyle

    Indicates whether range has default style. False means default style. Read-only.

    Declaration
    public bool HasStyle { get; }
    Property Value
    Type
    System.Boolean

    HorizontalAlignment

    Returns or sets the horizontal alignment for the specified object. Read/write ExcelHAlign.

    Declaration
    public ExcelHAlign HorizontalAlignment { get; set; }
    Property Value
    Type
    ExcelHAlign

    HtmlString

    Gets or sets HTML string.

    Declaration
    public string HtmlString { get; set; }
    Property Value
    Type
    System.String

    Hyperlinks

    Returns hyperlinks for this name.

    Declaration
    public IHyperLinks Hyperlinks { get; }
    Property Value
    Type
    IHyperLinks

    IgnoreErrorOptions

    Represents ignore error options. If not single cell returs concatenated flags.

    Declaration
    public ExcelIgnoreError IgnoreErrorOptions { get; set; }
    Property Value
    Type
    ExcelIgnoreError

    IndentLevel

    Returns or sets the indent level for the cell or range. Can be an integer from 0 to 15. Read/write Integer.

    Declaration
    public int IndentLevel { get; set; }
    Property Value
    Type
    System.Int32

    Index

    Index of the Name object in the workbook's Names collection.

    Declaration
    public int Index { get; }
    Property Value
    Type
    System.Int32

    IsBlank

    Indicates whether the range is blank. Read-only.

    Declaration
    public bool IsBlank { get; }
    Property Value
    Type
    System.Boolean

    IsBoolean

    Indicates whether range contains boolean value. Read-only.

    Declaration
    public bool IsBoolean { get; }
    Property Value
    Type
    System.Boolean

    IsBuiltIn

    Indicates whether name is built-in or not.

    Declaration
    public bool IsBuiltIn { get; set; }
    Property Value
    Type
    System.Boolean

    IsError

    Indicates whether range contains error value.

    Declaration
    public bool IsError { get; }
    Property Value
    Type
    System.Boolean

    IsExternName

    Indicates whether the name is extern name.

    Declaration
    public bool IsExternName { get; }
    Property Value
    Type
    System.Boolean

    IsFunction

    Indicates whether this is function.

    Declaration
    public bool IsFunction { get; set; }
    Property Value
    Type
    System.Boolean

    IsGroupedByColumn

    Indicates whether this range is grouped by column. Read-only.

    Declaration
    public bool IsGroupedByColumn { get; }
    Property Value
    Type
    System.Boolean

    IsGroupedByRow

    Indicates whether this range is grouped by row. Read-only.

    Declaration
    public bool IsGroupedByRow { get; }
    Property Value
    Type
    System.Boolean

    IsInitialized

    Indicates whether cell is initialized. Read-only.

    Declaration
    public bool IsInitialized { get; }
    Property Value
    Type
    System.Boolean

    IsLocal

    Indicates whether current name is locally defined name. Read-only.

    Declaration
    public bool IsLocal { get; }
    Property Value
    Type
    System.Boolean

    IsMerged

    Indicates whether this range is part of merged range. Read-only.

    Declaration
    public bool IsMerged { get; }
    Property Value
    Type
    System.Boolean

    IsQueryTableRange

    Represents whether the named range belongs to query table

    Declaration
    public bool IsQueryTableRange { get; set; }
    Property Value
    Type
    System.Boolean

    IsStringsPreserved

    Indicates whether all values in the range are preserved as strings.

    Declaration
    public Nullable<bool> IsStringsPreserved { get; set; }
    Property Value
    Type
    System.Nullable<System.Boolean>

    Item[Int32, Int32]

    Gets / sets cell by row and column index. Row and column indexes are one-based.

    Declaration
    public IRange this[int row, int column] { get; set; }
    Parameters
    Type Name Description
    System.Int32 row
    System.Int32 column
    Property Value
    Type
    IRange

    Item[Int32, Int32, Int32, Int32]

    Get cell range. Row and column indexes are one-based. Read-only.

    Declaration
    public IRange this[int row, int column, int lastRow, int lastColumn] { get; }
    Parameters
    Type Name Description
    System.Int32 row
    System.Int32 column
    System.Int32 lastRow
    System.Int32 lastColumn
    Property Value
    Type
    IRange

    Item[String]

    Get cell range. Read-only.

    Declaration
    public IRange this[string name] { get; }
    Parameters
    Type Name Description
    System.String name
    Property Value
    Type
    IRange

    Item[String, Boolean]

    Gets cell range. Read-only.

    Declaration
    public IRange this[string name, bool IsR1C1Notation] { get; }
    Parameters
    Type Name Description
    System.String name
    System.Boolean IsR1C1Notation
    Property Value
    Type
    IRange

    LastColumn

    Returns last column of the range. Read-only.

    Declaration
    public int LastColumn { get; }
    Property Value
    Type
    System.Int32

    LastRow

    Returns last row of the range. Read-only.

    Declaration
    public int LastRow { get; }
    Property Value
    Type
    System.Int32

    MergeArea

    Returns a Range object that represents the merged range containing the specified cell. If the specified cell isnÂ’t in a merged range, this property returns NULL. Read-only.

    Declaration
    public IRange MergeArea { get; }
    Property Value
    Type
    IRange

    Name

    Gets or sets the name of the Name object.

    Declaration
    public string Name { get; set; }
    Property Value
    Type
    System.String

    NameIndexChangedHandlersCount

    Returns count of event handlers for NameIndexChanged event. Read-only.

    Declaration
    public int NameIndexChangedHandlersCount { get; }
    Property Value
    Type
    System.Int32

    NameLocal

    Same as Name.

    Declaration
    public string NameLocal { get; set; }
    Property Value
    Type
    System.String

    Number

    Gets / sets double value of the range.

    Declaration
    public double Number { get; set; }
    Property Value
    Type
    System.Double

    NumberFormat

    Format of current cell. Analog of Style.NumberFormat property.

    Declaration
    public string NumberFormat { get; set; }
    Property Value
    Type
    System.String

    Record

    Get NameRecord to which point current object.

    Declaration
    public NameRecord Record { get; }
    Property Value
    Type
    NameRecord

    RefersTo

    Gets/sets named range RefersTo. Read-only.

    Declaration
    public string RefersTo { get; set; }
    Property Value
    Type
    System.String

    RefersToR1C1

    Gets/sets named range RefersToR1C1 in R1C1 style. Read-only.

    Declaration
    public string RefersToR1C1 { get; set; }
    Property Value
    Type
    System.String

    RefersToRange

    Gets / sets Range associated with the Name object.

    Declaration
    public IRange RefersToRange { get; set; }
    Property Value
    Type
    IRange

    Region

    Name region.

    Declaration
    public MergeCellsRecord.MergedRegion Region { get; set; }
    Property Value
    Type
    MergeCellsRecord.MergedRegion

    RichText

    String with rich text formatting. Read-only.

    Declaration
    public IRichTextString RichText { get; }
    Property Value
    Type
    IRichTextString

    Row

    Returns the number of the first row of the first area in the range. Read-only Long.

    Declaration
    public int Row { get; }
    Property Value
    Type
    System.Int32

    RowGroupLevel

    Row group level. Read-only. -1 - Not all rows in the range have same group level. 0 - No grouping, 1 - 7 - Group level.

    Declaration
    public int RowGroupLevel { get; }
    Property Value
    Type
    System.Int32

    RowHeight

    Returns the height of all the rows in the range specified, measured in points. Returns Double.MinValue if the rows in the specified range aren't all the same height. Read / write Double.

    Declaration
    public double RowHeight { get; set; }
    Property Value
    Type
    System.Double

    Rows

    For a Range object, returns an array of Range objects that represent the rows in the specified range.

    Declaration
    public IRange[] Rows { get; }
    Property Value
    Type
    IRange[]

    Scope

    Returns string representation of the name's scope. Read-only.

    Declaration
    public string Scope { get; }
    Property Value
    Type
    System.String

    SheetIndex

    Represents the sheet index of the name

    Declaration
    public int SheetIndex { get; set; }
    Property Value
    Type
    System.Int32

    Text

    Gets / sets string value of the range.

    Declaration
    public string Text { get; set; }
    Property Value
    Type
    System.String

    ThreadedComment

    Get the threaded comment.

    Declaration
    public IThreadedComment ThreadedComment { get; }
    Property Value
    Type
    IThreadedComment

    TimeSpan

    Gets / sets time value of the range.

    Declaration
    public TimeSpan TimeSpan { get; set; }
    Property Value
    Type
    System.TimeSpan

    Value

    For the Name object, a string containing the formula that the name is defined to refer to. The string is in A1-style notation in the language of the macro, without an equal sign.

    Declaration
    public string Value { get; set; }
    Property Value
    Type
    System.String

    Value2

    Returns or sets the cell value. Read/write Variant. The only difference between this property and the Value property is that the Value2 property doesn't use the Currency and Date data types.

    Declaration
    public object Value2 { get; set; }
    Property Value
    Type
    System.Object

    ValueR1C1

    Gets/sets named range Value in R1C1 style. Read-only.

    Declaration
    public string ValueR1C1 { get; set; }
    Property Value
    Type
    System.String

    VerticalAlignment

    Returns or sets the vertical alignment of the specified object. Read/write ExcelVAlign.

    Declaration
    public ExcelVAlign VerticalAlignment { get; set; }
    Property Value
    Type
    ExcelVAlign

    Visible

    Determines whether the object is visible. Read/write Boolean.

    Declaration
    public bool Visible { get; set; }
    Property Value
    Type
    System.Boolean

    Workbook

    Get workbook of Name Object.

    Declaration
    public WorkbookImpl Workbook { get; }
    Property Value
    Type
    WorkbookImpl

    Worksheet

    Get worksheet of Name Object.

    Declaration
    public WorksheetImpl Worksheet { get; }
    Property Value
    Type
    WorksheetImpl

    WorksheetName

    Gets name of the parent worksheet.

    Declaration
    public string WorksheetName { get; }
    Property Value
    Type
    System.String

    WrapText

    True if Microsoft Excel wraps the text in the object. Read/write Boolean.

    Declaration
    public bool WrapText { get; set; }
    Property Value
    Type
    System.Boolean

    Methods

    Activate()

    Activates a single cell, which must be inside the current selection. To select a range of cells, use the Select method.

    Declaration
    public IRange Activate()
    Returns
    Type
    IRange

    Activate(Boolean)

    Activates a single cell, scroll to it and activates the corresponding sheet. To select a range of cells, use the Select method.

    Declaration
    public IRange Activate(bool scroll)
    Parameters
    Type Name Description
    System.Boolean scroll

    True to scroll to the cell

    Returns
    Type
    IRange

    add_NameIndexChanged(NameImpl.NameIndexChangedEventHandler)

    Declaration
    public void add_NameIndexChanged(NameImpl.NameIndexChangedEventHandler value)
    Parameters
    Type Name Description
    NameImpl.NameIndexChangedEventHandler value

    AddComment()

    Adds comment to the range.

    Declaration
    public ICommentShape AddComment()
    Returns
    Type Description
    ICommentShape

    Range's comment.

    AddThreadedComment(String, DateTime)

    Creates a threaded comment for the current cell with the specified text.

    Declaration
    public IThreadedComment AddThreadedComment(string text, DateTime creationTime)
    Parameters
    Type Name Description
    System.String text

    Threaded comment text

    System.DateTime creationTime

    Optional. The creation time of the threaded comment

    Returns
    Type Description
    IThreadedComment

    Returns the created instance of IThreadedComment.

    AddThreadedComment(String, String, DateTime)

    Creates a threaded comment for the current cell with the specified text and author.

    Declaration
    public IThreadedComment AddThreadedComment(string text, string author, DateTime creationTime)
    Parameters
    Type Name Description
    System.String text

    Threaded comment text

    System.String author

    The author of the threaded comment text

    System.DateTime creationTime

    Optional. The creation time of the threaded comment

    Returns
    Type Description
    IThreadedComment

    Returns the created instance of IThreadedComment.

    AutofitColumns()

    Autofits all columns in the range.

    Declaration
    public void AutofitColumns()

    AutofitRows()

    Autofits all rows in the range.

    Declaration
    public void AutofitRows()

    Average()

    Returns average of numeric cells in the range.

    Declaration
    public double Average()
    Returns
    Type
    System.Double

    Average(Boolean)

    Returns average of numeric cells in the range.

    Declaration
    public double Average(bool considerDateAsNumber)
    Parameters
    Type Name Description
    System.Boolean considerDateAsNumber

    Considers numeric value of date formatted cells for calculation.

    Returns
    Type
    System.Double

    BorderAround()

    Sets around border for current range.

    Declaration
    public void BorderAround()

    BorderAround(ExcelLineStyle)

    Sets around border for current range.

    Declaration
    public void BorderAround(ExcelLineStyle borderLine)
    Parameters
    Type Name Description
    ExcelLineStyle borderLine

    Represents border line.

    BorderAround(ExcelLineStyle, Color)

    Sets around border for current range.

    Declaration
    public void BorderAround(ExcelLineStyle borderLine, Color borderColor)
    Parameters
    Type Name Description
    ExcelLineStyle borderLine

    Represents border line.

    Color borderColor

    Represents border color.

    BorderAround(ExcelLineStyle, ExcelKnownColors)

    Sets around border for current range.

    Declaration
    public void BorderAround(ExcelLineStyle borderLine, ExcelKnownColors borderColor)
    Parameters
    Type Name Description
    ExcelLineStyle borderLine

    Represents border line.

    ExcelKnownColors borderColor

    Represents border color as ExcelKnownColors.

    BorderInside()

    Sets inside border for current range.

    Declaration
    public void BorderInside()

    BorderInside(ExcelLineStyle)

    Sets inside border for current range.

    Declaration
    public void BorderInside(ExcelLineStyle borderLine)
    Parameters
    Type Name Description
    ExcelLineStyle borderLine

    Represents border line.

    BorderInside(ExcelLineStyle, Color)

    Sets inside border for current range.

    Declaration
    public void BorderInside(ExcelLineStyle borderLine, Color borderColor)
    Parameters
    Type Name Description
    ExcelLineStyle borderLine

    Represents border line.

    Color borderColor

    Represents border color.

    BorderInside(ExcelLineStyle, ExcelKnownColors)

    Sets inside border for current range.

    Declaration
    public void BorderInside(ExcelLineStyle borderLine, ExcelKnownColors borderColor)
    Parameters
    Type Name Description
    ExcelLineStyle borderLine

    Represents border line.

    ExcelKnownColors borderColor

    Represents border color as ExcelKnownColors.

    BorderNone()

    Sets none border for current range.

    Declaration
    public void BorderNone()

    Clear()

    Clear the contents of the Range.

    Declaration
    public void Clear()

    Clear(ExcelClearOptions)

    Clears the Content, formats, comments based on clear option.

    Declaration
    public void Clear(ExcelClearOptions option)
    Parameters
    Type Name Description
    ExcelClearOptions option

    Clear(ExcelMoveDirection)

    Clear the contents of the Range and shifts the cells Up or Left without formula or merged ranges update.

    Declaration
    public void Clear(ExcelMoveDirection direction)
    Parameters
    Type Name Description
    ExcelMoveDirection direction

    Cells shift direction Up/Left.

    Clear(ExcelMoveDirection, ExcelCopyRangeOptions)

    Clear the contents of the Range and shifts the cells Up or Left.

    Declaration
    public void Clear(ExcelMoveDirection direction, ExcelCopyRangeOptions options)
    Parameters
    Type Name Description
    ExcelMoveDirection direction

    Cells shift direction Up/Left.

    ExcelCopyRangeOptions options

    Cells shifting options.

    Clear(Boolean)

    Clear the contents of the Range with formatting.

    Declaration
    public void Clear(bool isClearFormat)
    Parameters
    Type Name Description
    System.Boolean isClearFormat

    True if formatting should also be cleared.

    ClearConditionalFormats()

    Clears the conditional formats

    Declaration
    public void ClearConditionalFormats()

    Clone(Object)

    Creates a new object that is a copy of the current instance.

    Declaration
    public object Clone(object parent)
    Parameters
    Type Name Description
    System.Object parent

    Parent object for a copy of this instance.

    Returns
    Type Description
    System.Object

    A new object that is a copy of this instance.

    Clone(Object, Dictionary<String, String>, WorkbookImpl)

    Creates a new object that is a copy of the current instance.

    Declaration
    public IRange Clone(object parent, Dictionary<string, string> hashNewNames, WorkbookImpl book)
    Parameters
    Type Name Description
    System.Object parent
    System.Collections.Generic.Dictionary<System.String, System.String> hashNewNames
    WorkbookImpl book
    Returns
    Type
    IRange

    CollapseGroup(ExcelGroupBy)

    Collapses current group.

    Declaration
    public void CollapseGroup(ExcelGroupBy groupBy)
    Parameters
    Type Name Description
    ExcelGroupBy groupBy

    This parameter specifies whether the grouping should be performed by rows or by columns.

    ConvertFullRowColumnName(ExcelVersion)

    Converts full row or column tokens between versions.

    Declaration
    public void ConvertFullRowColumnName(ExcelVersion version)
    Parameters
    Type Name Description
    ExcelVersion version

    Version to convert into.

    CopyTo(IRange)

    Copies the range to the specified destination Range (without updating formulas).

    Declaration
    public IRange CopyTo(IRange destination)
    Parameters
    Type Name Description
    IRange destination

    Destination range.

    Returns
    Type Description
    IRange

    Range were this range was copied.

    CopyTo(IRange, ExcelCopyRangeOptions)

    Copies this range into another location.

    Declaration
    public IRange CopyTo(IRange destination, ExcelCopyRangeOptions options)
    Parameters
    Type Name Description
    IRange destination

    Destination range.

    ExcelCopyRangeOptions options

    Copy range options.

    Returns
    Type Description
    IRange

    Destination range.

    CopyTo(IRange, ExcelCopyRangeOptions, Boolean)

    Copies the Range to the specified destination Range with copy options and skip blank option.

    Declaration
    public IRange CopyTo(IRange destination, ExcelCopyRangeOptions options, bool skipBlank)
    Parameters
    Type Name Description
    IRange destination

    Represents the destination Range to copy.

    ExcelCopyRangeOptions options

    Represents the copy Range options.

    System.Boolean skipBlank

    Represents the skip blank cells in the source.

    Returns
    Type Description
    IRange

    Returns the copied Range.

    CopyTo(IRange, Boolean)

    Copies this range into another location using pasteLinkOptions.

    Declaration
    public IRange CopyTo(IRange destination, bool pasteLink)
    Parameters
    Type Name Description
    IRange destination

    Destination range.

    System.Boolean pasteLink

    Check to implement the pasteLink option.

    Returns
    Type Description
    IRange

    Destination range.

    CopyToClipboard()

    Copies range to the clipboard.

    Declaration
    public void CopyToClipboard()

    Delete()

    Removes this Name object from the workbook's Names collection.

    Declaration
    public void Delete()

    ExpandGroup(ExcelGroupBy)

    Expands current group.

    Declaration
    public void ExpandGroup(ExcelGroupBy groupBy)
    Parameters
    Type Name Description
    ExcelGroupBy groupBy

    This parameter specifies whether the grouping should be performed by rows or by columns.

    ExpandGroup(ExcelGroupBy, ExpandCollapseFlags)

    Expands current group.

    Declaration
    public void ExpandGroup(ExcelGroupBy groupBy, ExpandCollapseFlags flags)
    Parameters
    Type Name Description
    ExcelGroupBy groupBy

    This parameter specifies whether the grouping should be performed by rows or by columns.

    ExpandCollapseFlags flags

    Additional option flags.

    FindAll(Boolean)

    This method searches for the all cells with specified bool value.

    Declaration
    public IRange[] FindAll(bool findValue)
    Parameters
    Type Name Description
    System.Boolean findValue

    Value to search.

    Returns
    Type Description
    IRange[]

    All found cells, or Null if value was not found.

    FindAll(DateTime)

    This method searches for the all cells with specified DateTime value.

    Declaration
    public IRange[] FindAll(DateTime findValue)
    Parameters
    Type Name Description
    System.DateTime findValue

    Value to search.

    Returns
    Type Description
    IRange[]

    All found cells, or Null if value was not found.

    FindAll(Double, ExcelFindType)

    This method searches for the all cells with specified double value.

    Declaration
    public IRange[] FindAll(double findValue, ExcelFindType flags)
    Parameters
    Type Name Description
    System.Double findValue

    Value to search.

    ExcelFindType flags

    Flag that represent type of search.

    Returns
    Type Description
    IRange[]

    All found cells, or Null if value was not found.

    FindAll(String, ExcelFindType)

    This method searches for the all cells with specified string value.

    Declaration
    public IRange[] FindAll(string findValue, ExcelFindType flags)
    Parameters
    Type Name Description
    System.String findValue

    Value to search.

    ExcelFindType flags

    Flag that represent type of search.

    Returns
    Type Description
    IRange[]

    All found cells, or Null if value was not found.

    FindAll(TimeSpan)

    This method searches for the all cells with specified TimeSpan value.

    Declaration
    public IRange[] FindAll(TimeSpan findValue)
    Parameters
    Type Name Description
    System.TimeSpan findValue

    Value to search.

    Returns
    Type Description
    IRange[]

    All found cells, or Null if value was not found.

    FindFirst(Boolean)

    This method searches for the first cell with specified bool value.

    Declaration
    public IRange FindFirst(bool findValue)
    Parameters
    Type Name Description
    System.Boolean findValue

    Value to search.

    Returns
    Type Description
    IRange

    First found cell, or Null if value was not found.

    FindFirst(DateTime)

    This method searches for the first cell with specified DateTime value.

    Declaration
    public IRange FindFirst(DateTime findValue)
    Parameters
    Type Name Description
    System.DateTime findValue

    Value to search.

    Returns
    Type Description
    IRange

    First found cell, or Null if value was not found.

    FindFirst(Double, ExcelFindType)

    This method searches for the first cell with specified double value.

    Declaration
    public IRange FindFirst(double findValue, ExcelFindType flags)
    Parameters
    Type Name Description
    System.Double findValue

    Value to search.

    ExcelFindType flags

    Flag that represent type of search.

    Returns
    Type Description
    IRange

    First found cell, or Null if value was not found.

    FindFirst(String, ExcelFindType)

    This method searches for the first cell with specified string value.

    Declaration
    public IRange FindFirst(string findValue, ExcelFindType flags)
    Parameters
    Type Name Description
    System.String findValue

    Value to search.

    ExcelFindType flags

    Flag that represent type of search.

    Returns
    Type
    IRange

    FindFirst(TimeSpan)

    This method searches for the first cell with specified TimeSpan value.

    Declaration
    public IRange FindFirst(TimeSpan findValue)
    Parameters
    Type Name Description
    System.TimeSpan findValue

    Value to search.

    Returns
    Type Description
    IRange

    First found cell, or Null if value was not found.

    FreezePanes()

    Freezes pane at the current range.

    Declaration
    public void FreezePanes()

    GetDependents()

    Gets the dependent cells which refer to other cells.

    Declaration
    public IRange[] GetDependents()
    Returns
    Type Description
    IRange[]

    Returns the dependent cells or null if value was not found.

    GetDependents(Boolean)

    Gets the dependent cells which refer to other cells.

    Declaration
    public IRange[] GetDependents(bool isEntireWorkbook)
    Parameters
    Type Name Description
    System.Boolean isEntireWorkbook

    Indicates whether to check from other worksheets.

    Returns
    Type Description
    IRange[]

    Returns the dependent cells with a specified bool value or null if value was not found.

    GetDirectDependents()

    Gets the direct dependent cells which refer to other cells.

    Declaration
    public IRange[] GetDirectDependents()
    Returns
    Type Description
    IRange[]

    Returns the direct dependent cells or null if value was not found.

    GetDirectDependents(Boolean)

    Gets the direct dependent cells which refer to other cells.

    Declaration
    public IRange[] GetDirectDependents(bool isEntireWorkbook)
    Parameters
    Type Name Description
    System.Boolean isEntireWorkbook

    Indicates whether to check from other worksheets.

    Returns
    Type Description
    IRange[]

    Returns the direct dependent cells with a specified bool value or null if value was not found.

    GetDirectPrecedents()

    Gets the direct precedent cells which are referred by a formula in another cell.

    Declaration
    public IRange[] GetDirectPrecedents()
    Returns
    Type Description
    IRange[]

    Returns the direct precedent cells or null if value was not found.

    GetDirectPrecedents(Boolean)

    Gets the direct precedent cells which are referred by a formula in another cell.

    Declaration
    public IRange[] GetDirectPrecedents(bool isEntireWorkbook)
    Parameters
    Type Name Description
    System.Boolean isEntireWorkbook

    Indicates whether to check from other worksheets.

    Returns
    Type Description
    IRange[]

    Returns the direct precedent cells with a specified bool value or null if value was not found.

    GetEnumerator()

    Returns an enumerator that iterates through the Range.

    Declaration
    public IEnumerator<IRange> GetEnumerator()
    Returns
    Type
    System.Collections.Generic.IEnumerator<IRange>

    GetNativePtg()

    Gets ptg of current range.

    Declaration
    public Ptg[] GetNativePtg()
    Returns
    Type Description
    Ptg[]

    Returns native ptg.

    GetNewAddress(Dictionary<String, String>, out String)

    Get new address

    Declaration
    public string GetNewAddress(Dictionary<string, string> names, out string strSheetName)
    Parameters
    Type Name Description
    System.Collections.Generic.Dictionary<System.String, System.String> names
    System.String strSheetName
    Returns
    Type
    System.String

    GetPrecedents()

    Gets the precedent cells which are referred by a formula in another cell.

    Declaration
    public IRange[] GetPrecedents()
    Returns
    Type Description
    IRange[]

    Returns the precedent cells or null if value was not found.

    GetPrecedents(Boolean)

    Gets the precedent cells which are referred by a formula in another cell.

    Declaration
    public IRange[] GetPrecedents(bool isEntireWorkbook)
    Parameters
    Type Name Description
    System.Boolean isEntireWorkbook

    Indicates whether to check from other worksheets.

    Returns
    Type Description
    IRange[]

    Returns the precedent cells with a specified bool value or null if value was not found.

    GetRectangles()

    Rectangles in the range

    Declaration
    public Rectangle[] GetRectangles()
    Returns
    Type
    Rectangle[]

    GetRectanglesCount()

    Count of rectangles

    Declaration
    public int GetRectanglesCount()
    Returns
    Type
    System.Int32

    GetValue(FormulaUtil)

    A string containing the formula that the name is defined to refer to.

    Declaration
    public string GetValue(FormulaUtil formulaUtil)
    Parameters
    Type Name Description
    FormulaUtil formulaUtil

    Formula util to take setting from.

    Returns
    Type Description
    System.String

    Formula string.

    Group(ExcelGroupBy)

    This method groups current range.

    Declaration
    public IRange Group(ExcelGroupBy groupBy)
    Parameters
    Type Name Description
    ExcelGroupBy groupBy

    This parameter specifies whether the grouping should be performed by rows or by columns.

    Returns
    Type Description
    IRange

    Current range after grouping.

    Group(ExcelGroupBy, Boolean)

    This method groups current range.

    Declaration
    public IRange Group(ExcelGroupBy groupBy, bool bCollapsed)
    Parameters
    Type Name Description
    ExcelGroupBy groupBy

    This parameter specifies whether grouping should be performed by rows or by columns.

    System.Boolean bCollapsed

    Indicates whether group should be collapsed.

    Returns
    Type Description
    IRange

    Current range after grouping.

    IntersectWith(IRange)

    Returns intersection of this range with the specified one.

    Declaration
    public IRange IntersectWith(IRange range)
    Parameters
    Type Name Description
    IRange range

    The Range with which to intersect.

    Returns
    Type Description
    IRange

    Range intersection; if there is no intersection, NULL is returned.

    Max()

    Returns maximum value from numeric cells in the range.

    Declaration
    public double Max()
    Returns
    Type
    System.Double

    Max(Boolean)

    Returns maximum value from numeric cells in the range.

    Declaration
    public double Max(bool considerDateAsNumber)
    Parameters
    Type Name Description
    System.Boolean considerDateAsNumber

    Considers numeric value of date formatted cells for calculation.

    Returns
    Type
    System.Double

    Merge()

    Creates a merged cell from the specified Range object.

    Declaration
    public void Merge()

    Merge(Boolean)

    Creates a merged cell from the specified Range object.

    Declaration
    public void Merge(bool clearCells)
    Parameters
    Type Name Description
    System.Boolean clearCells

    Indicates whether to clear unnecessary cells.

    MergeWith(IRange)

    Returns merge of this range with the specified one.

    Declaration
    public IRange MergeWith(IRange range)
    Parameters
    Type Name Description
    IRange range

    The Range to merge with.

    Returns
    Type Description
    IRange

    Merged ranges or NULL if wasn't able to merge ranges.

    Min()

    Returns minumum value from numeric cells in the range.

    Declaration
    public double Min()
    Returns
    Type
    System.Double

    Min(Boolean)

    Returns minumum value from numeric cells in the range.

    Declaration
    public double Min(bool considerDateAsNumber)
    Parameters
    Type Name Description
    System.Boolean considerDateAsNumber

    Considers numeric value of date formatted cells for calculation.

    Returns
    Type
    System.Double

    MoveTo(IRange)

    Moves the cells to the specified Range (without updating formulas).

    Declaration
    public void MoveTo(IRange destination)
    Parameters
    Type Name Description
    IRange destination

    Destination Range.

    Offset(Int32, Int32)

    Returns a Range object that represents a range thats offset from the specified range.

    Declaration
    public IRange Offset(int row, int column)
    Parameters
    Type Name Description
    System.Int32 row

    The number of rows (positive, negative, or 0 (zero)) by which the range is to be offset

    System.Int32 column

    The number of columns (positive, negative, or 0 (zero)) by which the range is to be offset

    Returns
    Type
    IRange

    Parse(NameRecord)

    Reads information from the NameRecord.

    Declaration
    public void Parse(NameRecord name)
    Parameters
    Type Name Description
    NameRecord name

    NameRecord to parse

    Exceptions
    Type Condition
    System.ArgumentNullException

    When specified NameRecord is NULL.

    remove_NameIndexChanged(NameImpl.NameIndexChangedEventHandler)

    Declaration
    public void remove_NameIndexChanged(NameImpl.NameIndexChangedEventHandler value)
    Parameters
    Type Name Description
    NameImpl.NameIndexChangedEventHandler value

    Replace(String, DataColumn, Boolean)

    Replaces the string with the specified datacolumn.

    Declaration
    public void Replace(string oldValue, DataColumn newValues, bool isFieldNamesShown)
    Parameters
    Type Name Description
    System.String oldValue

    The string to be replaced.

    System.Data.DataColumn newValues

    DataColumn with new data.

    System.Boolean isFieldNamesShown

    Indicates whether field name must be shown.

    Replace(String, DataTable, Boolean)

    Replaces the string with the specified datatable.

    Declaration
    public void Replace(string oldValue, DataTable newValues, bool isFieldNamesShown)
    Parameters
    Type Name Description
    System.String oldValue

    The string to be replaced.

    System.Data.DataTable newValues

    Data table with new data.

    System.Boolean isFieldNamesShown

    Indicates whether field name must be shown.

    Replace(String, DateTime)

    Replaces the string with the specified DateTime value.

    Declaration
    public void Replace(string oldValue, DateTime newValue)
    Parameters
    Type Name Description
    System.String oldValue

    The string to be replaced.

    System.DateTime newValue

    The datetime value to replace all occurrences of oldValue.

    Replace(String, Double)

    Replaces the string with the specified double value.

    Declaration
    public void Replace(string oldValue, double newValue)
    Parameters
    Type Name Description
    System.String oldValue

    The string to be replaced.

    System.Double newValue

    The double value to replace all occurrences of oldValue.

    Replace(String, Double[], Boolean)

    Replaces the string with the specified array of double values.

    Declaration
    public void Replace(string oldValue, double[] newValues, bool isVertical)
    Parameters
    Type Name Description
    System.String oldValue

    The string to be replaced.

    System.Double[] newValues

    Array of new values.

    System.Boolean isVertical

    Indicates whether array should be inserted vertically.

    Replace(String, Int32[], Boolean)

    Replaces the string with the specified array of int values.

    Declaration
    public void Replace(string oldValue, int[] newValues, bool isVertical)
    Parameters
    Type Name Description
    System.String oldValue

    The string to be replaced.

    System.Int32[] newValues

    Array of new values.

    System.Boolean isVertical

    Indicates whether array should be inserted vertically.

    Replace(String, String)

    Replaces the string with the specified string value.

    Declaration
    public void Replace(string oldValue, string newValue)
    Parameters
    Type Name Description
    System.String oldValue

    The string to be replaced.

    System.String newValue

    The string to replace all occurrences of oldValue.

    Replace(String, String, ExcelFindOptions)

    Replaces the string with the specified string value based on the given ExcelFindOptions.

    Declaration
    public void Replace(string oldValue, string newValue, ExcelFindOptions findOptions)
    Parameters
    Type Name Description
    System.String oldValue

    The string to be replaced.

    System.String newValue

    The string to replace all occurrences of oldValue.

    ExcelFindOptions findOptions

    Specifies the find options for the oldValue.

    Replace(String, String[], Boolean)

    Replaces the string with the specified array of string values.

    Declaration
    public void Replace(string oldValue, string[] newValues, bool isVertical)
    Parameters
    Type Name Description
    System.String oldValue

    The string to be replaced.

    System.String[] newValues

    Array of new values.

    System.Boolean isVertical

    Indicates whether array should be inserted vertically.

    Resize(Int32, Int32)

    Resizes the specified range

    Declaration
    public IRange Resize(int row, int column)
    Parameters
    Type Name Description
    System.Int32 row

    The number of rows in new range

    System.Int32 column

    The number of columns in new range

    Returns
    Type
    IRange

    Serialize(OffsetArrayList)

    Saves named range into list of biff records.

    Declaration
    public void Serialize(OffsetArrayList records)
    Parameters
    Type Name Description
    OffsetArrayList records

    List of biff records to save into.

    SetIndex(Int32)

    Sets index of the named range and raise event.

    Declaration
    public void SetIndex(int index)
    Parameters
    Type Name Description
    System.Int32 index

    New index.

    SetIndex(Int32, Boolean)

    Sets index of the named range.

    Declaration
    public void SetIndex(int index, bool bRaiseEvent)
    Parameters
    Type Name Description
    System.Int32 index

    New index.

    System.Boolean bRaiseEvent

    Indicates whether events should be raised.

    SetSheetIndex(Int32)

    This method should be called after worksheet index change.

    Declaration
    public void SetSheetIndex(int iSheetIndex)
    Parameters
    Type Name Description
    System.Int32 iSheetIndex

    New sheet index.

    SetValue(Ptg[])

    Sets name value.

    Declaration
    public void SetValue(Ptg[] parsedExpression)
    Parameters
    Type Name Description
    Ptg[] parsedExpression

    Parsed expression value to set.

    SubTotal(Int32, ConsolidationFunction, Int32[])

    Creates Subtotal for the corresponding ranges

    Declaration
    public void SubTotal(int groupBy, ConsolidationFunction function, int[] totalList)
    Parameters
    Type Name Description
    System.Int32 groupBy

    GroupBy

    ConsolidationFunction function

    ConsolidationFunction

    System.Int32[] totalList

    TotalList

    SubTotal(Int32, ConsolidationFunction, Int32[], Boolean, Boolean, Boolean)

    Creates SubTotal for the corresponding Ranges

    Declaration
    public void SubTotal(int groupBy, ConsolidationFunction function, int[] totalList, bool replace, bool pageBreaks, bool summaryBelowData)
    Parameters
    Type Name Description
    System.Int32 groupBy

    GroupByGroupBy

    ConsolidationFunction function

    ConsolidationFunction

    System.Int32[] totalList

    TotalList

    System.Boolean replace

    Replace exisiting SubTotal

    System.Boolean pageBreaks

    Insert PageBreaks

    System.Boolean summaryBelowData

    SummaryBelowData

    SubTotal(Int32[], ConsolidationFunction, Int32[], Boolean, Boolean, Boolean)

    Creates SubTotal for the corresponding Ranges

    Declaration
    public void SubTotal(int[] groupBy, ConsolidationFunction function, int[] totalList, bool replace, bool pageBreaks, bool summaryBelowData)
    Parameters
    Type Name Description
    System.Int32[] groupBy

    Columns to GroupBy

    ConsolidationFunction function

    ConsolidationFunction

    System.Int32[] totalList

    TotalList

    System.Boolean replace

    Replace exisiting SubTotal

    System.Boolean pageBreaks

    Insert PageBreaks

    System.Boolean summaryBelowData

    SummaryBelowData

    Sum()

    Returns sum of numeric cells in the range.

    Declaration
    public double Sum()
    Returns
    Type
    System.Double

    Sum(Boolean)

    Returns sum of numeric cells in the range.

    Declaration
    public double Sum(bool considerDateAsNumber)
    Parameters
    Type Name Description
    System.Boolean considerDateAsNumber

    Considers numeric value of date formatted cells for calculation.

    Returns
    Type
    System.Double

    Trim()

    Trim the empty rows at top and bottom of the range, the empty columns at left and right of the range.

    Declaration
    public IRange Trim()
    Returns
    Type Description
    IRange

    Returns the range after trim.

    Ungroup(ExcelGroupBy)

    Ungroups current range.

    Declaration
    public IRange Ungroup(ExcelGroupBy groupBy)
    Parameters
    Type Name Description
    ExcelGroupBy groupBy

    Indicates type of ungrouping. Ungroup by columns or by rows.

    Returns
    Type Description
    IRange

    Current range after ungrouping.

    UnMerge()

    Separates a merged area into individual cells.

    Declaration
    public void UnMerge()

    Events

    NameIndexChanged

    Utility event. Raised on Name object index property change.

    Declaration
    public event NameImpl.NameIndexChangedEventHandler NameIndexChanged
    Event Type
    Type
    NameImpl.NameIndexChangedEventHandler

    Explicit Interface Implementations

    IName.Index

    Index of the Name object in the workbook's or Worksheet's Names collection.

    Declaration
    int IName.Index { get; }
    Returns
    Type
    System.Int32

    IName.Worksheet

    Returns parent worksheet. Read-only.

    Declaration
    IWorksheet IName.Worksheet { get; }
    Returns
    Type
    IWorksheet

    IParseable.Parse()

    Parses named range.

    Declaration
    void IParseable.Parse()

    IRange.Value

    Returns or sets the value of the specified range. Read/write Variant.

    Declaration
    string IRange.Value { get; set; }
    Returns
    Type
    System.String

    IRange.Worksheet

    Returns a Worksheet object that represents the worksheet containing the specified range. Read-only.

    Declaration
    IWorksheet IRange.Worksheet { get; }
    Returns
    Type
    IWorksheet

    Implements

    IName
    INameIndexChangedEventProvider
    IParseable
    INativePTG
    ICloneParent
    ICombinedRange
    IRange
    IParentApplication
    System.Collections.Generic.IEnumerable<>
    System.Collections.IEnumerable
    System.IDisposable
    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved