Description
There are specific cases where formulas are not parsed correctly by the component, which results in an incorrect value in the cell or #CIRCULAR text. For example:
Formula: =SUM(SUMIF(A:A, "=D2", B:B), SUMIF(A:A, "=E2", B:B))
Formula: =SUM(VLOOKUP("D2", A:B, 2, false), VLOOKUP("E2", A:B, 2, false))
Steps To Reproduce
- Open an online example like our overview.
- Use the following Excel Spreadsheet: Telerik_Spreasheet_Formulas_Not_Working.xlsx
- Navigate between both sheets and see the differences in both MS Excel and the Spreadsheet component.
Screenshots or video
Spreadsheet results:
MS Excel:

Description
There are specific cases where formulas are not parsed correctly by the component, which results in an incorrect value in the cell or
#CIRCULARtext. For example:Formula: =SUM(SUMIF(A:A, "=D2", B:B), SUMIF(A:A, "=E2", B:B))
Formula: =SUM(VLOOKUP("D2", A:B, 2, false), VLOOKUP("E2", A:B, 2, false))
Steps To Reproduce
Screenshots or video
Spreadsheet results:
MS Excel: