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); }
public static bool IsRowValid(string match) { return(RefFormulaToken.IsRowValid(NumbersParser.StrToInt(match))); }