Geeks With Blogs
Scott Lock Thoughts on .Net, and Windows Phone February 2007 Entries
Getting an instance of the managed container for an interop object in Excel 2003 using VSTO 2005
This has been posted in the newsgroups a few times, but really is required when adding dynamic controls. If you are trying to get references to the managed (Excel.Tools) object, this is the way to go. This creates a new managed worksheet object that has a controls collection that you can then use. Here is the basic code for the function: internal Microsoft.Office.Tools.Exce... GetExtendedWorksheet( ref Microsoft.Office.Interop.Ex... nativeWorksheet) { // Get the IHostItemProvider ......

Posted On Friday, February 9, 2007 10:56 PM

Dynamic Control Bugs - VSTO 2005, Formulas and Groupings
During a recent project where we are customizing Excel 2003 using Visual Studio Tools for Office 2005, we encountered two issues that we thought were our problems: Issue 1: When you dynamically add a control to a worksheet, such as a combobox or lisbox, and then go into "formula mode" by clicking on the formula toolbar the controls do not repaint correctly. If you navigate to a worksheet other than the one they are added to, the controls will appear to "float" in their original fixed position in ......

Posted On Friday, February 9, 2007 10:41 PM

Copyright © Scott Lock | Powered by: