excelize icon indicating copy to clipboard operation
excelize copied to clipboard

Formula calc performance issue

Open fishstormX opened this issue 5 months ago • 0 comments

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

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

fishstormX avatar Oct 22 '25 14:10 fishstormX