something changed for export to xlsx?

(5 posts) (2 voices)

Tags:

No tags yet.

  1. ziuras, Member

    Hi
    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

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

    --
    myDBR Team

  3. ziuras, Member

    hi,
    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

    Thanks

  4. myDBR Team, Key Master

    Hi,
    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.


Reply

You must log in to post.