Make the Evaluate Formula dialog box re-sizable
The evaluate formula box is unusable with large and/or CSE formulas. Please just make it re-sizeable. Thank you.
Peter Bartholomew commented
Agreed. Full screen would be good.
With large arrays it is probable sufficient to see the 'corner' elements once you have stepped out from the array calculation itself.
AND make it evaluate each portion of a formula: no evaluating a VLOOKUP() as a monolith, for instance.
Or at least add a checkbox to enable the more granular approach.
And to preempt the F9 comments, that helps, but has its own problems, not least of which is that for many bits in a formula, once you evaluate the piece with F9, it is unusable. So one must ESC, then begin again and not evaluate that bit or to Undo, and select a larger grain to proceed with... not always easy in practice if earlier evaluations have presented huge arrays. The Evaluate feature should be able to present that in a toaster-like usability. And the F9 approach is defeated when an array that would be presented is big.
John D. commented
this feature is more than overdue. Well it's not even a feature. It is what one would expect after decades of development.
I have stumbled upon this many many times.