public SheetRange this[Range range]
{
get { return new SheetRange(this, range); }
}
public static string Format(Range range, bool absolute = false)
{
if (absolute)
{
var cell1 = range.Cell1;
var cell2 = range.Cell2;
var cell1Str = Cell.Format(cell1.Row, cell1.Col, true, true);
var cell2Str = Cell.Format(cell2.Row, cell2.Col, true, true);
return cell1Str + ":" + cell2Str;
}
return range.ToString();
}
public SharedFormula(String formula, Range range, Cell origin)
{
this.Formula = formula;
this.Range = range;
this.Origin = origin;
}
public SheetRange(Sheet sheet, Range range)
{
Sheet = sheet;
Range = range;
}