如何在Syncfusion的C#中启用编辑功能。

huangapple go评论67阅读模式
英文:

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 文档之前调用 IWorksheetCalculate 方法,以便计算公式。

英文:

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.

huangapple
  • 本文由 发表于 2023年2月23日 20:50:45
  • 转载请务必保留本文链接:https://go.coder-hub.com/75545077.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定