#5 XLS Emitter merging rows when cell width too small

[Danilo]

Suppose you have a report with 3 columns. When generating the report, one of the columns have some data that is bigger than the column width.

Instead of increasing the entire row height, the XLS emitter is making the data occupy two rows and merges the two rows. The other columns of the same rows are not merged so the resulting sheet is difficult to work on.

Attached is a small XLS file generated by the emitter that shows this problem on rows 6 and 7.

[Danilo]

File showing merged rows problem