Error exporting to Excel

[Luca B]

Hi, I am using the built-in Excel exporting feature, but sometimes I get this error

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.

Since the cells content depend on the database, I cannot be sure there are no formula-like characters in some cells.

How can I catch this exception? Or, better yet, how can I manipulate the data in order for the Excel exporting to not complain?

Thanks

Luca

[Luca B]

Anyone?

It looks somehow related to having a negative total in the grid footer.

How can I tell the exporter to just treat the value as text?

Thanks

[Pavlina]

Hello,

Try setting text format to the cell in order to stop recognizing it as a formula. Please check out the following code library which demonstrates how to apply format. 

cell.Format = "@";

Regards,
Pavlina
Telerik by Progress