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

Constructor

Parameters:

the - cell the formula is relative to

 byte[] getBytes() 
{
    byte[] data = new byte[9];
    data[0] = Token.AREA.getCode();
    // Use absolute references for columns, so don't bother about
    // the col relative/row relative bits
    IntegerHelper.getTwoBytes(rowFirst, data, 1);
    IntegerHelper.getTwoBytes(rowLast, data, 3);
    IntegerHelper.getTwoBytes(columnFirst, data, 5);
    IntegerHelper.getTwoBytes(columnLast, data, 7);
    return data;
}

Gets the token representation of this item in RPN

 int getFirstColumn() 
{
    return columnFirst;
}

 int getFirstRow() 
{
    return rowFirst;
}

 int getLastColumn() 
{
    return columnLast;
}

 int getLastRow() 
{
    return rowLast;
}

 public  void getString(StringBuffer buf) 
{
    CellReferenceHelper.getCellReference(columnFirst, rowFirst, buf);
    buf.append(':");
    CellReferenceHelper.getCellReference(columnLast, rowLast, buf);
}

  void handleImportedCellReferences() 
{

}

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

 public int read(byte[] data,
    int pos) 
{
    // Preserve signage on column and row values, because they will
    // probably be relative
    rowFirst =  IntegerHelper.getShort(data[pos], data[pos+1]);
    rowLast  = IntegerHelper.getShort(data[pos+2], data[pos+3]);
    int columnMask = IntegerHelper.getInt(data[pos+4], data[pos+5]);
    columnFirst = columnMask & 0x00ff;
    columnFirstRelative = ((columnMask & 0x4000) != 0);
    rowFirstRelative = ((columnMask & 0x8000) != 0);
    if (columnFirstRelative)
    {
      columnFirst = relativeTo.getColumn() + columnFirst;
    }
    if (rowFirstRelative)
    {
      rowFirst = relativeTo.getRow() + rowFirst;
    }
    columnMask = IntegerHelper.getInt(data[pos+6], data[pos+7]);
    columnLast = columnMask & 0x00ff;
    columnLastRelative = ((columnMask & 0x4000) != 0);
    rowLastRelative = ((columnMask & 0x8000) != 0);
    if (columnLastRelative)
    { 
      columnLast = relativeTo.getColumn() + columnLast;
    }
    if (rowLastRelative)
    {
      rowLast = relativeTo.getRow() + rowLast;
    }
    return 8;
}

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