I am currently generating a excel file with XLSXWRITER and uploaded the generated file to blob storage. when I download the excel file with SAS URL. When I open downloaded excel file the cells that contain a formula display "0" instead of the formula output number. The top of the Excel 2010 window states "Protected View This file originated from an Internet location and might be unsafe. Click for more details. Enable Editing. Once enable editing is clicked the cells that displayed "0" now display the correct formula output numbers.
So, My questions:
- Is there a way to display formula output numbers without having to click Enable Editing?
No comments:
Post a Comment