1
votes

How can one tell whether a user has changed/edited/deleted/added a formula in an Excel worksheet using C# VSTO?

So far, what I have been thinking about is to attach an event handler which can tell me whether the user is changing a cell. But even this approach is problematic because existing events relating to user editing cells do not seem to be able to tell you the previous and the new value, so I do not really know if an old formula is being overwritten. What is the right approach to this question?

1

1 Answers

1
votes

How about you handle SheetSelectionChange, cache the selection values and then when (and if) SheetChange is raised you compare the new value(s) with the old.