/// <summary>
/// Validates if the range is affecting any of the existing range of layers
/// and checks if the range has formula
/// </summary>
/// <param name="workSheet">Current active worksheet</param>
/// <param name="range">Current range</param>
/// <returns>Returns true if the layer is valid</returns>
private bool ValidateLocalInWWTLayerData(_Worksheet workSheet, Range range)
{
bool isValid = false;
if (ValidateAffectedMappedRange(workSheet, range))
{
if (range.ValidateFormula())
{
isValid = Ribbon.ShowWarningWithResult(Properties.Resources.RangeHasFormulaWarning);
}
else
{
isValid = true;
}
}
return isValid;
}