Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Very slow SUMIF performance when using "Row Range Notation" #2056

Open
grahamorrell opened this issue Dec 27, 2024 · 0 comments
Open

Very slow SUMIF performance when using "Row Range Notation" #2056

grahamorrell opened this issue Dec 27, 2024 · 0 comments

Comments

@grahamorrell
Copy link

Description

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:

  1. Call CalcCellValue on a SUMIF( ) using Row Range Notation

Describe the results you received:

image

Describe the results you expected:

Performance should be almost identical in both cases because the sheet only has 25 columns.

Output of go version:

N/A

Excelize version or commit ID:

excelize-wasm 0.0.7

Windows
SUMIF Performance.xlsx

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant