Error exporting to Excel

3 posts, 0 answers
  1. Luca B
    Luca B avatar
    41 posts
    Member since:
    Oct 2012

    Posted 23 Jan 2017 Link to this post

    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

  2. Luca B
    Luca B avatar
    41 posts
    Member since:
    Oct 2012

    Posted 25 Jan 2017 in reply to Luca B Link to this post

    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

  3. Pavlina
    Admin
    Pavlina avatar
    6187 posts

    Posted 26 Jan 2017 Link to this post

    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
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top