英文:
How to enable edition in syncfusion c#
问题
在使用C#和Worksheets创建的Syncfusion Excel文件中,默认启用编辑。文件中包含宏和公式,但当有人下载此文件时,它会在受保护视图中打开,只有在启用编辑并切换到不受保护状态后才会计算公式。是否有办法跳过受保护模式警告,一旦下载文件,就可以看到所有内容正常运行?
英文:
I need to enable edition by default in a excel file created with syncfusion in C# using worksheets. It has macros and formulas but when somebody download this file, it opens in protected view and only calculates formulas after you enable editing and change to unprotected. ¿Is there a way to skip the protected mode warning and once you download the file you can see everything working?
答案1
得分: 1
这是 MS Excel 的行为,它会以受保护视图打开从浏览器下载的 Excel 文件,以确保免受病毒侵害。可以通过 Microsoft Excel 中的选项禁用此行为。
然而,Syncfusion XlsIO 支持公式计算,我们建议在保存 Excel 文档之前调用 IWorksheet 的 Calculate 方法,以便计算公式。
英文:
It is the behavior of MS Excel to open the Excel files that are downloaded from the browser in protected view to ensure protection from viruses. This behavior can be disabled through options in Microsoft Excel.
However, Syncfusion XlsIO has support for formula calculation, and we suggest you call the Calculate method of IWorksheet, before saving the Excel document to get the formulas calculated.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论