When the June 28th patch is applied to existing Office installations XLS files generated by the Infragistics.Excel object are flagged as having a bad format and a "Do you want to continue?" dialog appears, if you say yes the file is opened successfully. XLSX files appear to be okay...
I'm currently using version 10.2.20102.2064, is there a later version that resolves this problem?
I don't believe something like this has been reported or fixed recently. I have forwarded this post to the Developer Support Manager and a DS engineer will be contacting you about this issue.
Thanks Mike. I inadvertently left out the name of the update which causes the problem: “Microsoft Office File Validation Add-in”.
(It evidently also causes extreme slow-downs in opening workbooks on network shares as well…)
One additional note... I'm not doing exports from a grid I am using the Excel.Wookbook and Excel.Worksheet objects directly...
Hello ,
It will be good if you are able to reproduce your issue in a small sample in order to look into it.
I am waiting for your details.
Sorry for the delay, the program this was extracted from was fairly large. The first thing in the program that seems to cause the problem is setting the Workbook.DocumentProperties. An example is attached…
I have the same issue using Infragistics3.Excel.v10.2 (10.2.20102.2096), VS2010 as Thor. I've been using this for about 6 months with no issues. But after the Microsoft Path Office Validation add-in was installed, my users are getting this "scary" warnings.
I used Thor's test project as got the same results. If you don't set the document properties, no warning, as soon as you set one, the "Validation warning" appears.
This only appears when using the excel format WorkbookFormat.Excel97To2003 (BIFF8, format I believe).
Don Verhagen
Are the files with the problem being written out on a Windows XP machine or does it happen with any machine?
Mike D,
I have tested on the following:
WinXP (32 bit) - Office 2003 / Office 2007 - Offilce File Validation Error occurs when attempting to open document.
Win7 (32 bit)- Office 2010 - No Error/Warning occurs when opening .xls document.
Thanks,