something changed for export to xlsx?

(5 posts) (2 voices)


No tags yet.

  1. ziuras, Member

    Today I updated to 5.7.5 (build 4062) old was 5.7.4 maybe.

    Report export in xlsx format
    now there are not "select 'dbr.title', 'aaaa'" in first row.
    befor update i have title in first row and first column: (in xlsx file)
    Client: 123456 — Name Surname
    A B C
    abc abc 10
    acb acb 11
    select 'dbr.title', 'Client:' + @inKs
    select A, B, C from ...

    now I have only:
    A B C
    abc abc 10
    acb acb 11
    how to add title in first row?

  2. myDBR Team, Key Master

    just run the automatic updater and the title will be back.

    myDBR Team

  3. ziuras, Member

    now we get one extra emty line
    1 line: Client: 123456 — Name Surname
    2 line: emty
    3 line: A B C
    if you can, remove 2 empty line


  4. myDBR Team, Key Master

    The title is, by default, separated from the first result set with one empty line. There is no empty lines between subtitles and the result set.

    if you run the updater again, you can use setting in user/defaults.php:

    $mydbr_defaults['export']['excel']['lines_after_title'] = 0;

    This will remove the line between the title and the first result set.

    myDBR Team

  5. ziuras, Member

    thanks, its working.


You must log in to post.