• Resolved MaxiAssur

    (@guerineaubruno)


    Gravity Forms Entries in Excel: Whoops, unfortunately something is broken.

    Error message: Invalid numeric value for datatype Numeric

    If you need support for this, please contact me via the support forum on the wordpress plugin.

    Check if someone else had the same error, before posting a new support question.
    And when opening a new question, please use the error message as the title, and:

    Include the following details in your message:

    Plugin Version: 1.8.1
    Gravity Forms Version: 2.4.20
    PHP Version: 7.4.9
    Wordpress Version: 5.5
    Error message: Invalid numeric value for datatype Numeric
    Error stack trace:

    #0 /home/clients/c364247accd8405c69db4cdacbe8ecc7/web/wp-content/plugins/gf-entries-in-excel/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Worksheet.php(1176): PhpOffice\PhpSpreadsheet\Cell\Cell->setValueExplicit(”, ‘n’)
    #1 /home/clients/c364247accd8405c69db4cdacbe8ecc7/web/wp-content/plugins/gf-entries-in-excel/src/Renderer/AbstractPHPExcelRenderer.php(167): PhpOffice\PhpSpreadsheet\Worksheet\Worksheet->setCellValueExplicitByColumnAndRow(14, 2, ”, ‘n’)
    #2 /home/clients/c364247accd8405c69db4cdacbe8ecc7/web/wp-content/plugins/gf-entries-in-excel/src/Renderer/PHPExcelRenderer.php(39): GFExcel\Renderer\AbstractPHPExcelRenderer->addCellsToWorksheet(Object(PhpOffice\PhpSpreadsheet\Worksheet\Worksheet), Array, 12)
    #3 /home/clients/c364247accd8405c69db4cdacbe8ecc7/web/wp-content/plugins/gf-entries-in-excel/src/GFExcelOutput.php(116): GFExcel\Renderer\PHPExcelRenderer->handle(Array, Array, Array, false)
    #4 /home/clients/c364247accd8405c69db4cdacbe8ecc7/web/wp-content/plugins/gf-entries-in-excel/src/GFExcel.php(303): GFExcel\GFExcelOutput->render()
    #5 /home/clients/c364247accd8405c69db4cdacbe8ecc7/web/wp-includes/class-wp-hook.php(287): GFExcel\GFExcel->downloadFile(Object(WP))
    #6 /home/clients/c364247accd8405c69db4cdacbe8ecc7/web/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters(NULL, Array)
    #7 /home/clients/c364247accd8405c69db4cdacbe8ecc7/web/wp-includes/plugin.php(544): WP_Hook->do_action(Array)
    #8 /home/clients/c364247accd8405c69db4cdacbe8ecc7/web/wp-includes/class-wp.php(388): do_action_ref_array(‘parse_request’, Array)
    #9 /home/clients/c364247accd8405c69db4cdacbe8ecc7/web/wp-includes/class-wp.php(745): WP->parse_request(”)
    #10 /home/clients/c364247accd8405c69db4cdacbe8ecc7/web/wp-includes/functions.php(1285): WP->main(”)
    #11 /home/clients/c364247accd8405c69db4cdacbe8ecc7/web/wp-blog-header.php(16): wp()
    #12 /home/clients/c364247accd8405c69db4cdacbe8ecc7/web/index.php(17): require(‘/home/clients/c…’)
    #13 {main}

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author Doeke Norg

    (@doekenorg)

    Hi @guerineaubruno,

    Sorry about that. This was the exact reason for 1.8.1 so not sure why this would happen now. Will look at it asap. For now please revert to 1.7. You can download that in the develop tab on the plugin page of wordpress.

    Also for your privacys sake, you don’t have to share the download url. As it is public you are sharing it with the world.

    Thread Starter MaxiAssur

    (@guerineaubruno)

    Yes It’s work with 1.7
    Please let me know when you fix it for 1.8

    Plugin Author Doeke Norg

    (@doekenorg)

    @guerineaubruno will do. Will probably be at the end of the day.

    Experiencing same, just so you know you are not alone. (Temporarily reverting.)

    Plugin Author Doeke Norg

    (@doekenorg)

    @websherpa thanks for letting us know! I think the problem is introduced by the new version of the phpspreadsheet library. Since they are following semver they shouldn’t introduce breaking changes. ??

    I’m at my job now, but later tonight (gmt+1 over here) I’ll patch this issue.

    (For others: Old versions in Development: Advanced View Tab)

    Plugin Author Doeke Norg

    (@doekenorg)

    @websherpa @guerineaubruno Allright, it should be fixed in 1.8.2.

    It’s like I said, in a minor update they added this exact exception. So I’ve updated the NumericValue accordingly. Sorry for this. Shouldn’t have happend from their side. But shit happens.

    Please let me know if this helps!

    Thread Starter MaxiAssur

    (@guerineaubruno)

    It works for me now.
    Thank you for you precious help
    Have a nice day and thank you again

    Plugin Author Doeke Norg

    (@doekenorg)

    Good to hear. Enjoy!

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Bugs’ is closed to new replies.