/// <summary>
/// Formats the name.
/// </summary>
/// <param name="definedNames">The defined names.</param>
/// <param name="name">The name.</param>
/// <returns></returns>
private static string FormatName(DefinedNames definedNames, string name)
{
if (string.IsNullOrEmpty(name))
{
name = "Range";
}
name = FormatName(name);
// Check for duplicate names.
string numberedName = name;
for (int i = 1; definedNames.OfType <DefinedName>().Any(d => string.Equals(d.Name, numberedName)); i++)
{
numberedName = string.Format("{0}_{1}", name, i);
}
return(numberedName);
}
