This is a migrated thread and some comments may be shown as answers.

Grid Export: We found a problem with this formula

1 Answer 446 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Windhoek2010
Top achievements
Rank 1
Windhoek2010 asked on 11 Sep 2019, 08:39 AM

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

Sort by
0
Attila Antal
Telerik team
answered on 16 Sep 2019, 07:16 AM

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

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Tags
Grid
Asked by
Windhoek2010
Top achievements
Rank 1
Answers by
Attila Antal
Telerik team
Share this question
or