text_wrap format is ignored?..

[croshchupkin]

I am using xlsxwriter 0.5.1 and python 2.7.3.
In a method that returns data for the HTTP response, I did the following:

    out = StringIO.StringIO()
    workbook = xlsxwriter.workbook.Workbook(out)
    worksheet = workbook.add_worksheet()

    header_format = workbook.add_format({'text_wrap': 1, 'valign': 'top'})
    worksheet.write('A1', u'Кол-во Рекламоносителей', header_format)

    # self._write_header(workbook, worksheet)
    # self._write_body(*args)
    # self._write_footer(worksheet)

    workbook.close()
    out.seek(0)
    return out

I also attempted changing

    header_format = workbook.add_format({'text_wrap': 1, 'valign': 'top'})

to:

    header_format.set_text_wrap()
    header_format.set_valign('top')

Unfortunately, all I got was:

As far as I undertood the docs, the row height should have been auto-adjusted, or am I missing something?

[jmcnamara]

As far as I undertood the docs, the row height should have been auto-adjusted, or am I missing something?

The docs say that Excel adjusts the height of the row:

Excel will adjust the height of the row to accommodate the wrapped text. A similar effect can be obtained without newlines using the set_align('vjustify') method.

For example:

import xlsxwriter

workbook = xlsxwriter.workbook.Workbook('wrap.xlsx')
worksheet = workbook.add_worksheet()

header_format = workbook.add_format({'text_wrap': 1, 'valign': 'top'})
worksheet.write('A1', u'Some long text here', header_format)

workbook.close()

However, there is no guarantee that LibreOffice or any other spreadsheet application will do this and there is nothing in the file format that XlsxWriter can control to automatically adjust the row height.

In cases like this I always recommend that the row height is set explicitly so that there are no surprises like this.

[croshchupkin]

I already set it to an explicit value :)
I just had some doubts because my co-worker has a mobile version of Excel,
and it looked the same over there. Probably a defect of the mobile version.

On Wed, Dec 18, 2013 at 3:30 PM, John McNamara notifications@github.comwrote:

As far as I undertood the docs, the row height should have been
auto-adjusted, or am I missing something?

The docshttp://xlsxwriter.readthedocs.org/en/latest/format.html?#format-set-text-wrapsay that
Excel adjusts the height of the row:

Excel will adjust the height of the row to accommodate the wrapped text.
A similar effect can be obtained without newlines using the
set_align('vjustify') method.

For example:

import xlsxwriter
workbook = xlsxwriter.workbook.Workbook('wrap.xlsx')worksheet = workbook.add_worksheet()
header_format = workbook.add_format({'text_wrap': 1, 'valign': 'top'})worksheet.write('A1', u'Some long text here', header_format)
workbook.close()

[image: wrap]https://f.cloud.github.com/assets/94267/1773456/fea1f81e-67e7-11e3-8b97-20d703681e55.png

However, there is no guarantee that LibreOffice or any other spreadsheet
application will do this and there is nothing in the file format that
XlsxWriter can control to automatically adjust the row height.

In cases like this I always recommend that the row height is set
explicitly so that there are no surprises like this.

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/80#issuecomment-30841359
.

[jmcnamara]

Ok. Can we close this then?