如何处理Excel Pivot样式更改事件. [英] How to handle Excel Pivot style change event.

问题描述

我有一个vsto excel插件，它使用数据透视表.问题是，当用户通过Excel中的设计"选项卡更改数据透视样式时，某些数据透视表标题背景颜色没有更改.有什么办法可以找到枢纽主题是否已更改，以及 处理该事件?

I have a vsto excel addin which makes use of pivot tables. Issue is , when user changes the pivot style through Design tab in Excel, some of the pivot table header background colors are not changing. Is there any way to find if pivot theme was changed and handle that event? 

任何帮助将不胜感激.

推荐答案

Hi,

在更改数据透视表样式时，Office不提供该事件.

Office does not provide the event when changing styles of pivot tables.

Office提供了以下几个事件，并且我测试了更改样式时不会触发这些事件.

Office provides the several events below and I have tested none of them would be triggered when changing the style.

Worksheet_PivotTableAfterValueChange，

Worksheet_PivotTableAfterValueChange,

Worksheet_PivotTableBeforeAllocateChanges，

Worksheet_PivotTableBeforeAllocateChanges,

Worksheet_PivotTableBeforeCommitChanges，

Worksheet_PivotTableBeforeCommitChanges,

Worksheet_PivotTableBeforeDiscardChanges，

Worksheet_PivotTableBeforeDiscardChanges,

Worksheet_PivotTableChangeSync

Worksheet_PivotTableChangeSync

Worksheet_PivotTableUpdate

Worksheet_PivotTableUpdate

关于背景颜色的问题没有改变，建议您在

For the issue about the background colors do not be changed, I suggest you ask in

感谢您的理解，

此致

Celeste

这篇关于如何处理Excel Pivot样式更改事件.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！