public Address(string address) { var firstDigitIndex = address.IndexOfAny(Digits); if (firstDigitIndex > 0 && address[firstDigitIndex - 1] == '$') { firstDigitIndex--; } Column = new AddressColumn(address.Substring(0, firstDigitIndex)); Row = new AddressRow(address.Substring(firstDigitIndex)); }
public string ColumnMoveCases(string reference, int shift) { var column = new AddressColumn(reference).Move(shift); return($"{column.NumericPosition},{(column.IsFixed ? "f" : "nf")}"); }
public string ColumnFixedCases(string reference) { var column = new AddressColumn(reference); return($"{column.NumericPosition},{(column.IsFixed ? "f" : "nf")}"); }