Xamarin.Android

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Class RangeInfo

    Show / Hide Table of Contents

    Class RangeInfo

    RangeInfo represents a rectangle array of cells that may contain formulas, strings, or numbers that may be referenced by other formulas.

    Inheritance
    System.Object
    RangeInfo
    Namespace: Syncfusion.XlsIO.Calculate
    Assembly: Syncfusion.XlsIO.Portable.dll
    Syntax
    public class RangeInfo : Object

    Constructors

    RangeInfo(Int32, Int32, Int32, Int32)

    Constructs a RangeInfo instance with the given top, left, bottom and right values.

    Declaration
    public RangeInfo(int top, int left, int bottom, int right)
    Parameters
    Type Name Description
    System.Int32 top

    Top row index of this range.

    System.Int32 left

    Left column index of this range.

    System.Int32 bottom

    Bottom row index of this range.

    System.Int32 right

    Right column index of this range.

    Remarks

    The range values must be one-based indexes.

    Properties

    Bottom

    A property that gets/sets the bottom row index of this range.

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

    Left

    A property that gets/sets the left column index of this range.

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

    Right

    A property that gets/sets the right row index of this range.

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

    Top

    A property that gets/sets the top row index of this range.

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

    Methods

    Cells(Int32, Int32, Int32, Int32)

    A method to retrieve a range based on the numeric arguments passed in.

    Declaration
    public static RangeInfo Cells(int top, int left, int bottom, int right)
    Parameters
    Type Name Description
    System.Int32 top

    Top row index of this range.

    System.Int32 left

    Left column index of this range.

    System.Int32 bottom

    Bottom row index of this range.

    System.Int32 right

    Right column index of this range.

    Returns
    Type Description
    RangeInfo

    A RangeInfo object.

    Remarks

    The range values must be one-based indexes.

    GetAlphaLabel(Int32)

    GetAlphaLabel is a method that retrieves a string value for the column whose numerical index is passed in.

    Declaration
    public static string GetAlphaLabel(int col)
    Parameters
    Type Name Description
    System.Int32 col

    Number index such as 1, 5, 27.

    Returns
    Type Description
    System.String

    Corresponding alphabets label like A, E, AA.

    Back to top Generated by DocFX
    Copyright © 2001 - 2023 Syncfusion Inc. All Rights Reserved