Skip to content

Formula calc performance issue #2223

@fishstormX

Description

@fishstormX

Description

I got a Excel with Formula,I found that the calcCellValue method takes an exceptionally long time to run,The original table formula values were
=SUMIFS($F:$F,$C:$C,">="&DATE($M$18,$M$19,1),$C:$C,"<="&EOMONTH(DATE($M$18,$M$19,1),0),$D:$D,$L22)

Suspected to be caused by formulas like '$C: $C' that select the entire column, but the actual effective data range is very small. Is there a way to constrain the available data range

Additional context

No response

Validations

  • Check that there isn't already an issue that requests the same feature to avoid creating a duplicate.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions