internal CellRange(string from, string to)
{
int fromColumn, fromRow, toColumn, toRow;
ReferenceHelper.ParseReference(from, out fromColumn, out fromRow);
// 0 indexed vs 1 indexed
FromColumn = fromColumn - 1;
FromRow = fromRow - 1;
ReferenceHelper.ParseReference(to, out toColumn, out toRow);
// 0 indexed vs 1 indexed
ToColumn = toColumn - 1;
ToRow = toRow - 1;
}
internal CellRange(string range)
{
var fromTo = range.Split(':');
if (fromTo.Length == 2)
{
ReferenceHelper.ParseReference(fromTo[0], out int column, out int row);
// 0 indexed vs 1 indexed
FromColumn = column - 1;
FromRow = row - 1;
ReferenceHelper.ParseReference(fromTo[1], out column, out row);
// 0 indexed vs 1 indexed
ToColumn = column - 1;
ToRow = row - 1;
}
}
