Posted 8 September 2017, 1:10 pm EST
It appears that the Expand event is not raised when I use the ExpandRow method in code. Is this the case or am I missing something here? If it is not raised, why is it not raised? The logical place to put any customization code is in the Expand event so that you handle the user clicking the node. So if I don't want to do anything special programmatically except implement Expand All, Collapse All buttons on my main form, all I should have to do is loop through all of the rows in the sheet and call ExpandRow. It is counter intuitive that I should also have to manually call the Expand event.
Obviously, for large customizations you may want to pull everything into a separate method and call the method from both places. But I shouldn't have to be forced to do this, especially for small changes.