I just started working on an office add-in and I was wondering if there's any way to detect a sort initiated by the user?
I would be happy with even a potential sort, as long as it is different from a user making an edit. I checked the eventType enum and it seems like what I'm trying to do is impossible.
There is no exposed event for it. Actually, I don't believe there is an event for it even in VBA/VSTO.
What is the scenario you are trying to accomplish? What would happen if someone without your add-in were to sort manually, would your data end up in a broken state? If so, then you might want to think your design to somehow capture the data integrity in a way that doesn't rely on listening to a sort event.