Keep Header Rows Empty in Excel

Andrew Bereszczak-Adams
Andrew Bereszczak-Adams Customer
Second Anniversary First Comment
in Platform

Hi Boarders!

 

When I export a table to Excel, Board adds 0's into the empty header rows. In the example attached, "EXPENSES", "Workforce" and "Senior Medical Officers (SMO's)" are empty header rows in the Board data view but they contain 0 in the downloaded Excel sheet.

 

Can I quickly download to an Excel spreadsheet but have empty rows for "EXPENSES", "Workforce" and "Senior Medical Officers (SMO's)"?

 

Any help would be greatly appreciated.

 

Cheers

Andrew

Answers

  • Alexander Kappes
    Alexander Kappes Employee
    Fourth Anniversary 250 Likes 100 Comments 5 Answers
    edited March 2020

    Dear Andrew Bereszczak-Adams,

     

    thanks for your request.

     

    Unfortunately I´m not able to reproduce your behavior

     

    image

     

    I think its due to your dataview settings. You are using Entity Template plus Custom Block Formatings?

     

    Best suggestion will be copying your layout in win client and reconfiguring it, due to the position where the zeros are visible by exporting.

     

    Hope it helps

     

    regards


    Alexander Kappes

  • Andrew Bereszczak-Adams
    Andrew Bereszczak-Adams Customer
    Second Anniversary First Comment

    Thanks Alexander, I will follow this up.

Categories