Description Andre Lohrenz 2012-03-19 08:47:17 EDT

Created attachment 212848 [details]
Each line of text gets its own cell.

- Select some rows in a table and press CRTL-C to copy them to the clipboard.
- Paste them into a Microsoft Excel spread sheet.
- Cells that contain text with line breaks in them are split into one cell for each line of text. These cells belong to "sub rows" of the corresponding row for the Scout table row (see screenshot). Mostly, this is not desired. You rather want all the lines in the same cell, but with line breaks between them.

Error applies at least to Excel 2010.

Analysis: Excel gets its information from the HTML part that is created from the Scout table content when CTRL-C is pressed. Line breaks within cells are translated to "br" HTML tags, which result in the extra cells.

Proposed solution: Internet research indicates that Excel tags can be advised to process the "br" tags as normal line breaks and not create extra cells by adding a style information ("mso-data-placement:same-cell;") to the "br" tag. The attached patch adds this style definition to the "head" section of the HTML generated by the copy procedure in AbstractTable. This works for me.