protected AreaPtgBase(String arearef) 
{
       
        AreaReference ar = new AreaReference(arearef);
        CellReference firstCell = ar.getFirstCell();
        CellReference lastCell = ar.getLastCell();
        setFirstRow(firstCell.getRow());
        setFirstColumn(firstCell.getCol());
        setLastRow(lastCell.getRow());
        setLastColumn(lastCell.getCol());
        setFirstColRelative(!firstCell.isColAbsolute());
        setLastColRelative(!lastCell.isColAbsolute());
        setFirstRowRelative(!firstCell.isRowAbsolute());
        setLastRowRelative(!lastCell.isRowAbsolute());
}

 protected AreaPtgBase(RecordInputStream in) 
{
        field_1_first_row    = in.readUShort();
        field_2_last_row     = in.readUShort();
        field_3_first_column = in.readUShort();
        field_4_last_column  = in.readUShort();
}

 protected AreaPtgBase(int firstRow,
    int lastRow,
    int firstColumn,
    int lastColumn,
    boolean firstRowRelative,
    boolean lastRowRelative,
    boolean firstColRelative,
    boolean lastColRelative) 
{
        
        checkColumnBounds(firstColumn);
        checkColumnBounds(lastColumn);
        checkRowBounds(firstRow);
        checkRowBounds(lastRow);
      setFirstRow(firstRow);
      setLastRow(lastRow);
      setFirstColumn(firstColumn);
      setLastColumn(lastColumn);
      setFirstRowRelative(firstRowRelative);
      setLastRowRelative(lastRowRelative);
      setFirstColRelative(firstColRelative);
      setLastColRelative(lastColRelative);
}

 public byte getDefaultOperandClass() 
{
        return Ptg.CLASS_REF;
}

 public final int getFirstColumn() 
{
        return columnMask.getValue(field_3_first_column);
}

 public final short getFirstColumnRaw() 
{
        return (short) field_3_first_column; // TODO
}

 public final int getFirstRow() 
{
        return field_1_first_row;
}

 public final int getLastColumn() 
{
        return columnMask.getValue(field_4_last_column);
}

 public final short getLastColumnRaw() 
{
        return (short) field_4_last_column;
}

 public final int getLastRow() 
{
        return field_2_last_row;
}

 abstract protected byte getSid()

 public final int getSize() 
{
        return SIZE;
}

 public final boolean isFirstColRelative() 
{
        return colRelative.isSet(field_3_first_column);
}

 public final boolean isFirstRowRelative() 
{
        return rowRelative.isSet(field_3_first_column);
}

 public final boolean isLastColRelative() 
{
        return colRelative.isSet(field_4_last_column);
}

 public final boolean isLastRowRelative() 
{
        return rowRelative.isSet(field_4_last_column);
}

 protected final RuntimeException notImplemented() 
{
          return new RuntimeException("Coding Error: This method should never be called. This ptg should be converted");
}

TODO - (May-2008) fix subclasses of AreaPtg 'AreaN~' which are used in shared formulas. see similar comment in ReferencePtg

 public final  void setFirstColRelative(boolean rel) 
{
        field_3_first_column=colRelative.setBoolean(field_3_first_column,rel);
}

set whether the first column is relative

 public final  void setFirstColumn(int colIx) 
{
        checkColumnBounds(colIx);
    	field_3_first_column=columnMask.setValue(field_3_first_column, colIx);
}

set the first column in the area

 public final  void setFirstColumnRaw(int column) 
{
        field_3_first_column = column;
}

set the first column irrespective of the bitmasks

 public final  void setFirstRow(int rowIx) 
{
        checkRowBounds(rowIx);
        field_1_first_row = rowIx;
}

sets the first row

 public final  void setFirstRowRelative(boolean rel) 
{
        field_3_first_column=rowRelative.setBoolean(field_3_first_column,rel);
}

sets the first row to relative or not

 public final  void setLastColRelative(boolean rel) 
{
        field_4_last_column=colRelative.setBoolean(field_4_last_column,rel);
}

set whether the last column should be relative or not

 public final  void setLastColumn(int colIx) 
{
        checkColumnBounds(colIx);
    	field_4_last_column=columnMask.setValue(field_4_last_column, colIx);
}

set the last column in the area

 public final  void setLastColumnRaw(short column) 
{
        field_4_last_column = column;
}

set the last column irrespective of the bitmasks

 public final  void setLastRow(int rowIx) 
{
        checkRowBounds(rowIx);
        field_2_last_row = rowIx;
}

 public final  void setLastRowRelative(boolean rel) 
{
        field_4_last_column=rowRelative.setBoolean(field_4_last_column,rel);
}

set whether the last row is relative or not

 public String toFormulaString(HSSFWorkbook book) 
{
        return AreaReference.formatAsString(this);
}

 public final String toString() 
{
        StringBuffer sb = new StringBuffer();
        sb.append(getClass().getName());
        sb.append(" [");
        sb.append(AreaReference.formatAsString(this));
        sb.append("]");
        return sb.toString();
}

 public final  void writeBytes(byte[] array,
    int offset) 
{
        array[offset] = (byte) (getSid() + getPtgClass());
        LittleEndian.putShort(array,offset+1,(short)field_1_first_row);
        LittleEndian.putShort(array,offset+3,(short)field_2_last_row);
        LittleEndian.putShort(array,offset+5,(short)field_3_first_column);
        LittleEndian.putShort(array,offset+7,(short)field_4_last_column);
}