Keep Header Rows Empty in Excel

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

Find more posts tagged with

Accepted answers

All comments

Alexander Kappes

Dear Andrew Bereszczak-Adams,

thanks for your request.

Unfortunately I´m not able to reproduce your behavior

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

Thanks Alexander, I will follow this up.