Error when opening a .xlsx

  • Resolved vdemerstreize

    (@vdemerstreize)


    6 months, 1 week ago

    When I export some data using the xlsx format, the generated file can’t be opened with my client’s mac’s Numbers app (The default spreadsheet app on macos). I tried previous versions and it starts working again when using 2.1.0.

    How can I fix this so that I can use the most recent version?

    There’s no real error message besides the one from Numbers which says ““gfexcel-15-candidatures-spontanees-20240912.xlsx” can’t be opened right now. The file format is invalid.”

    Quick infos:
    PHP: 8.3
    WordPress: 6.6.2
    Gravity Forms: 2.8.17
    GravityExport: 2.3.1 (temporarly 2.1.0)

    Thank you!

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

    (@doekenorg)

    @vdemerstreize usually this happens because there is some extra output added to the excel file. A whitespace or an error message. Maybe your functions.php or a plugin has this extra output.

    Can you share a broken file with me on [email protected]?

    Thanks in advance.

    Thread Starter vdemerstreize

    (@vdemerstreize)

    Sent! Thanks, I’ll also check for that.

    Plugin Author Doeke Norg

    (@doekenorg)

    @vdemerstreize Thank you for sending the information.

    The reason the file is not working, is because the server is registering a Deprecation message. While the deprecation should be fixed; it is not advisable to have these deprecation notices active on a production website.

    To remedy this issue for now, please add the following code to either your functions.php or wp-config.php

    error_reporting(error_reporting() & ~E_DEPRECATED);

    This will keep the reporting as it, but exclude deprecation notices.

    I’ll make sure we look into the deprecation notice on our end.

    Hope this helps you out.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Error when opening a .xlsx’ is closed to new replies.