Grid Export: We found a problem with this formula

2 posts, 0 answers
  1. Windhoek2010
    Windhoek2010 avatar
    16 posts
    Member since:
    Jul 2014

    Posted 11 Sep 2019 Link to this post

    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?

  2. Attila Antal
    Attila Antal avatar
    520 posts

    Posted 16 Sep 2019 Link to this post

    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.
Back to Top