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