在Excel 2016中访问ActiveBhart时Excel崩溃在Excel 2016中的OnUpdate处理程序（64位） [英] Excel crashing when accessing ActiveChart in CommandBars OnUpdate handler in Excel 2016 (64 bit)

问题描述

我们正在开发一个插件，并且在使用Excel 2016（64位）时遇到了一些问题。以下描述了我们的情况：

1.我们的插件已安装且处于活动状态。

2.我们打开一个空白的新工作簿，写一些数字并插入Excel图表。

3.我们关闭Excel窗口并选择不保存（如果在关闭工作簿时选择了图表，则无关紧要。）

Excel关闭并且它会显示一条崩溃的消息。这是每次都可重复的：

错误的应用程序名称：EXCEL.EXE，版本：16.0.6001.1034，时间戳：0x561f40a3

错误模块名称：ucrtbase.DLL，版本：10.0.10240.16384，时间戳：0x559f3851

异常代码：0x40000015

故障偏移：0x0000000000065a5f

故障流程ID：0x450

故障应用程序启动时间： 0x01d11b8cf0fd7651

错误应用程序路径：C：\Program Files \ Microsoft Office \Root \Office16 \EXCEL.EXE

错误模块路径：C：\Program Files \ Microsoft Office \Root\Office16\ucrtbase.DLL

报告ID：431089f1 -8780-11e5-90cb-001c42be5d20

如果我们禁用插件，则不会发生这种情况。如果工作簿中没有Excel图表，它也不会发生。

我们还跟踪了问题，发现问题似乎是访问CommandBars中的Application.ActiveChart属性。 OnUpdate事件处理程序。如果我们不访问该属性，它也不会崩溃。

1. 是否有任何已知的问题描述了类似的情况？
2. 什么可能导致此异常？我试过在网上搜索，这个例外有很多不同的解决方案，但它们要么不适用于我们的情况，要么它们不起作用。
3. 有趣的是，这只发生在"老" Excel图表。如果我们插入例如2016年添加的瀑布图表，则不会发生此问题。似乎旧图表和新图表的逻辑不同。也许
   旧图表移植到新架构并引入了一些问题？或类似的东西。
4. 也许您可以提供调试此问题的指南？什么是ucrtbase.DLL，什么可能导致它崩溃？

谢谢。

解决方案

> ;> CommandBars.OnUpdate事件处理程序中的Application.ActiveChart属性。如果我们不访问该属性，它也不会崩溃。<<

根据描述，您正在自定义Office UI。

在某些Microsoft Office应用程序中使用CommandBars已被Microsoft Office Fluent用户界面的新功能区组件取代。有关详细信息，请搜索关键字"功能区"的帮助。

b

我建议您使用Microsoft Office Fluent用户界面而不是CommandBar进行开发，以查看是否问题已修复。

以下是一些有关Office功能区自定义的有用链接供您参考：

功能区概述

功能区XML

演练：使用功能区XML创建自定义选项卡

问候&费

We are developing an addin and are having some issues with Excel 2016 (64 bit). The following describes our situation:
1. Our addin is installed and active.
2. We open a blank new Workbook, write some numbers and insert an Excel chart.
3. We close the Excel window and choose not to save it (it does not matter if the chart is selected when closing the Workbook).

Excel closes and it displays a message that it crashed. This is repeatable every single time:

Faulting application name: EXCEL.EXE, version: 16.0.6001.1034, time stamp: 0x561f40a3
Faulting module name: ucrtbase.DLL, version: 10.0.10240.16384, time stamp: 0x559f3851
Exception code: 0x40000015
Fault offset: 0x0000000000065a5f
Faulting process id: 0x450
Faulting application start time: 0x01d11b8cf0fd7651
Faulting application path: C:\Program Files\Microsoft Office\Root\Office16\EXCEL.EXE
Faulting module path: C:\Program Files\Microsoft Office\Root\Office16\ucrtbase.DLL
Report Id: 431089f1-8780-11e5-90cb-001c42be5d20

If we disable our addin this does not happen. If there are no Excel charts in the workbook it also does not happen.

We also tracked down the issue and found out that the problem seems to be accessing Application.ActiveChart property in the CommandBars.OnUpdate event handler. If we do not access that property it also does not crash.

1. Is there any know issue that describes a similar scenario?
2. What could cause this Exception? I have tried searching the web and there are many different solutions for this Exception but they either do not apply to our case or they did not work.
3. It is funny to note that this only happens with the "old" Excel charts. This issue does not happen if we insert for example Waterfall chart that was added in 2016. It seems that the logic for the old and the new charts is different. Maybe the old charts were ported to the new architecture and some issue was introduced? Or something along those lines.
4. Maybe you can offer guidelines for debugging this issue? What is the ucrtbase.DLL, what could cause it to crash?

Thanks.

解决方案

Hi,

>>Application.ActiveChart property in the CommandBars.OnUpdate event handler. If we do not access that property it also does not crash.<<

Based on the description, you were customizing the Office UI.

The use of CommandBars in some Microsoft Office applications has been superseded by the new ribbon component of the Microsoft Office Fluent user interface. For more information, search Help for the keyword "ribbon."

I suggest that you using the Microsoft Office Fluent user interface instead of CommandBar developing to see whether the issue was fixed.

Here are some helpful links about Office ribbon customization for you reference:
Ribbon Overview

Ribbon XML

Walkthrough: Creating a Custom Tab by Using Ribbon XML

Regards & Fei

这篇关于在Excel 2016中访问ActiveBhart时Excel崩溃在Excel 2016中的OnUpdate处理程序（64位）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！