XLL+ Class Library (7.0)

CXlRef Methods

The methods of the CXlRef class are listed here.

Construction

public method CXlRef Constructs a CXlRef object

Assignment operators

public method operator = Assigns a new value to the XLREF, using a variety of input types

Operations

public method Init Initialise the CXlRef contents
public method MoveBy Moves a reference by the specified number of rows and columns
public method Normalize Normalize the coordinates of the reference
public method Resize Resizes a reference to the specified number of rows and columns
public method SetRef Sets the values in the CXlRef

Attributes

public method Bottom Returns a reference to the bottom row number of the reference
public method Height Returns the number of rows in the reference
public method IsSingle Is this a reference to a single cell ?
public method Left Returns a reference to the leftmost column number of the reference
public method Right Returns a reference to the rightmost column number of the reference
public method Top Returns a reference to the top row number of the reference
public method Width Returns the number of columns in the reference

String Conversion

public method BottomRightToString Converts the bottom right corner of the reference to a string address
public method BottomRightToStringA Converts the bottom right corner of the reference to a string address
public method BottomRightToStringW Converts the bottom right corner of the reference to a string address
public method ColToA Converts a column number to its A1 style column letter(s)
public method ColToAA Converts a column number to its A1 style column letter(s)
public method ColToAW Converts a column number to its A1 style column letter(s)
public method FromString Reads a string address into the reference
public method static method GetRowColumnLetters Returns the letters used for RC style addresses
public method TopLeftToString Converts the top left corner of the reference to a string address
public method TopLeftToStringA Converts the top left corner of the reference to a string address
public method TopLeftToStringW Converts the top left corner of the reference to a string address
public method ToString Returns the string address of the reference
public method ToStringA Returns the string address of the reference
public method ToStringW Returns the string address of the reference

Limits

public method static method MaxCol Returns the maximum legal column number (counting from 0)
public method static method MaxRow Returns the maximum legal column number (counting from 0)

Comparisons

public method Compare Compare the contents of this CXlRef with another
public method operator != Compare the contents of this CXlRef with another
public method operator < Compare the contents of this CXlRef with another
public method operator <= Compare the contents of this CXlRef with another
public method operator == Compare the contents of this CXlRef with another
public method operator > Compare the contents of this CXlRef with another
public method operator >= Compare the contents of this CXlRef with another

Requirements

Header: xllplus.h

See Also

CXlRef Class | xllplus.h | CXlOper object

© 1997-2017 Planatech Solutions Ltd. All rights reserved.