github-starred/libxlsxwriter

Fork 0

mirror of https://github.com/jmcnamara/libxlsxwriter.git synced 2026-05-15 14:15:54 -06:00

[GH-ISSUE #257] [Bug] Text Wrap in Outlook Preview mode #206

New issue

Closed

opened 2026-05-05 11:55:16 -06:00 by gitea-mirror · 6 comments

gitea-mirror commented

2026-05-05 11:55:16 -06:00

Owner

Originally created by @sirhvd on GitHub (Dec 20, 2019).
Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/257

Originally assigned to: @jmcnamara on GitHub.

Hi @jmcnamara.
I was using the excel files generated from libxlsxwriter library, and upload these file to Outlook mail. (https://outlook.office365.com/)

But I have a small problem when open Excel file in preview mode ( Outlook Mail ).
Text wrap not working in preview mode, but in Windows desktop, it's working fine.

To make text wrap work in preview mode, I must open the excel file then save it again.

I hope you will check it out.
Thank you
Cheers!

Originally created by @sirhvd on GitHub (Dec 20, 2019). Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/257 Originally assigned to: @jmcnamara on GitHub. Hi @jmcnamara. I was using the excel files generated from **libxlsxwriter** library, and upload these file to Outlook mail. (https://outlook.office365.com/) But I have a small problem when open Excel file in preview mode ( Outlook Mail ). Text wrap not working in preview mode, but in Windows desktop, it's working fine. To make text wrap work in preview mode, I must open the excel file then save it again. I hope you will check it out. Thank you Cheers!

gitea-mirror

2026-05-05 11:55:16 -06:00

closed this issue
added the
question

awaiting user feedback
labels

gitea-mirror commented

2026-05-05 11:55:22 -06:00

Author

Owner

@RaFaeL-NN commented on GitHub (Dec 20, 2019):

Excel saves files in text mode with \r\n. libxlsxwriter saves in binary mode. Excel can convert it "on the fly" at open, preview mode can't. See https://github.com/jmcnamara/libxlsxwriter/issues/156 . A solution can be with an option changing write mode (from binary to text).

@RaFaeL-NN commented on GitHub (Dec 20, 2019): Excel saves files in text mode with \r\n. libxlsxwriter saves in binary mode. Excel can convert it "on the fly" at open, preview mode can't. See https://github.com/jmcnamara/libxlsxwriter/issues/156 . A solution can be with an option changing write mode (from binary to text).

gitea-mirror commented

2026-05-05 11:55:25 -06:00

Author

Owner

@jmcnamara commented on GitHub (Dec 20, 2019):

@sirhvd could you add a small, complete C program that generates a file that demonstrates the issue.

Could you also, if possible add a screenshot of the preview in Outlook so that I can try replicate this.

@jmcnamara commented on GitHub (Dec 20, 2019): @sirhvd could you add a small, complete C program that generates a file that demonstrates the issue. Could you also, if possible add a screenshot of the preview in Outlook so that I can try replicate this.

gitea-mirror commented

2026-05-05 11:55:28 -06:00

Author

Owner

@sirhvd commented on GitHub (Dec 23, 2019):

@jmcnamara Sorry for the late reply. I just using your example code:

int main() {
    lxw_workbook  *workbook  = workbook_new("wrap.xlsx");
    lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);

    lxw_format *wrap_format = workbook_add_format(workbook);
    format_set_text_wrap(wrap_format);

    worksheet_write_string(worksheet, 0, 0, "Col 1", wrap_format);
    worksheet_write_string(worksheet, 0, 1, "Col 2", wrap_format);
    worksheet_write_string(worksheet, 1, 0, "First Long long long long long long text", wrap_format);
    worksheet_write_string(worksheet, 1, 1, "Second long long long long long long text", wrap_format);

    workbook_close(workbook);

    return 0;
}

I think this problem comes from text/binary mode as @RaFaeL-NN mentions.

@sirhvd commented on GitHub (Dec 23, 2019): @jmcnamara Sorry for the late reply. I just using your example code: ```C int main() { lxw_workbook *workbook = workbook_new("wrap.xlsx"); lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL); lxw_format *wrap_format = workbook_add_format(workbook); format_set_text_wrap(wrap_format); worksheet_write_string(worksheet, 0, 0, "Col 1", wrap_format); worksheet_write_string(worksheet, 0, 1, "Col 2", wrap_format); worksheet_write_string(worksheet, 1, 0, "First Long long long long long long text", wrap_format); worksheet_write_string(worksheet, 1, 1, "Second long long long long long long text", wrap_format); workbook_close(workbook); return 0; } ``` ![Capture](https://user-images.githubusercontent.com/8132142/71330918-19e9d900-2562-11ea-9321-25782f15ca8c.PNG) I think this problem comes from text/binary mode as @RaFaeL-NN mentions.

gitea-mirror commented

2026-05-05 11:55:29 -06:00

Author

Owner

@jmcnamara commented on GitHub (Dec 23, 2019):

Thanks for the sample code. I think I see what the issue may be.

When you set word wrap like this Excel resizes the row automatically when it opens the file. That probably isn't happening in the Outlook preview.

Try setting the row height explicitly and see if the result is different:

#include "xlsxwriter.h"

int main() {
    lxw_workbook  *workbook  = workbook_new("wrap.xlsx");
    lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);

    lxw_format *wrap_format = workbook_add_format(workbook);
    format_set_text_wrap(wrap_format);

    worksheet_write_string(worksheet, 0, 0, "123\n456", wrap_format);

    /* Add this line. */
    worksheet_set_row(worksheet, 0, 28, NULL);

    workbook_close(workbook);

    return 0;
}

Output in Excel:

@jmcnamara commented on GitHub (Dec 23, 2019): Thanks for the sample code. I think I see what the issue may be. When you set word wrap like this Excel resizes the row automatically when it opens the file. That probably isn't happening in the Outlook preview. Try setting the row height explicitly and see if the result is different: ```C #include "xlsxwriter.h" int main() { lxw_workbook *workbook = workbook_new("wrap.xlsx"); lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL); lxw_format *wrap_format = workbook_add_format(workbook); format_set_text_wrap(wrap_format); worksheet_write_string(worksheet, 0, 0, "123\n456", wrap_format); /* Add this line. */ worksheet_set_row(worksheet, 0, 28, NULL); workbook_close(workbook); return 0; } ``` Output in Excel: ![screenshot](https://user-images.githubusercontent.com/94267/71331048-39641000-2528-11ea-8c72-0414f6493a70.png)

gitea-mirror commented

2026-05-05 11:55:31 -06:00

Author

Owner

@sirhvd commented on GitHub (Dec 23, 2019):

Thank for your reply.
Set row height will work. But only for static text.
Is there any way to make text wrap work as Excel does?

@sirhvd commented on GitHub (Dec 23, 2019): Thank for your reply. Set row height will work. But only for static text. Is there any way to make text wrap work as Excel does?

gitea-mirror commented

2026-05-05 11:55:33 -06:00

Author

Owner

@jmcnamara commented on GitHub (Dec 23, 2019):

Is there any way to make text wrap work as Excel does?

No. This is a calculation that Excel does at run time. It isn't part of the file format so it cannot be controlled from Libxlsxwriter.

The user either has to set the row height explicitly or allow Excel to do it at run time with possible unforeseen actions (like in your case).

Set row height will work. But only for static text.

In that case I will close this issue since we now know why Outlook Preview behaves differently to Excel in this case.

@jmcnamara commented on GitHub (Dec 23, 2019): > Is there any way to make text wrap work as Excel does? No. This is a calculation that Excel does at run time. It isn't part of the file format so it cannot be controlled from Libxlsxwriter. The user either has to set the row height explicitly or allow Excel to do it at run time with possible unforeseen actions (like in your case). > Set row height will work. But only for static text. In that case I will close this issue since we now know why Outlook Preview behaves differently to Excel in this case.

gitea-mirror referenced this issue

2026-05-05 12:15:51 -06:00

[PR #206] [MERGED] Make py.test name configurable #436