All:
Both LibreOffice 3.3.0 and OpenOffice 3.3.0 support Microsoft Excel 2007/2010 workbooks. If I create a workbook using Microsoft Excel 2007 or Microsoft 2010 and attempt to open it in LibreOffice 3.3.0 or OpenOffice 3.3.0, it works flawlessly.
But if I create a Microsoft Excel 2007 workbook using the Infragistics3.Excel engine and copy that file to a box running OpenOffice 3.3.0 or LibreOffice 3.3.0, it will NOT open.
Here's how I am creating the Excel 2007 workbook:
oBook = New Workbook(WorkbookFormat.Excel2007)
Can anyone tell me why Excel 2007 workbooks created with Microsoft Office 2007 or Microsoft Office 2010 open FINE in LibreOffice 3.3.0 or OpenOffice 3.3.0, but NO Excel 2007 workbook created with the Infragistics3.Excel engine do?
Excel 97/2003 workbooks created with the Infragistics3.Excel engine open with no problem in both OpenOffice 3.3.0 and LibreOffice 3.3.0. This just seems to be an Excel 2007 workbook issue.
Kev
Hello ,
I see that you have already opened case in our system with id CAS-67785-7XK5L7, so I will update you for the progress of this issue via the case as soon as i have information for you.
Thank you.