protected AreaPtgBase(String arearef)
{
AreaReference ar = new AreaReference(arearef);
CellReference firstCell = ar.FirstCell;
CellReference lastCell = ar.LastCell;
FirstRow = firstCell.Row;
FirstColumn = firstCell.Col;
LastRow = lastCell.Row;
LastColumn = lastCell.Col;
IsFirstColRelative = !firstCell.IsColAbsolute;
IsLastColRelative = !lastCell.IsColAbsolute;
IsFirstRowRelative = !firstCell.IsRowAbsolute;
IsLastRowRelative = !lastCell.IsRowAbsolute;
}
/*public String Area{
RangeAddress ra = new RangeAddress( FirstColumn,FirstRow + 1, LastColumn, LastRow + 1);
String result = ra.GetAddress();
return result;
}*/
public void SetArea(String ref1)
{
AreaReference ar = new AreaReference(ref1);
CellReference frstCell = ar.FirstCell;
CellReference lastCell = ar.LastCell;
FirstRow=(short)frstCell.Row;
FirstColumn=frstCell.Col;
LastRow=(short)lastCell.Row;
LastColumn=lastCell.Col;
IsFirstColRelative=!frstCell.IsColAbsolute;
IsLastColRelative=!lastCell.IsColAbsolute;
IsFirstRowRelative=!frstCell.IsRowAbsolute;
IsLastRowRelative=!lastCell.IsRowAbsolute;
}