Kbase P166363: Using Infragistics Excel controls to generate Excel2007 spreadsheets produces files that are unreada
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/06/2010 |
|
Status: Unverified
SYMPTOM(s):
Using Infragistics Excel controls to generate Excel2007 spreadsheets produces files that are unreadable in Excel
Excel found unreadable content in '<worksheet>'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.
FACT(s) (Environment):
Windows
Microsoft Office 2007
Microsoft Excel 2007
OpenEdge 10.2x
CAUSE:
The FirstVisibleTabIndex property is a zero based property. There was only a single worksheet in the workbook and this property was being set to 1 instead of 0 and 1 points to the second worksheet, which didn't exist.
FIX:
Set the FirstVisibleTabIndex property to (Worksheet Number - 1)