In This Topic
There are a few known limitations of Excel for .NET.
- There is no support for the PivotTable declaration.
- VBA Macro is supported now, but it is limited. Excel for .NET only supports opaque copy for Open XML format.
- When saving a formatted cell using the Fill property from an .xlsx to an .xls file, an ArgumentException is thrown if the rows and columns in the .xlsx format are more than the maximum for the .xls format.
- A chart object is not saved whenever an Excel file is loaded and saved using C1Excel, irrespective of the file format(BIFF, OpenXml).
- There is no support for the Protect Structure/Windows:
- When Excel for .NET is used to load a Microsoft Excel file that is password protected for Structure/Windows: a "Central dir not found" exception or FileLoadException may occur.
- The following image shows how a workbook has been password protected for Structure and Windows in Microsoft Excel 2010.
