Not a serious problem But if it will be fixed ......

[ouhaohan8023]

Hello, there is a problem with calcuate formulas when import excels.

my excel function is like this :

=IF(B:B="APPLE",100%,IF(B:B="PEACH","65%",IF(B:B="ORANGE","12%",IF(OR(B:B="COG",B:B="MGE",B:B="AFH",B:B="OOL"),"13%",0%))))

Everytime when the program run to this cell , it will stop until the memory out of limit.

I found it will work when I change the excel function like this
=IF(B3="APPLE",100%,IF(B3="PEACH","65%",IF(B3="ORANGE","12%",IF(OR(B3="COG",B3="MGE",B3="AFH",B3="OOL"),"13%",0%))))

I wonder if it will be better to make it work with B:B ?

[MarkBaker]

There are improvements in working with column ranges like B:B in the latest release of PhpSpreadsheet, but the calculation engine still has to access every cell that exists in the column to execute the calculation (which is a performance and memory overhead). It is always better if formulae reference individual cells directly, or if formulae are range limited (e.g. B1:B256)

[ouhaohan8023]

appreciate for reply