menu

WPF

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Interface IMigrantRange - WPF API Reference | Syncfusion

    Show / Hide Table of Contents

    Interface IMigrantRange

    Represents range object for the single cell. Coordinates of such object can be changed. There should be only one such object for single worksheet.

    Inherited Members
    IParentApplication.Application
    IParentApplication.Parent
    IRange.Activate()
    IRange.Activate(Boolean)
    IRange.AddComment()
    IRange.Address
    IRange.AddressGlobal
    IRange.AddressLocal
    IRange.AddressR1C1
    IRange.AddressR1C1Local
    IRange.AddThreadedComment(String, DateTime)
    IRange.AddThreadedComment(String, String, DateTime)
    IRange.AutofitColumns()
    IRange.AutofitRows()
    IRange.Average()
    IRange.Average(Boolean)
    IRange.Boolean
    IRange.BorderAround()
    IRange.BorderAround(ExcelLineStyle)
    IRange.BorderAround(ExcelLineStyle, Color)
    IRange.BorderAround(ExcelLineStyle, ExcelKnownColors)
    IRange.BorderInside()
    IRange.BorderInside(ExcelLineStyle)
    IRange.BorderInside(ExcelLineStyle, Color)
    IRange.BorderInside(ExcelLineStyle, ExcelKnownColors)
    IRange.BorderNone()
    IRange.Borders
    IRange.BuiltInStyle
    IRange.CalculatedValue
    IRange.Cells
    IRange.CellStyle
    IRange.CellStyleName
    IRange.Clear()
    IRange.Clear(Boolean)
    IRange.Clear(ExcelClearOptions)
    IRange.Clear(ExcelMoveDirection)
    IRange.Clear(ExcelMoveDirection, ExcelCopyRangeOptions)
    IRange.CollapseGroup(ExcelGroupBy)
    IRange.Column
    IRange.ColumnGroupLevel
    IRange.Columns
    IRange.ColumnWidth
    IRange.Comment
    IRange.ConditionalFormats
    IRange.CopyTo(IRange)
    IRange.CopyTo(IRange, Boolean)
    IRange.CopyTo(IRange, ExcelCopyRangeOptions)
    IRange.CopyTo(IRange, ExcelCopyRangeOptions, Boolean)
    IRange.Count
    IRange.DataValidation
    IRange.DateTime
    IRange.DisplayText
    IRange.End
    IRange.EntireColumn
    IRange.EntireRow
    IRange.Error
    IRange.ExpandGroup(ExcelGroupBy)
    IRange.ExpandGroup(ExcelGroupBy, ExpandCollapseFlags)
    IRange.FindAll(Boolean)
    IRange.FindAll(DateTime)
    IRange.FindAll(Double, ExcelFindType)
    IRange.FindAll(String, ExcelFindType)
    IRange.FindAll(TimeSpan)
    IRange.FindFirst(Boolean)
    IRange.FindFirst(DateTime)
    IRange.FindFirst(Double, ExcelFindType)
    IRange.FindFirst(String, ExcelFindType)
    IRange.FindFirst(TimeSpan)
    IRange.Formula
    IRange.FormulaArray
    IRange.FormulaArrayR1C1
    IRange.FormulaBoolValue
    IRange.FormulaDateTime
    IRange.FormulaErrorValue
    IRange.FormulaHidden
    IRange.FormulaNumberValue
    IRange.FormulaR1C1
    IRange.FormulaStringValue
    IRange.FreezePanes()
    IRange.GetDependents()
    IRange.GetDependents(Boolean)
    IRange.GetDirectDependents()
    IRange.GetDirectDependents(Boolean)
    IRange.GetDirectPrecedents()
    IRange.GetDirectPrecedents(Boolean)
    IRange.GetPrecedents()
    IRange.GetPrecedents(Boolean)
    IRange.Group(ExcelGroupBy)
    IRange.Group(ExcelGroupBy, Boolean)
    IRange.HasBoolean
    IRange.HasDataValidation
    IRange.HasDateTime
    IRange.HasExternalFormula
    IRange.HasFormula
    IRange.HasFormulaArray
    IRange.HasFormulaBoolValue
    IRange.HasFormulaDateTime
    IRange.HasFormulaErrorValue
    IRange.HasFormulaNumberValue
    IRange.HasFormulaStringValue
    IRange.HasNumber
    IRange.HasRichText
    IRange.HasString
    IRange.HasStyle
    IRange.HorizontalAlignment
    IRange.HtmlString
    IRange.Hyperlinks
    IRange.IgnoreErrorOptions
    IRange.IndentLevel
    IRange.IntersectWith(IRange)
    IRange.IsBlank
    IRange.IsBoolean
    IRange.IsError
    IRange.IsGroupedByColumn
    IRange.IsGroupedByRow
    IRange.IsInitialized
    IRange.IsMerged
    IRange.IsStringsPreserved
    IRange.Item[Int32, Int32, Int32, Int32]
    IRange.Item[Int32, Int32]
    IRange.Item[String, Boolean]
    IRange.Item[String]
    IRange.LastColumn
    IRange.LastRow
    IRange.Max()
    IRange.Max(Boolean)
    IRange.Merge()
    IRange.Merge(Boolean)
    IRange.MergeArea
    IRange.MergeWith(IRange)
    IRange.Min()
    IRange.Min(Boolean)
    IRange.MoveTo(IRange)
    IRange.Number
    IRange.NumberFormat
    IRange.Offset(Int32, Int32)
    IRange.Replace(String, DataColumn, Boolean)
    IRange.Replace(String, DataTable, Boolean)
    IRange.Replace(String, DateTime)
    IRange.Replace(String, Double)
    IRange.Replace(String, Double[], Boolean)
    IRange.Replace(String, Int32[], Boolean)
    IRange.Replace(String, String)
    IRange.Replace(String, String, ExcelFindOptions)
    IRange.Replace(String, String[], Boolean)
    IRange.Resize(Int32, Int32)
    IRange.RichText
    IRange.Row
    IRange.RowGroupLevel
    IRange.RowHeight
    IRange.Rows
    IRange.SubTotal(Int32, ConsolidationFunction, Int32[])
    IRange.SubTotal(Int32, ConsolidationFunction, Int32[], Boolean, Boolean, Boolean)
    IRange.SubTotal(Int32[], ConsolidationFunction, Int32[], Boolean, Boolean, Boolean)
    IRange.Sum()
    IRange.Sum(Boolean)
    IRange.Text
    IRange.ThreadedComment
    IRange.TimeSpan
    IRange.Trim()
    IRange.Ungroup(ExcelGroupBy)
    IRange.UnMerge()
    IRange.Value
    IRange.Value2
    IRange.VerticalAlignment
    IRange.Worksheet
    IRange.WrapText
    System.Collections.Generic.IEnumerable<Syncfusion.XlsIO.IRange>.GetEnumerator()
    Namespace: Syncfusion.XlsIO
    Assembly: Syncfusion.XlsIO.Base.dll
    Syntax
    public interface IMigrantRange : IRange, IParentApplication, IEnumerable<IRange>, IEnumerable

    Methods

    ResetRowColumn(Int32, Int32)

    Resets row and column values.

    Declaration
    void ResetRowColumn(int iRow, int iColumn)
    Parameters
    Type Name Description
    System.Int32 iRow

    One-based row index of the new cell address.

    System.Int32 iColumn

    One-based column index of the new cell address.

    SetValue(Boolean)

    Assigns bool value to the Merged region.

    Declaration
    void SetValue(bool value)
    Parameters
    Type Name Description
    System.Boolean value

    Value to be assigned

    SetValue(DateTime)

    Assigns DateTime value to the Merged region.

    Declaration
    void SetValue(DateTime value)
    Parameters
    Type Name Description
    System.DateTime value

    Value to be assigned

    SetValue(Double)

    Assigns double value to the Merged region.

    Declaration
    void SetValue(double value)
    Parameters
    Type Name Description
    System.Double value

    Value to be assigned

    SetValue(Int32)

    Assigns integer value to the Merged region.

    Declaration
    void SetValue(int value)
    Parameters
    Type Name Description
    System.Int32 value

    Value to be assigned

    SetValue(String)

    Assigns string value to the Merged region.

    Declaration
    void SetValue(string value)
    Parameters
    Type Name Description
    System.String value

    Value to be assigned

    Extension Methods

    PivotExtension.GroupByMany<TElement>(IEnumerable<TElement>, Int32, Func<TElement, Object>[])
    PivotExtension.GroupByMany<TElement>(IEnumerable<TElement>, IEnumerable<Func<TElement, Object>>)
    FunctionalExtensions.ForEach<T>(IEnumerable, Action<T>)
    FunctionalExtensions.ForEach<T>(IEnumerable<T>, Action<T>)
    FunctionalExtensions.ToList<T>(IEnumerable)
    ChartExtensionUtils.DistinctBy<TSource, TKey>(IEnumerable<TSource>, Func<TSource, TKey>)
    GridExcelHelper.ConvertExcelRangeToGridRange(IRange)
    GridExcelHelper.ConvertExcelRangeToGridRange(IRange, SpreadsheetGrid)
    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved