No formula recalculation during sort required

User 677b9c22ff

04-01-2010 16:04:05

Hi,


I usually work with the SortFilter or Advanced Filter or AutoFilter in EXCEL (2003/2007). Using  a sheet with 100 cols x 10000 rows the sorting process is very slow if all values are always recalculated. Would it be possible to turn that off, because its not needed. Not sure if this already implemented. I am using v1.1.2


Cheers
Tobias

ChemAxon 0e37943a96

05-01-2010 04:59:15

Hi,


unfortunately this is the default behaviour of Excel. When it does sorting, the cell contents are actually changing, so it recalculates.


We could speed it up by caching the calculation results in the future. This will probably not fit into 1.2, but we will try to put it in 1.3.


Regards,


Tamas.