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; } }