Saved excel file opening in protected view

Posted by: tony-c on 8 September 2017, 3:00 pm EST

  • Posted 8 September 2017, 3:00 pm EST

    Hi,

         I am using Spread version 5.0.2003.2008 in Visual Studio 2008.

    I am saving the xls file using SaveExcel (filename), I have also tried SaveExcel (filename,flags) using the SaveAsVeiwed flag and a couple others.

    The result is the same when I open the saved Excel file, I recieve the message "Protected View Office has detected a problem with this file. Editing it may harm your computer."

    I am using Excel 2010, saving the file out as filename.xls, if i save it using the xlsx etension it will not open. Any ideas on what I'm doing wrong?

    Thanks in advance,

    Tony

  • Replied 8 September 2017, 3:00 pm EST

    Hi,

    It sounds like Spread is not writing the file out correctly.  The version you are using is pretty old, from December 2009, and there are many fixes in the last build of version 5 from August 2011 that you can download here:

    ftp://ftp.fpoint.com/SpreadWinForms5/spwin5_net20-2022.zip

    The problem you're having might be fixed in that release.  In that case, the upgrade to version 5.0.2022.2008 is covered under your v5 license.  If the problem persists in the last v5 build, you should try to latest release of v6, which you can download here:

    http://www.componentone.com/Downloads/

    The setup installer for v6 will install the 30 day free trial, which you can use to try upgrading your project to see if it fixes the issue.  Upgrade instructions are in the readme.chm in the Docs folder.  New features of v6 are covered here:

    http://www.componentone.com/SuperProducts/SpreadNET/What%27s+New/

  • Replied 8 September 2017, 3:00 pm EST

    Thank you for your response.

    It sounds like upgrading the control will definately be a benifit.

    I was however able to find a work around, by checking if the user has Excel 2007 or 2010 installed using the SaveExcel method, using a file name with the extension .xlsx and the save excel flag

    UseOOXMLFormat. I am able to open the file saved without recieving the warning message in excel 2010.

    Thanks again for your assistance

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels