SpreadsheetGear 2023
SpreadsheetGear 2023 > What's New > SpreadsheetGear 2012 > Limitations

Our goal since we started development of Open XML support was to read from and write to Excel Open XML (.xlsx and .xlsm) files everything which we support in our API and as many of the elements as possible which SpreadsheetGear for .NET can read and write from / to Excel 97-2003 (.xls) files.  Unfortunately, a few features supported in the .xls file format currently have limited support or no support in the ISO 29500 Strict Open XML.

We intend to support all of these features eventually. We base new features primarily on customer feedback, so let us know what is important to you.

These limitations were introduced in SpreadsheetGear 2008 and have not changed with the release of SpreadsheetGear 2009, SpreadsheetGear 2010 or SpreadsheetGear 2012. Microsoft has not fixed these particular issues with Excel 2010. Doug Mahugh, Lead Standards Professional on the Office Interoperability team at Microsoft, addressed this issue in his blog in a post titled "Office's Support for ISO/IEC 29500 Strict" on April 6th, 2010. In that article, Mr. Mahugh stated:

These commitments by Microsoft give us confidence that we will be able to address these issues after "Excel 15" is released.

Issues not related to Open XML file format limitations (such as conditional format support being limited to Excel 2003 conditional format features) will be handled as all unimplemented features are. They will be prioritized based on customer feedback, taking into account the amount of work involved in implementing each feature.

SpreadsheetGear 2012 Limitations: