I have tried to avoid asking this, likely just an issue of pride, however, at this point I am frustrated and need some insight.
I'm using MVVM with Unity IOC containers, as seen in pic "1" I load up an existing spreadsheet using a "behavior" class (pics 2 & 3). The existing spreadsheet has some pre-formatting that I would like to use, rather than doing it in code. End goal is to open that "template spreadsheet" and then inject values into it via the ViewModel (pic 4).
But, what I actually see is that the spreadsheet loads in the control & for a moment I can see all of the injected values (pic 5), but then they are overwritten by the "template spreadsheet" (pic 6) and so far I have been unable to figure out what I am doing wrong since it all seems backwards from what I would expect.
In any case, I need to be able to load an existing spreadsheet to use as a "template" then inject changes into that template and have it rendered to the user so hopefully someone can provide an example of doing that, using MVVM.
Attachment:
Pictures_4b3e8523.zip