protected AreaPtgBase(AreaReference ar)
{
CellReference firstCell = ar.FirstCell;
CellReference lastCell = ar.LastCell;
FirstRow = (firstCell.Row);
FirstColumn = (firstCell.Col == -1 ? 0 : (int)firstCell.Col);
LastRow = (lastCell.Row);
LastColumn = (lastCell.Col == -1 ? 0xFF : (int)lastCell.Col);
IsFirstColRelative = (!firstCell.IsColAbsolute);
IsLastColRelative = (!lastCell.IsColAbsolute);
IsFirstRowRelative = (!firstCell.IsRowAbsolute);
IsLastRowRelative = (!lastCell.IsRowAbsolute);
}
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;
}
protected Area2DPtgBase(AreaReference ar):base(ar)
{
}
public AreaPtg(AreaReference areaRef):base(areaRef)
{
}
public Area3DPtg(AreaReference arearef, int externIdx):base(arearef)
{
ExternSheetIndex=(externIdx);
}
/*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;
}