Commits

Luke Plant committed 252a49c

Added approx row height setting for spreadsheets

Comments (0)

Files changed (1)

     date_style.num_format_str = 'YYYY/MM/DD'
 
     for r, row in enumerate(contents):
+        row_height = normal_style.font.height
         for c, val in enumerate(row):
             if isinstance(val, str):
                 # normalise newlines to style expected by Excel
                     # This is needed or Excel displays box character for
                     # newlines.
                     style = wrapped_style
+                    # Set height to be able to see all lines
+                    row_height = max(row_height, normal_style.font.height * (val.count('\n') + 1))
             wksh.write(r + 1, c, val, style=style)
-
+        wksh.rows[r + 1].height = row_height + 100 # fudge for margin, based on OpenOffice
 
 def workbook_to_string(wkbk):
     s = StringIO()