Table of Contents

TXls3DRange Record

A 3d Excel range.

Syntax

Unit: FlexCel.Core

TXls3DRange = record;

Fields

Name Description
Bottom Bottom of the range.
FileName Filename if the range is in a different file.
HasValue False if the record doesn't have a defined value. When this field is false, the values of the other fields don't matter.
Left Left of the range.
Right Right of the range.
Sheet2 Second sheet of the range.
Top Top of the range.

Methods

Name Description
Create Overloaded
Create
Create(TCoreExcelFile, string)
Create(Integer, Integer, Integer, Integer, Integer, Integer)
Create(string, Integer, Integer, Integer, Integer, Integer, Integer)
Equals Returns true if both objects are equal.
GetHashCode Returns the hashcode of the object.
IsNull Returns true if the record doesn't have a defined value. This is the inverse of HasValue
Null Creates a null range.
SetRange3DRef Sets the value of the 3d range based on the string that defines the range in A1 notation.
TrySetRange3DRef Tries to set the value of the 3d range based on the string that defines the range in A1 notation. If the name can't be set, no data is modified and this method returns false.

Operators

Name Description
Equality Adapts the = operator so it returns true when both instances have the same values.
Inequality Adapts the <> operator so it returns true when both instances have different values.

Properties

Name Description
IsOneCell Returns true if the range has only one cell.