Error open xlsx after export

Try to rename the file with a .txt extension, and then edit it via a texteditor. Then try to see if there is code in there that should be. If you can see a php-error in the file, try and resolve that issue. The file should also NOT start with whitespace.

The file should start with PK (literally the first line, and first and second character). If it does not, you have and error somewhere in your theme or other plugins.

Let me know how it goes. If you can’t find out, you can send me the xlsx to [email protected]. I’ll see if I can see anything.

Tnx! I this rename file in .txt and open him.
https://ibb.co/bWMYXqr

PK is the first line. What is next doing?

@doekenorg I ask you to wait, I need time for tests. I think I understand what the problem is …

@sv9t sure thing! Please let me know if you find out!

@doekenorg The cause of the problem was found.! In Gravity Forms, in the name form must be English language. If I rename in Russian language I get an error when open .xlsx
Can you fix it?

@sv9t ahh great catch! Will definitely fix this shortly. Can you help me out and provide a silly Russian string for me to use? (So I can copy paste ?? ). Thanks. Will try to give you a temporary fix asap. After that it will be in the next release.

Russian: Эта форма для заполнения моих данных

I can send the export form from Gravity Forms on the you mail

@sv9t ah yes that would help to. Thanks. Send it to [email protected]!

@sv9t

Please add this to your functions.php for now. It is a terrible piece of code, but it helps you out for now. The problem is that cerillic is a multibyte script, so when we cut it to 30 characters, we actually split up 1 character. This code tries to find the next possible valid title by stripping off another character, and another, etc, until valid.

add_filter('gfexcel_renderer_worksheet_title', function ($title) {
    $start = 30;
    $title = substr($title, 0, $start);
    while (!mb_check_encoding($title, 'UTF-8') && $start > 0) {
        $start--;
        $title = substr($title, 0, $start);
    }
    return $title;
});

It’s work!) Thank you for support and fix!

@sv9t this is fixed as of 1.6.1. You can remove this code, and you will have a little longer title ?? Enjoy, and thanks for letting me know!