text: public static CellRangeAddress ValueOf(String reference){int sep = reference.IndexOf(":", StringComparison.Ordinal);CellReference a;CellReference b;if (sep == -1){a = new CellReference(reference);b = a;}else{a = new CellReference(reference.Substring(0, sep));b = new CellReference(reference.Substring(sep + 1));}return new CellRangeAddress(a.Row, b.Row, a.Col, b.Col);}