MS Report Viewer 2008 导出到 Excel 合并单元格问题
我们正在使用MS Report Viewer将报告导出到Excel,现在我们在尝试对数据进行排序时遇到问题,它报告错误,存在合并单元格并且无法排序。那么有没有办法在导出到excel时禁用单元格合并呢?
提前致谢。
We are using MS Report Viewer for exporting Reports to Excel, now we have a problem when trying to sort data, its reporting error that there are merged cells and it can't be sorted. So is there a way to disable cell merging when exporting to excel?
Thanks in advance.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
据我所知,没有办法将其关闭。但是,我只在使用页眉或页脚时才注意到这是一个问题。这就是为什么我经常在报告中将页眉和页脚设为可选,以避免 Excel 合并单元格问题。
To my knowledge there is no way to turn this off. However, I only notice it being a problem when I use page headers or page footers. This is why often times I'll make page headers and footers optional in my reports to avoid the Excel merge cell issue.