Advance Layouts For Merged Cells

Report Writer supports additional export layouts in Word and Excel export formats to eliminate the tiny columns, rows, and merged cells. The benefits of the layout are:

• Overcomes the merging problem with tiny cells, rows, and columns in SSRS Excel and Word exporting.
• Provides clear readability by eliminating the tiny columns, rows, and merge cells.
• Allows you to perform data manipulations such as applying sorting, filters, and grouping in Excel.

Word document advance layout for merged cells

Eliminate the tiny columns, rows, merged cells, and render the word document elements without nested grid layout by setting the LayoutOption to TopLevel. The ParagraphSpacing is the distance value added between two elements in the document.

writer.WordOptions.LayoutOption = WordLayoutOptions.TopLevel;
writer.WordOptions.ParagraphSpacing = new BoldReports.Writer.ParagraphSpacing()
{
    Bottom = 0.5f,
    Top = 0.5f
};

A paragraph element is inserted between two tables in the exported document to overcome word document auto merging behavior. The table in the word document is not a stand-alone object. If you draw two tables one after another, it will automatically get merged into a single table. To prevent this merging, add an empty paragraph between two tables.

Excel document advance layout for merged cells

Eliminate the tiny columns, rows, and merged cells to provide clear readability and perform data manipulations by setting the LayoutOption as IgnoreCellMerge.

writer.ExcelOptions = new BoldReports.Writer.ExcelOptions()
{
    LayoutOption = BoldReports.Writer.ExcelLayoutOptions.IgnoreCellMerge
};