Return
-
Title
Remove blank column and row in a report exported to xlsx format -
Description
Remove blank column and row in a report exported to xlsx format -
Resolution
WORKAROUND
On the edit report option:
- Go to the Layout tab
- Press in the Auto-generate option and follow the wizard.
- On the wizard select Standard Report.
- Select the fields that you want to display in the report.
- Set the group order if required.
- Select Tabular layout and uncheck the adjust the field width option.
- Select the compact style.
- Set the title of the report.
when exporting the report to xlsx format be sure that the option export raw data is checked.