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…)
This seems very similar to this post: http://community.infragistics.com/forums/p/57538/293438.aspx
Are you experiencing this problem on a Windows XP machine?
Yes, a hair under 85% of our users are on Windows XP (DoD, Defense Contractors, Suppliers). As I mentioned in the first post, it only pops up after the update is applied.
Since my last post I've also discovered that you don't even need to set any properties. A simple:
With mWorkbook.DocumentProperties End With
Will trigger the pop-up...
I don't think I was clear in what I really wanted to know. Has the problem ever occurred on a machine that was not running Windows XP? The reason I ask is a bug related to this was fixed recently but it only occurred when the Excel file was saved on a Windows XP machine. I think this issue might also be fixed by the same fix, but if you've experienced the issue on a Vista or Windows 7 machine, then it is probably not the same bug.
We have only tested creating the file under Windows XP x86 and Windows Server 2003 x64 R2. Opening it has only been done under Windows XP x86 (Office 2003 and Office 2007).
A final update. The problem was finally resolved by two changes:
1. I moved to 2010.3 with the latest patches applied. That got my small sample past the problem with setting document properties, but the warning still occurred in the production application.
2. In the application the problem was traced to clearing cell formats to “” rather than to “General”. That hadn’t been a problem in the past (with Excel itself), but it can trigger the problem with the new validation add-in…