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

    (@doekenorg)

    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.

    Thread Starter sv9t

    (@sv9t)

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

    PK is the first line. What is next doing?

    Thread Starter sv9t

    (@sv9t)

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

    Plugin Author Doeke Norg

    (@doekenorg)

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

    Thread Starter sv9t

    (@sv9t)

    @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?

    Plugin Author Doeke Norg

    (@doekenorg)

    @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.

    Thread Starter sv9t

    (@sv9t)

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

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

    Plugin Author Doeke Norg

    (@doekenorg)

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

    Plugin Author Doeke Norg

    (@doekenorg)

    @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;
    });
    Thread Starter sv9t

    (@sv9t)

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

    Plugin Author Doeke Norg

    (@doekenorg)

    @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!

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Error open xlsx after export’ is closed to new replies.