private void AddSheetReferenceToken(string sheet)
{
object[] objArray1;
string text1 = this.GetCell();
if (text1 == string.Empty)
{
this.Expected("3d sheet cell reference.");
}
sheet = sheet + "!" + text1;
if (this.GetNextOnDemand(':'))
{
string text2 = this.GetCell();
if (RefFormulaToken.IsCell(text2))
{
objArray1 = new object[] { sheet + ":" + text2, this.worksheet.Parent };
this.AddToken(FormulaTokenCode.Area3d2, objArray1);
}
else
{
this.Expected("3d area reference.");
}
}
else
{
objArray1 = new object[] { sheet, this.worksheet.Parent };
this.AddToken(FormulaTokenCode.Ref3d2, objArray1);
}
}
private void AddCellOrRangeToken(string cellValue)
{
if (this.buffer.Peek() == RefFormulaToken.AbsoluteCellMark)
{
cellValue = this.GetCell();
}
if (this.GetNextOnDemand(':'))
{
string text1 = this.GetCell();
if (RefFormulaToken.IsCell(text1))
{
this.AddArea(cellValue + ":" + text1);
}
else
{
this.Expected("Area.");
}
}
else if (this.isFunctionArgumentsProcessed)
{
this.AddToken(FormulaTokenCode.Ref1, cellValue);
}
else
{
this.AddToken(FormulaTokenCode.Ref2, cellValue);
}
}
private bool IsCell(string cellValue)
{
if (this.buffer.Peek() != RefFormulaToken.AbsoluteCellMark)
{
return(RefFormulaToken.IsCell(cellValue));
}
return(true);
}
public static bool IsCell(string match)
{
bool flag1 = false;
Match match1 = RefFormulaToken.IsCellRegex.Match(match);
if (match1.Success && (match1.Value == match))
{
flag1 = RefFormulaToken.IsValidCell(match1);
}
return(flag1);
}
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);
}
private string GetCell()
{
string text1 = string.Empty;
if (this.GetNextOnDemand(RefFormulaToken.AbsoluteCellMark))
{
text1 = RefFormulaToken.AbsoluteCellMark + this.buffer.GetNextString(false);
}
else
{
text1 = this.buffer.GetNextString(false);
}
if (this.GetNextOnDemand(RefFormulaToken.AbsoluteCellMark, false))
{
text1 = text1 + RefFormulaToken.AbsoluteCellMark + this.buffer.GetNextString(false);
}
if (!RefFormulaToken.IsCell(text1))
{
this.Expected("Cell.");
}
return(text1);
}
public static bool IsRowValid(string match)
{
return(RefFormulaToken.IsRowValid(NumbersParser.StrToInt(match)));
}