You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Describe the bug
When a generated Excel file includes formulas, and the file is generated by a website and downloaded, Excel opens the file in "Protected View" and the formula cells are displayed as blank (note that Protected View is NOT activated when files are downloaded from localhost).
Is there a way to provide initial values for the cells which contain formulas?
To Reproduce
Generate a cell which contains a formula, using wc.formula("....")
Upload the code to a webserver (not served from localhost)
Generate and download the file.
Open the file in Excel.
The file looks like this and the formulas are blank:
It's necessary to click on "Enable Editing" to display the formula values:
Note that I cannot instruct all my webapp users to disable "Protected View".
Expected behavior
The result of each formula should be visible even in "Protected View".
Additional context
I have tried adding a number to the cell as well as a formula with:
wc.number(100);wc.formula(....);
And although this increases the size of the generated file, the numbers are not displayed in protected view.
Is there a solution to this?
The text was updated successfully, but these errors were encountered:
Describe the bug
When a generated Excel file includes formulas, and the file is generated by a website and downloaded, Excel opens the file in "Protected View" and the formula cells are displayed as blank (note that Protected View is NOT activated when files are downloaded from localhost).
Is there a way to provide initial values for the cells which contain formulas?
To Reproduce
wc.formula("....")
The file looks like this and the formulas are blank:
Note that I cannot instruct all my webapp users to disable "Protected View".
Expected behavior
The result of each formula should be visible even in "Protected View".
Additional context
I have tried adding a number to the cell as well as a formula with:
And although this increases the size of the generated file, the numbers are not displayed in protected view.
Is there a solution to this?
The text was updated successfully, but these errors were encountered: