User Profile
fastexcel
Brass Contributor
Joined 7 years ago
User Widgets
Recent Discussions
Re: Terrible recalculation speed on Ryzen processor
Multi-threaded recalc occurs in 2 steps. Step 1 works out how to allocate the calc between threads Step 2 then actually does the calc. Usually the results of previous Step 1 optimisations are used as a starting point for subsequent recalcs so the time taken to do step 1 diminishes on subsequent recalcs. Difficult to make any sensible comments without looking at the actual workbook (would be happy to do that if possible) Charles WilliamsRe: Getting the previous spill range of a dynamic array function
pyxll My (not-yet-implemented) design for formatting dynamic arrays does this by storing the spill dimensions of the spill ref as cell metadata using the aftercalculate event. The cell metadata could be stored in various ways. To make it persist maybe define a Name for the spill ref and then use the Name as a key to an array/list/dictionary/collection thing that could be persisted as custom xml parts. Or for a non-persistent kludge use Cell.ID
