com.aspose.gridweb
Class GridReferredArea

java.lang.Object
    extended by com.aspose.gridweb.GridReferredArea

public class GridReferredArea 
extends java.lang.Object

Represents a referred objcet by the formula.


Property Getters/Setters Summary
intgetEndColumn()
           The end column of the area.
intgetEndRow()
           The end row of the area.
java.lang.StringgetExternalFileName()
           this.KeepedRels = source.KeepedRels;
booleanisArea()
           Indicates whether this is an area.
booleanisExternalLink()
           Indicates whether this is an external link.
java.lang.StringgetSheetName()
           Indicates which sheet this is in
intgetStartColumn()
           The start column of the area.
intgetStartRow()
           The start row of the area.
 
Method Summary
java.lang.ObjectgetValue(int rowOffset, int colOffset)
           Gets cell value with given offset from the top-left of this area.
java.lang.ObjectgetValues()
           Gets cell values in this area.
 

Property Getters/Setters Detail

isExternalLink

public boolean isExternalLink()
Indicates whether this is an external link.

getExternalFileName

public java.lang.String getExternalFileName()
this.KeepedRels = source.KeepedRels;

getSheetName

public java.lang.String getSheetName()
Indicates which sheet this is in

isArea

public boolean isArea()
Indicates whether this is an area. If this is not an area, only StartRow and StartColumn effect.

getEndColumn

public int getEndColumn()
The end column of the area.

getStartColumn

public int getStartColumn()
The start column of the area.

getEndRow

public int getEndRow()
The end row of the area.

getStartRow

public int getStartRow()
The start row of the area.

Method Detail

getValues

public java.lang.Object getValues()
Gets cell values in this area.
Returns:
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.

getValue

public java.lang.Object getValue(int rowOffset, int colOffset)
Gets cell value with given offset from the top-left of this area.
Parameters:
rowOffset - row offset from the start row of this area
colOffset - column offset from the start row of this area
Returns:
"#REF!" if this area is invalid; "#N/A" if given offset out of this area; Otherwise return the cell value at given position.

See Also:
          Aspose.Cells Documentation - the home page for the Aspose.Cells Product Documentation.
          Aspose.Cells Support Forum - our preferred method of support.