Skip to content

Spreadsheet incorrect formula parsing #4856

@yanmariomenev

Description

@yanmariomenev

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

  1. Open an online example like our overview.
  2. Use the following Excel Spreadsheet: Telerik_Spreasheet_Formulas_Not_Working.xlsx
  3. Navigate between both sheets and see the differences in both MS Excel and the Spreadsheet component.

Screenshots or video

Spreadsheet results:

Image Image

MS Excel:

Image Image

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions