Rank 1
When exporting RadGrid to Excel (XLSX format), I get the following exception
We found a problem with this formula. Try clicking Insert Function on the Formulas tab to fix it.\n\nNot trying to type a formula? When the first character is an equal (=) or minus (-) sign, RadSpreadsheet thinks it is a formula. For example, when you type =1+1 the cell shows 2.
I have read this KB article. The error occurs because some of my grid cells has value "++".
I can't prevent users from entering this value. So I want to set the cell format to a string for the excel export so the engine does not attempt to parse a formula. How do I do that?
1 Answer, 1 is accepted
Hi Gerald,
Try to define a DataFormatString for the column, so that the value will be treated as a string/text instead of a formula. The following Forum thread is discussing this issue: Exporting grid to excel
Kind regards,
Attila Antal
Progress Telerik