menu

WPF

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

    Show / Hide Table of Contents

    Interface ICombinedRange

    Represents a combined Range.

    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 ICombinedRange : IRange, IParentApplication, IEnumerable<IRange>, IEnumerable

    Properties

    AddressGlobal2007

    Gets address global in the format required by Excel 2007.

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

    CellsCount

    Number of cells in the range. Read-only.

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

    WorksheetName

    Gets name of the parent worksheet.

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

    Methods

    ClearConditionalFormats()

    Clears conditional formats.

    Declaration
    void ClearConditionalFormats()

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

    Clones current IRange.

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

    Parent object.

    System.Collections.Generic.Dictionary<System.String, System.String> hashNewNames

    Dictionary with new names.

    WorkbookImpl book

    Parent workbook.

    Returns
    Type Description
    IRange

    Returns clone of current instance.

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

    Gets new address of range.

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

    Dictionary with Worksheet names.

    System.String strSheetName

    String that sets as a worksheet name.

    Returns
    Type Description
    System.String

    Returns string with new name.

    GetRectangles()

    Returns array that contains information about range.

    Declaration
    Rectangle[] GetRectangles()
    Returns
    Type Description
    System.Drawing.Rectangle[]

    Rectangles that describes range

    GetRectanglesCount()

    Returns number of rectangles returned by GetRectangles method.

    Declaration
    int GetRectanglesCount()
    Returns
    Type Description
    System.Int32

    Number of rectangles returned by GetRectangles method.

    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