Posted 8 September 2017, 3:00 pm EST
I have a situation I need guidance on.
I have created a Find/Replace dialog that has a public variable fps as Farpoint.Win.Spread.FpSpread.
I show the dialog setting fps variable to an object spreadsheet in what ever form calls the dialog. The reason I do this is I want to make this dialog generic, not tied to a specific spread control on a specific form, so if I have multiple forms with different spread controls, I want to be able to search and replace using the dialog. Works great, except...
I have specific functionality in the Change event of the object spread controls.
I am expecting this event to fire when my dialog replaces text but it does not fire. I am supposing the reason is that by setting the object spread to the find/replace dialog public variable, it is somehow disconnected from the object spread control events. It is clear that when I get a hit on a search string and replace the .text property of the cell, it does reflect in the object spreadsheet cell but I need the event to fire.
What would a good technique be to get this accomplished?
Thanks for your help