工作表上的VSTO C＃数据表。功能区排序无法正常工作 [英] VSTO C# datatable on worksheet. Ribbon sort not working correctly

问题描述

您好，

我有一个用C＃编写的VSTO插件项目，它向Excel输出一个数据表。列具有自动过滤器。如果没有应用过滤器，则通过使用自动过滤器选项的排序功能对数据进行排序可以得到正确的结果。但是，当我使用功能区中的
按钮或在第一个场景中记录宏时，数据表与工作表不同步。这意味着：如果1更改另一列中的单元格，它也会在不同行的同一列中更改。

I have a VSTO addin project written in C# that outputs a datatable to Excel. Columns have autofilters. With no filter applied sorting the data through usage of the sort function of the auto-filter options gives the correct result. However when I use to button in the Ribbon or record a macro on the first scenario the datatable gets out of sync with the worksheet. This means: if 1 change a cell in another column it will also change in the same column on a different row.

有人知道这里的问题是什么吗？我使用TFS excel插件测试了这种行为，但没有发现这样的行为。

Does anybody know what the problem is here? I tested this behaviour with the TFS excel plugin but have found no such behaviour.

我有一个小的独立测试项目设置会重现这种行为。

I have a small independent test-project set up that will reproduce this behaviour.

问候，

Jeroen

 

 

推荐答案

Hello Jeroen，

Hello Jeroen,

感谢您的发帖。我仔细阅读了你的帖子，但我认为你的问题对我来说不清楚，所以目前我无法提供有用的信息。为了提供进一步的帮助，您是否介意用
us分享测试项目/复制步骤？所以我可以在我身边使用它来重现这个问题并做进一步的研究。

Thanks for posting. I read your post carefully, but I think your question is unclear for me so that currently I cannot give much helpful information on this. To provide further assistance, would you mind sharing the test-project/reproducing steps with us? So I could use it on my side to reproduce this issue and do further research.

我期待着你的回复。祝你有愉快的一天。

I am looking forward to your reply. Have a nice day.

这篇关于工作表上的VSTO C＃数据表。功能区排序无法正常工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！