Excel export row height problem

[2004 IR Help]

By: rerd - rerd

Excel export row height problem

2005-03-28 07:56

When I export a report to Excel that has a stretchable textfield where the text has one or more newline characters to delineate lines, the height of the resulting row in Excel that contains the textfield data seems to always be the exact height of the number of lines -1. The last line is present in the spreadsheet, but it isn't visible unless you adjust the height of the row. This happens with 3 different textfields with varying numbers of lines. The report looks great in the viewer, as a PDF, and as HTML. The Excel export, however, is consistently setting the height of the row to exactly exclude the last line. Note that the last line does not include a newline. If it does, the Excel export works fine but the other formats have unwanted empty lines.