Doeke Norg

Hi @charlesgodwin,

I’m sorry but unfortunately I haven’t had a chance to look into this. If your previous solution doesn’t work anymore with the latest release you can try and change if ( $is_build ) { to if ( false ) {. This will avoid the declaring of the class aliases.

I do believe this problem lies more in the other plugin, as they are not scoping the PHP spreadsheet dependency.

I can (maybe) only fix the incompatibility to our plugin, but they can fix it against every plugin. And I think that is a better solution.

Hy @erdoslaszlo,

You can remove the enclosure by adding the following snippet to your theme’s functions.php or using a snippet plugin:

add_filter( 'gfexcel_renderer_csv_enclosure', '__return_null' );

However, please be careful with this; as any other comma’s that do end up in the output will be seen as delimiters; making for weird output.

To change the delimiter you can use the gfexcel_renderer_csv_delimiter-hook. To change it to a semi-colon for example, you would need the following code:

add_filter( 'gfexcel_renderer_csv_delimiter', function() { return ';'; } );

I hope this helps you out.

Kind regards,

Doeke

@astrod00d Could you send the json export of both your forms to [email protected]? I’ll check them out and see if I can recreate the issue on my side. Thanks!

Kind regards,

Doeke

Hi @kaelxu sorry to hear that. Could you send a json export of the forms to [email protected] ? I’ll take a look if I can recreate the issue; and figure out where it comes from.

Kind regards,

Doeke

Ah! That download link is only visible if the download is activated. By default the download is deactivated for security purposes. When you visit the Gravity Export (Lite) button under Settings for that form; you should be able to activate the download there.

Hi @fernandiez,

Do you mean the xlsx and csv buttons on the entry view?

Kind regards,

Doeke

@charlesgodwin this is not advisable. By changing that parameter, gravityexport-lite is now dependent on the CBX plugin. It may also have unforseen side effects. Also, gravity export (pro) will not work this way.

I’ll try to reproduce this myself and come with a fix that will work, while keeping gravity export lite up to date.

Hi @charlesgodwin,

Sorry to hear this. Unfortunately we were forced to namespace the PHPSpreadsheet library to our own namespace; to avoid collisions with other plugins that use the same dependency. It is therefor not advised to use underlaying packages of the plugin.

In order to avoid breaking changes for customers who use the old namespaces, we create aliases for the old namespace to the new one. It is possible this is interfering with your plugin.

Could you test if removing the creation of these aliases fixes your problem? (it can be removed from the main GravityExport Lite plugin file).

If that works, please let me know; I can make these aliases optional.

We do check if the classes can be aliased; which probably means our plugin is loaded before the other one.

So, maybe you can change the order of which they are included?

In any case, if you have influence on the CBX plugin, that should probably also scope PHPSpreadsheet into their own name space. The problem that can arise, and has arisen, is that multiple versions of the same library are active. And those can conflict with each other. Therefor a custom namespace is best to avoid those collisions.

Hi @gregwidow. Yes this is possible, although not the row merging like in your example, but it will have multiple rows per entry. This is part of the GravityExport (pro) add-on.

You can find it, and more information on https://www.gravitykit.com/products/gravityexport

Black Friday has come and gone, but if you use the discount code NOTTOOLATE you can still claim that discount.

Hope this helps you out. Kind regards, Doeke

hi @dgomez Yes, this function is in the phpspreadsheet package that our plugin uses under the hood. However; the method that triggers this particular function is not used.

Do you still have this error if you disabled the plugin? If so; it is triggered elsewhere. Please let us know.

Kind regards,

Doeke
GravityKit

@ringringhello could you send the file to [email protected]? I cannot download the file from this URL, as it forces me to read it online ??

@ringringhello can you share a corrupted file with us?

Awesome! Nice work!

Could you try removing the ?> From the file? That’s no longer needed for PHP and can cause problems.

Do you have any custom hooks in the themes functions.php? Perhaps a space before the <?php open tag. Or after a ?> Close tag? Those can cause problems.

Please connect with us through [email protected] to safely share your credentials if this isn’t the case. We have a secure method to be able to login to your site. Then please mention my name and this ticket, so I can find it easily in our support system. Thank you.