Excel 2010中的ActiveX包装器问题 [英] ActiveX wrappers issue with Excel 2010
问题描述
我正面临着ActiveX包装器的问题在Excel 2010中用于显示不同的UI组件。
我使用VSTO插件渲染Excel工作簿中的控件数量。当我保存工作簿时，控件被删除但相应的ActiveX包装器存储在工作簿中。
当我重新打开工作簿并尝试插入再次控制，它会抛出异常"无法插入对象"。
附件包含一个VSTO解决方案，其中包含可重现问题的工作簿。以下是重现问题的步骤：
1。提取并打开解决方案。在
http://1drv.ms/MraOEO 分享。
2。运行解决方案。这将打开excel。
3。打开附件。在
http://1drv.ms/1eGVoCq 上分享 （提取并打开）
Hi,
I am facing an issue with ActiveX wrappers which are used in Excel 2010 to display different UI components.
I am rendering number of controls in Excel workbook using VSTO addin. When I save the workbook, controls get deleted but the corresponding ActiveX wrappers get stored in the workbook.
When I reopen the workbook and try to insert the controls again, it throws exception "Cannot insert object".
Attachment contains a VSTO solution with workbook in which issue is reproducible. Following are the steps to reproduce the issue:
1. Extract and open the solution. Shared at
http://1drv.ms/MraOEO
2. Run the solution. This will open the excel.
3. Open the attached file. Shared at
http://1drv.ms/1eGVoCq (Extract and open it)
4。点击"插入控件"按钮。这将显示错误。
此问题不会出现在每个"保存"操作中。在保存和插入控制时随机出现。
此问题不能与Excel 2007重现。此外，如果我将损坏的文件保存在Excel 2007上，它也可以在Excel 2010上正常工作。似乎Excel 2010在文件中进行了一些更改，导致此问题。
4. Click on "Insert Control" button. This will show an error.
This issue doesnt appear on every Save operation. It is coming randomly on saving and inserting control.
This issue is not reproducible with Excel 2007. Also, if I save the corrupted file on Excel 2007, it works fine on Excel 2010 as well. Seems like Excel 2010 makes some changes in the file which causes this issue.
   如果有人遇到过这个问题或有任何关于这个问题的想法，请告诉我。
Please let me know if anyone has faced this issue or any idea about the issue.
谢谢&此致，
Diptesh Raut。
Diptesh Raut.
Diptesh Raut。
Diptesh Raut.
推荐答案
您好，
以下是我正在使用的Excel版本详细信息：
Following are the Excel version details I am using:
MS Excel 2010（14.0 .7109.5000）SP1 MSO（14.0.7113.5005）
MS Excel 2010 (14.0.7109.5000) SP1 MSO (14.0.7113.5005)
我在Excel 2013上也尝试了同样的功能，它在那里也运行良好。如果此问题有任何解决办法，请与我们联系。
I have tried the same on Excel 2013 as well, it worked fine there as well. Please let me know if there is any fix available for this issue.
谢谢&此致，
Diptesh Raut。
Diptesh Raut.
这篇关于Excel 2010中的ActiveX包装器问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
