AUTHOR: Marin Bratanov
DATE POSTED: June 21, 2018
When exporting RadGrid to Excel (XLSX format), I get the following exception
This can happen when special symbols/structures are present in the data that resemble Excel formulas, but are not. The exporting engine attempts to parse formulas and if it fails, such an exception is thrown.
Such symbols commonly include the equals sign (=) followed by brackets; the minus sign (-) or a plus sign (+). Depending on the content, an error may or may not be thrown.
There are a few solutions:
Below you can find attached examples that showcase how you can traverse the cells and columns before the actual export happens so you can apply changes to the format or cell value.