Skip to main content
Hitachi Vantara Lumada and Pentaho Documentation

Columns Unexpectedly Merge When Exporting to Excel

If you export content from Report Designer to Excel, and end up with unexpectedly merged columns in the output, there is probably a horizontal alignment problem with your column header or footer labels. If a label spans two columns -- even by a tiny amount -- then the Reporting engine will force the two columns to merge in the output.

Check your horizontal elements for column overlap. If you need more information on this topic, refer to the section Aligning Elements.