public void ParseForEntireColumnSelections_ShouldAddMaxRowsOnColumnsWithMultipleLetters()
{
// Arrange
var address = "AB:AC";
// Act
var result = AddressUtility.ParseEntireColumnSelections(address);
// Assert
Assert.AreEqual("AB1:AC" + ExcelPackage.MaxRows, result);
}
public void ParseForEntireColumnSelections_ShouldAddMaxRows()
{
// Arrange
var address = "A:A";
// Act
var result = AddressUtility.ParseEntireColumnSelections(address);
// Assert
Assert.AreEqual("A1:A" + ExcelPackage.MaxRows, result);
}
public void ParseForEntireColumnSelections_ShouldHandleMultipleRanges()
{
// Arrange
var address = "A:A B:B";
var expected = string.Format("A1:A{0} B1:B{0}", ExcelPackage.MaxRows);
// Act
var result = AddressUtility.ParseEntireColumnSelections(address);
// Assert
Assert.AreEqual(expected, result);
}
private string CheckAndFixRangeAddress(string address)
{
if (address.Contains(','))
{
throw new FormatException("Multiple addresses may not be commaseparated, use space instead");
}
address = ConvertUtil._invariantTextInfo.ToUpper(address);
if (Regex.IsMatch(address, @"[A-Z]+:[A-Z]+"))
{
address = AddressUtility.ParseEntireColumnSelections(address);
}
return(address);
}
/// <summary>
/// Check and fix an address (string address)
/// </summary>
/// <param name="address"></param>
/// <returns></returns>
public static string CheckAndFixRangeAddress(
string address)
{
if (address.Contains(','))
{
throw new FormatException(
ExcelConditionalFormattingConstants.Errors.CommaSeparatedAddresses);
}
address = ConvertUtil._invariantTextInfo.ToUpper(address);
if (Regex.IsMatch(address, @"[A-Z]+:[A-Z]+"))
{
address = AddressUtility.ParseEntireColumnSelections(address);
}
return(address);
}
internal void SetAddress(string address)
{
var dvAddress = AddressUtility.ParseEntireColumnSelections(address);
SetXmlNodeString(_sqrefPath, dvAddress);
}
internal void SetAddress(string address)
{
var dvAddress = AddressUtility.ParseEntireColumnSelections(address);
SetXmlNodeString(GetSqRefPath(), dvAddress.Replace(",", " "));
}