Hi
Using UltraGridExcelExporter, I am experiencing a problem opening some spreadsheets using Excel 2003. On opening a spreadsheet the following message is displayed:
"Office File Validation detected a problem while trying to open this file. Opening it may be dangerous".
Open and Cancel options are available and if Open is selected the spreadsheet seems to load up just fine.
I have recently upgraded to 2011 vol 1 and this error did not occur with previous releases.
The problem appears to be associated with spreadsheets where I set WorkBook.DocumentProperties such as Author and Title and it's almost as if they are regarded as a security risk by Excel.
Any help much appreciated.
Regards
Adrian
Has this issue been resolved?
Hello ,
I have created a support ticket for you with id CAS-68596-RYSQWN in order to link your case with existing issue in our system, and when the fix is avalibe you will be notified.
Thank you.
Hi Mike
I'm saving the file on a machine with XP Pro SP3 and opening the file on the same machine with Excel 2003. I haven't yet tried other combinations.
Attached is a simple and crude VS2005 C# solution that exhibits the issue. If you leave the 'Author' and 'Title' fields blank and then export, the error is not reported when opening. However, if you fill in either of the Author or Title fields then the message is displayed. You'll see in the code that I use these values to populate Workbook.DocumentProperties.
Hi Adrian,
What operating system are you saving the file on? There was a recent problem with saving files on a Windows XP machine and then trying to open the file in Excel 2010 that was fixed.
But that doesn't seem like it's the same issue.
Can you duplicate this behavior in a small sample project and post it here so we can take a look?