public CellReference() 
{

}

Constructor

 public CellReference(Cell rt) 
{
             
    relativeTo = rt;
}

Constructor

Parameters:

rt - the cell containing the formula

 public CellReference(String s) 
{
    column = CellReferenceHelper.getColumn(s);
    row = CellReferenceHelper.getRow(s);
    columnRelative = CellReferenceHelper.isColumnRelative(s);
    rowRelative = CellReferenceHelper.isRowRelative(s);
}

Constructor invoked when parsing a text string

Parameters:

s - the string being parsed

 public  void adjustRelativeCellReferences(int colAdjust,
    int rowAdjust) 
{
    if (columnRelative)
    {
      column += colAdjust;
    }
    if (rowRelative)
    {
      row += rowAdjust;
    }
}

Adjusts all the relative cell references in this formula by the amount specified. Used when copying formulas

 public  void columnInserted(int sheetIndex,
    int col,
    boolean currentSheet) 
{
    if (!currentSheet)
    {
      return;
    }
    if (column  >= col)
    {
      column++;
    }
}

Called when a column is inserted on the specified sheet. Tells the formula parser to update all of its cell references beyond this column

  void columnRemoved(int sheetIndex,
    int col,
    boolean currentSheet) 
{
    if (!currentSheet)
    {
      return;
    }
    if (column  >= col)
    {
      column--;
    }
}

Called when a column is inserted on the specified sheet. Tells the formula parser to update all of its cell references beyond this column

 byte[] getBytes() 
{
    byte[] data = new byte[5];
    data[0] = !useAlternateCode() ? Token.REF.getCode() :
                                    Token.REF.getCode2();
    IntegerHelper.getTwoBytes(row, data, 1);
    int grcol = column;
    // Set the row/column relative bits if applicable
    if (rowRelative)
    {
      grcol |= 0x8000;
    }
    if (columnRelative)
    {
      grcol |= 0x4000;
    }
    IntegerHelper.getTwoBytes(grcol, data, 3);
    return data;
}

Gets the token representation of this item in RPN

 public int getColumn() 
{
    return column;
}

Accessor for the column

 public int getRow() 
{
    return row;
}

Accessor for the row

 public  void getString(StringBuffer buf) 
{
    CellReferenceHelper.getCellReference(column, !columnRelative,
                                         row, !rowRelative,
                                         buf);
}

Gets the cell reference as a string for this item

  void handleImportedCellReferences() 
{

}

If this formula was on an imported sheet, check that cell references to another sheet are warned appropriately Flags the formula as invalid Does nothing here

 public int read(byte[] data,
    int pos) 
{
    row = IntegerHelper.getInt(data[pos], data[pos + 1]);
    int columnMask = IntegerHelper.getInt(data[pos + 2], data[pos + 3]);
    column = columnMask & 0x00ff;
    columnRelative = ((columnMask & 0x4000) != 0);
    rowRelative = ((columnMask & 0x8000) != 0);
    return 4;
}

Reads the ptg data from the array starting at the specified position

  void rowInserted(int sheetIndex,
    int r,
    boolean currentSheet) 
{
    if (!currentSheet)
    {
      return;
    }
    if (row  >= r)
    {
      row++;
    }
}

Called when a column is inserted on the specified sheet. Tells the formula parser to update all of its cell references beyond this column

  void rowRemoved(int sheetIndex,
    int r,
    boolean currentSheet) 
{
    if (!currentSheet)
    {
      return;
    }
    if (row  >= r)
    {
      row--;
    }
}

Called when a column is inserted on the specified sheet. Tells the formula parser to update all of its cell references beyond this column