If a user selects Open, rather than Save, for a workbook downloaded through IE browser, it opens in Protected View, and none of the formulas are calculating until the user clicks the Enable Editing button.
Is there a way to override the Protected View just for the downloaded document, without changing the user’s security settings for all downloaded documents.
@FireWave
We are afraid, you must control it via Microsoft Excel Protected View Settings as shown in this screenshot.
This is actually an Application Feature not File Format Feature. Aspose.Cells deals with File Format Feature. If there had been any setting inside the Excel File Format, Aspose.Cells would be able to deal with it.
However, Microsoft Excel Application Features can only be controlled via Microsoft Excel Settings.
I was afraid of that. It’s not a big thing. They can click the Enable Editing button. I don’t want to change the application settings and create a potential security issue.
Thanks for the reply.
@FireWave
Thanks for using Aspose APIs.
We have logged your requirement in our database for further investigation. We will look into it and see if it is possible and implement it.
This issue has been logged as
-
CELLSNET-45722 - Avoid Protected View in Downloaded Workbook
@FireWave
We are afraid, it is the behavior of MS Excel so we could not support it.