Area() 
{

}

Constructor

 Area(String s) 
{
    int seppos = s.indexOf(":");
    Assert.verify(seppos != -1);
    String startcell = s.substring(0, seppos);
    String endcell = s.substring(seppos + 1);
    columnFirst = CellReferenceHelper.getColumn(startcell);
    rowFirst = CellReferenceHelper.getRow(startcell);
    columnLast = CellReferenceHelper.getColumn(endcell);
    rowLast = CellReferenceHelper.getRow(endcell);
    columnFirstRelative = CellReferenceHelper.isColumnRelative(startcell);
    rowFirstRelative = CellReferenceHelper.isRowRelative(startcell);
    columnLastRelative = CellReferenceHelper.isColumnRelative(endcell);
    rowLastRelative = CellReferenceHelper.isRowRelative(endcell);
}

Constructor invoked when parsing a string formula

Parameters:

s - the string to parse

 public  void adjustRelativeCellReferences(int colAdjust,
    int rowAdjust) 
{
    if (columnFirstRelative)
    {
      columnFirst += colAdjust;
    }
    if (columnLastRelative)
    {
      columnLast += colAdjust;
    }
    if (rowFirstRelative)
    {
      rowFirst += rowAdjust;
    }
    if (rowLastRelative)
    {
      rowLast += rowAdjust;
    }
}

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

  void columnInserted(int sheetIndex,
    int col,
    boolean currentSheet) 
{
    if (!currentSheet)
    {
      return;
    }
    if (col < = columnFirst)
    {
      columnFirst++;
    }
    if (col < = columnLast)
    {
      columnLast++;
    }
}

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 (col <  columnFirst)
    {
      columnFirst--;
    }
    if (col < = columnLast)
    {
      columnLast--;
    }
}

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[9];
    data[0] = !useAlternateCode() ? Token.AREA.getCode() :
                                    Token.AREA.getCode2();
    IntegerHelper.getTwoBytes(rowFirst, data, 1);
    IntegerHelper.getTwoBytes(rowLast, data, 3);
    int grcol = columnFirst;
    // Set the row/column relative bits if applicable
    if (rowFirstRelative)
    {
      grcol |= 0x8000;
    }
    if (columnFirstRelative)
    {
      grcol |= 0x4000;
    }
    IntegerHelper.getTwoBytes(grcol, data, 5);
    grcol = columnLast;
    // Set the row/column relative bits if applicable
    if (rowLastRelative)
    {
      grcol |= 0x8000;
    }
    if (columnLastRelative)
    {
      grcol |= 0x4000;
    }
    IntegerHelper.getTwoBytes(grcol, data, 7);
    return data;
}

Gets the token representation of this item in RPN

 int getFirstColumn() 
{
    return columnFirst;
}

Accessor for the first column

 int getFirstRow() 
{
    return rowFirst;
}

Accessor for the first row

 int getLastColumn() 
{
    return columnLast;
}

Accessor for the last column

 int getLastRow() 
{
    return rowLast;
}

Accessor for the last row

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

Gets the string representation of this item

  void handleImportedCellReferences() 
{

}

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

 public int read(byte[] data,
    int pos) 
{
    rowFirst =  IntegerHelper.getInt(data[pos], data[pos + 1]);
    rowLast  = IntegerHelper.getInt(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);
    columnMask = IntegerHelper.getInt(data[pos + 6], data[pos + 7]);
    columnLast = columnMask & 0x00ff;
    columnLastRelative = ((columnMask & 0x4000) != 0);
    rowLastRelative = ((columnMask & 0x8000) != 0);
    return 8;
}

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

  void rowInserted(int sheetIndex,
    int row,
    boolean currentSheet) 
{
    if (!currentSheet)
    {
      return;
    }
    if (rowLast == 0xffff)
    {
      // area applies to the whole column, so nothing to do
      return;
    }
    if (row < = rowFirst)
    {
      rowFirst++;
    }
    if (row < = rowLast)
    {
      rowLast++;
    }
}

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 row,
    boolean currentSheet) 
{
    if (!currentSheet)
    {
      return;
    }
    if (rowLast == 0xffff)
    {
      // area applies to the whole column, so nothing to do
      return;
    }
    if (row <  rowFirst)
    {
      rowFirst--;
    }
    if (row < = rowLast)
    {
      rowLast--;
    }
}

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

 protected  void setRangeData(int colFirst,
    int colLast,
    int rwFirst,
    int rwLast,
    boolean colFirstRel,
    boolean colLastRel,
    boolean rowFirstRel,
    boolean rowLastRel) 
{
    columnFirst = colFirst;
    columnLast = colLast;
    rowFirst = rwFirst;
    rowLast = rwLast;
    columnFirstRelative = colFirstRel;
    columnLastRelative = colLastRel;
    rowFirstRelative = rowFirstRel;
    rowLastRelative = rowLastRel;
}

Used by subclasses columns/row range to set the range information