You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have an Excel workbook (minimal example attached) which has some SUMIF( ) formulae that use "Row Range Notation", for example :
=SUMIF(2:2, B11, 4:4)
These perform very poorly in Excelize despite there only being 25 columns in the worksheet. To calculate the sum of 8 of these SUMIF( ) statements takes over 3 seconds.
If I change the SUMIFs to also specify the columns, for example :
=SUMIF(B2:Y2, B11, B4:Y4)
Performance is dramatically improved, taking just 8 milliseconds to calculate the sum of 8 of them.
Steps to reproduce the issue:
Call CalcCellValue on a SUMIF( ) using Row Range Notation
Describe the results you received:
Describe the results you expected:
Performance should be almost identical in both cases because the sheet only has 25 columns.
Description
I have an Excel workbook (minimal example attached) which has some SUMIF( ) formulae that use "Row Range Notation", for example :
These perform very poorly in Excelize despite there only being 25 columns in the worksheet. To calculate the sum of 8 of these SUMIF( ) statements takes over 3 seconds.
If I change the SUMIFs to also specify the columns, for example :
Performance is dramatically improved, taking just 8 milliseconds to calculate the sum of 8 of them.
Steps to reproduce the issue:
Describe the results you received:
Describe the results you expected:
Performance should be almost identical in both cases because the sheet only has 25 columns.
Output of
go version
:Excelize version or commit ID:
Windows
SUMIF Performance.xlsx
The text was updated successfully, but these errors were encountered: