public static bool IsCellRange(string match)
{
bool flag1 = false;
Match match1 = AreaFormulaToken.IsCellRangeRegex.Match(match);
if (match1.Success)
{
flag1 = RefFormulaToken.IsColumnValid(match1.Groups["Column1"].Value);
flag1 = flag1 ? RefFormulaToken.IsColumnValid(match1.Groups["Column2"].Value) : flag1;
}
return(flag1);
}
private static bool IsValidCell(Match regexMatch)
{
string text1 = regexMatch.Groups["Row"].Value;
if (text1[0] == RefFormulaToken.AbsoluteCellMark)
{
text1 = text1.Remove(0, 1);
}
string text2 = regexMatch.Groups["Column"].Value;
if (text2[0] == RefFormulaToken.AbsoluteCellMark)
{
text2 = text2.Remove(0, 1);
}
if (RefFormulaToken.IsColumnValid(ExcelColumnCollection.ColumnNameToIndex(text2)))
{
return(RefFormulaToken.IsRowValid(ExcelRowCollection.RowNameToIndex(text1)));
}
return(false);
}