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…)
Hello ,
The latest service release of 10.2 is 2151, so you could download it and test your scenario.
Also I have tried to reproduce your issue on my side with mentioned release, but I was not able to get the behavior that you described. I am sending you the sample that I have created. Please run the attached sample and press “Export” button. For my test I was using UltraGridExelExporter 3.0, also I have test it and with UltraGridExelExporter 2.0 and I was not able to get the mentioned error. My OS is Win 7 SP1, and I try to open the exported file with Excel 2007 and 2010.
Please test your scenario with the latest service release of 10.2 and if your issue still exist , please post a small sample that illustrates your issue and also give me more information about the Excel that you are using to open the exported file, your OS and the exact steps that I should follow in order to reproduce your issue on my machine.
I am waiting for your response.
One additional note... I'm not doing exports from a grid I am using the Excel.Wookbook and Excel.Worksheet objects directly...
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
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,
Are the files with the problem being written out on a Windows XP machine or does it happen with any machine?