Class Reference
java.lang.Object
com.grapecity.documents.excel.expressions.Reference
- All Implemented Interfaces:
Cloneable
Represents a reference in formula.
-
Field Summary
Fields -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionclone()Copy the reference.booleanEquality comparison.booleanEquality comparison for late binding.intGets or sets the 0-based column index.booleanIndicates whether the reference has column.booleanGets or sets whether the reference has row.booleanGets or sets whether the column is relative.booleanGets or sets whether the reference contains error.booleanGets or sets whether the last column is relative.booleanGets or sets whether the last row is absolute.booleanGets or sets whether the reference is range.booleanGets or sets whether the row is relative.intGets or sets the end column index.intGets or sets the 0-based end row index.The name of the end worksheet of the 3D reference.intgetRow()Gets or sets the 0-based row index.Gets or sets the external workbook reference.The name of the worksheet.inthashCode()This object doesn't support getting hash code, because all fields are mutable.voidsetColumn(int value) Gets or sets the 0-based column index.voidsetHasColumn(boolean value) Indicates whether the reference has column.voidsetHasRow(boolean value) Gets or sets whether the reference has row.voidsetIsColumnRelative(boolean value) Gets or sets whether the column is relative.voidsetIsError(boolean value) Gets or sets whether the reference contains error.voidsetIsLastColumnRelative(boolean value) Gets or sets whether the last column is relative.voidsetIsLastRowRelative(boolean value) Gets or sets whether the last row is absolute.voidsetIsRange(boolean value) Gets or sets whether the reference is range.voidsetIsRowRelative(boolean value) Gets or sets whether the row is relative.voidsetLastColumn(int value) Gets or sets the end column index.voidsetLastRow(int value) Gets or sets the 0-based end row index.voidsetLastWorksheetName(String value) The name of the end worksheet of the 3D reference.voidsetRow(int value) Gets or sets the 0-based row index.voidsetWorkbook(WorkbookReference value) Gets or sets the external workbook reference.voidsetWorksheetName(String value) The name of the worksheet.toString()Converts the reference to A1 string.toString(UnParseContext context) Converts the reference to string.
-
Field Details
-
ErrorWorksheetName
- See Also:
-
-
Constructor Details
-
Reference
public Reference()
-
-
Method Details
-
getWorkbook
Gets or sets the external workbook reference. The default value isnull. -
setWorkbook
Gets or sets the external workbook reference. The default value isnull. -
getWorksheetName
The name of the worksheet. -
setWorksheetName
The name of the worksheet. -
getLastWorksheetName
The name of the end worksheet of the 3D reference. -
setLastWorksheetName
The name of the end worksheet of the 3D reference. -
getHasRow
public boolean getHasRow()Gets or sets whether the reference has row. The default value istrue. -
setHasRow
public void setHasRow(boolean value) Gets or sets whether the reference has row. The default value istrue. -
getHasColumn
public boolean getHasColumn()Indicates whether the reference has column. The default value istrue. -
setHasColumn
public void setHasColumn(boolean value) Indicates whether the reference has column. The default value istrue. -
getRow
public int getRow()Gets or sets the 0-based row index. The default value is 0. -
setRow
public void setRow(int value) Gets or sets the 0-based row index. The default value is 0. -
getColumn
public int getColumn()Gets or sets the 0-based column index. The default value is 0. -
setColumn
public void setColumn(int value) Gets or sets the 0-based column index. The default value is 0. -
getLastRow
public int getLastRow()Gets or sets the 0-based end row index. The default value is 0. -
setLastRow
public void setLastRow(int value) Gets or sets the 0-based end row index. The default value is 0. -
getLastColumn
public int getLastColumn()Gets or sets the end column index. The default value is 0. -
setLastColumn
public void setLastColumn(int value) Gets or sets the end column index. The default value is 0. -
getIsRowRelative
public boolean getIsRowRelative()Gets or sets whether the row is relative. The default value istrue. -
setIsRowRelative
public void setIsRowRelative(boolean value) Gets or sets whether the row is relative. The default value istrue. -
getIsColumnRelative
public boolean getIsColumnRelative()Gets or sets whether the column is relative. The default value istrue. -
setIsColumnRelative
public void setIsColumnRelative(boolean value) Gets or sets whether the column is relative. The default value istrue. -
getIsLastRowRelative
public boolean getIsLastRowRelative()Gets or sets whether the last row is absolute. The default value istrue. -
setIsLastRowRelative
public void setIsLastRowRelative(boolean value) Gets or sets whether the last row is absolute. The default value istrue. -
getIsLastColumnRelative
public boolean getIsLastColumnRelative()Gets or sets whether the last column is relative. The default value istrue. -
setIsLastColumnRelative
public void setIsLastColumnRelative(boolean value) Gets or sets whether the last column is relative. The default value istrue. -
getIsRange
public boolean getIsRange()Gets or sets whether the reference is range. The default value isfalse. -
setIsRange
public void setIsRange(boolean value) Gets or sets whether the reference is range. The default value isfalse. -
getIsError
public boolean getIsError()Gets or sets whether the reference contains error. The default value isfalse. -
setIsError
public void setIsError(boolean value) Gets or sets whether the reference contains error. The default value isfalse. -
toString
Converts the reference to A1 string. -
toString
Converts the reference to string.- Parameters:
context- The parse options.
-
equals
Equality comparison for late binding. -
equals
Equality comparison.- Parameters:
other- Another reference.
-
hashCode
public int hashCode()This object doesn't support getting hash code, because all fields are mutable. -
clone
Copy the reference.
-