Web API Edition Limitations

In This Topic

Following are few limitations of Web API services. Some of these will be eliminated in due course as product is improved.

The client appearance changed by interaction may not be exported as image. For example, FlexPie rotation after click will not get exported.
The appearance of controls if affected by theme, in certain cases, cannot be reflected on exported images.
Data Label export does not support custom itemFormatter JS functions.
A line series may not be seen on export, when it is overlapping the gridline.

Common

PivotTable is not supported.
VBA Macro support is limited, where only opaque copy is supported for xlsx.
A chart object is not saved whenever an Excel file is loaded and saved, irrespective of the file format.
Protect Structure/Windows is not supported. For details, please refer to Excel for .NET Limitations.

Import and Export

Excel import and export having merged cells in it is unsupported in FlexGrid.
Exported colors in Excel 97-2003 format may look different.
Style import is not supported in FlexGrid.
The selected cells (with highlighted fill) will be exported.
Formats can only be imported to FlexGrid column-wide. The format of the last cell in a column will apply to cells of that whole column. This is limited by FlexGrid control.
In MVC FlexGrid, custom column headers cannot be exported if disableServerRead is false and onlyCurrentPage is set to false.
For import the collapsed state of group will be lost, and all the groups are expanded.
Images in the excel file cannot be exported or imported.
Icon set in the excel file cannot be exported or imported.

Generate Excel

On generating excel to json string, and reading it by FlexGrid, the collapsed state of group will be lost and all the groups will be expanded.
On generating excel file, having image in it, to json or xml string, the image won't be included in the generated string.

Merge Excel

On merging excel files, having image, to json or xml string, the images won't be included in the merged string.
Merging excel files with icon set in them, is unsupported.

NuGet cannot work if the Visual Studio option "save new projects on create" is unchecked. This option is unchecked by default in "Visual Basic" environment settings. Make sure to check this option if you use such settings. We strongly recommend that all users choose "Web" environment to develop.