GridReferredArea

Inheritance: java.lang.Object

public class GridReferredArea

Represents a referred objcet by the formula.

Methods

MethodDescription
equals(Object arg0)
getClass()
getEndColumn()The end column of the area.
getEndRow()The end row of the area.
getExternalFileName()this.KeepedRels = source.KeepedRels;
getSheetName()Indicates which sheet this is in
getStartColumn()The start column of the area.
getStartRow()The start row of the area.
getValue(int rowOffset, int colOffset)Gets cell value with given offset from the top-left of this area.
getValues()Gets cell values in this area.
hashCode()
isArea()Indicates whether this is an area.
isExternalLink()Indicates whether this is an external link.
notify()
notifyAll()
toString()
wait()
wait(long arg0)
wait(long arg0, int arg1)

equals(Object arg0)

public boolean equals(Object arg0)

Parameters:

ParameterTypeDescription
arg0java.lang.Object

Returns: boolean

getClass()

public final native Class<?> getClass()

Returns: java.lang.Class

getEndColumn()

public int getEndColumn()

The end column of the area.

Returns: int

getEndRow()

public int getEndRow()

The end row of the area.

Returns: int

getExternalFileName()

public String getExternalFileName()

this.KeepedRels = source.KeepedRels;

Returns: java.lang.String

getSheetName()

public String getSheetName()

Indicates which sheet this is in

Returns: java.lang.String

getStartColumn()

public int getStartColumn()

The start column of the area.

Returns: int

getStartRow()

public int getStartRow()

The start row of the area.

Returns: int

getValue(int rowOffset, int colOffset)

public Object getValue(int rowOffset, int colOffset)

Gets cell value with given offset from the top-left of this area.

Parameters:

ParameterTypeDescription
rowOffsetintrow offset from the start row of this area
colOffsetintcolumn offset from the start row of this area

Returns: java.lang.Object - “#REF!” if this area is invalid; “#N/A” if given offset out of this area; Otherwise return the cell value at given position.

getValues()

public Object getValues()

Gets cell values in this area.

Returns: java.lang.Object - If this area is invalid, “#REF!” will be returned; If this area is one single cell, then return the cell value object; Otherwise return one array for all values in this area.

hashCode()

public native int hashCode()

Returns: int

isArea()

public boolean isArea()

Indicates whether this is an area.

Remarks

If this is not an area, only StartRow and StartColumn effect.

Returns: boolean

public boolean isExternalLink()

Indicates whether this is an external link.

Returns: boolean

notify()

public final native void notify()

notifyAll()

public final native void notifyAll()

toString()

public String toString()

Returns: java.lang.String

wait()

public final void wait()

wait(long arg0)

public final native void wait(long arg0)

Parameters:

ParameterTypeDescription
arg0long

wait(long arg0, int arg1)

public final void wait(long arg0, int arg1)

Parameters:

ParameterTypeDescription
arg0long
arg1int