github-starred/libxlsxwriter

Fork 0

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

[GH-ISSUE #468] format_set_font_name does not work for Persian font. #365

New issue

Closed

opened 2026-05-05 12:12:20 -06:00 by gitea-mirror · 14 comments

gitea-mirror commented

2026-05-05 12:12:20 -06:00

Owner

Originally created by @mehranj73 on GitHub (Feb 4, 2025).
Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/468

Originally assigned to: @jmcnamara on GitHub.

My problem also happend in Rust lang and setting font_charset to 178 and font_family to 0 fix my problem. I don't know how to do the same thing in your library. I'm using "B Nazanin" and "B titr" fonts.
https://github.com/jmcnamara/rust_xlsxwriter/issues/125

Originally created by @mehranj73 on GitHub (Feb 4, 2025). Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/468 Originally assigned to: @jmcnamara on GitHub. My problem also happend in Rust lang and setting font_charset to 178 and font_family to 0 fix my problem. I don't know how to do the same thing in your library. I'm using "B Nazanin" and "B titr" fonts. https://github.com/jmcnamara/rust_xlsxwriter/issues/125

gitea-mirror

2026-05-05 12:12:20 -06:00

closed this issue
added the
question
label

gitea-mirror commented

2026-05-05 12:12:24 -06:00

Author

Owner

@jmcnamara commented on GitHub (Feb 4, 2025):

The APIs you need are

void format_set_font_family(lxw_format *format, uint8_t value);
void format_set_font_charset(lxw_format *format, uint8_t value);

They are public, just not documented because they are rarely required.

@jmcnamara commented on GitHub (Feb 4, 2025): The APIs you need are ```C void format_set_font_family(lxw_format *format, uint8_t value); void format_set_font_charset(lxw_format *format, uint8_t value); ``` They are public, just not documented because they are rarely required.

gitea-mirror commented

2026-05-05 12:12:27 -06:00

Author

Owner

@mehranj73 commented on GitHub (Feb 4, 2025):

Thanks for replying. I actually tried these two methods and didn't work. I also open the excel file as a zip file and didn't see the changes to charset and font family.

@mehranj73 commented on GitHub (Feb 4, 2025): Thanks for replying. I actually tried these two methods and didn't work. I also open the excel file as a zip file and didn't see the changes to charset and font family.

gitea-mirror commented

2026-05-05 12:12:28 -06:00

Author

Owner

@jmcnamara commented on GitHub (Feb 4, 2025):

My bad. I hadn't added the code to use font_charset. I've pushed it to main so you can try it.

Here is an example:

#include "xlsxwriter.h"

int main()
{

    lxw_workbook *workbook = workbook_new("gh468.xlsx");
    lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);

    /* Set the cell size for clarity. */
    worksheet_set_column(worksheet, 0, 0, 60, NULL);
    worksheet_set_row(worksheet, 0, 100, NULL);

    /* Add a format with a font that supports Persian. */
    lxw_format *format = workbook_add_format(workbook);

    format_set_font_name(format, "B Titr");
    format_set_font_size(format, 72);
    format_set_font_charset(format, 178);
    format_set_font_family(format, 0);
    format_set_bold(format);
    format_set_align(format, LXW_ALIGN_CENTER);
    format_set_align(format, LXW_ALIGN_VERTICAL_CENTER);

    /* Write a test string. */
    worksheet_write_string(worksheet, 0, 0, "سلام 100000", format);

    workbook_close(workbook);

    return 0;
}

Output:

Does that look correct?

@jmcnamara commented on GitHub (Feb 4, 2025): My bad. I hadn't added the code to use `font_charset`. I've pushed it to main so you can try it. Here is an example: ```C #include "xlsxwriter.h" int main() { lxw_workbook *workbook = workbook_new("gh468.xlsx"); lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL); /* Set the cell size for clarity. */ worksheet_set_column(worksheet, 0, 0, 60, NULL); worksheet_set_row(worksheet, 0, 100, NULL); /* Add a format with a font that supports Persian. */ lxw_format *format = workbook_add_format(workbook); format_set_font_name(format, "B Titr"); format_set_font_size(format, 72); format_set_font_charset(format, 178); format_set_font_family(format, 0); format_set_bold(format); format_set_align(format, LXW_ALIGN_CENTER); format_set_align(format, LXW_ALIGN_VERTICAL_CENTER); /* Write a test string. */ worksheet_write_string(worksheet, 0, 0, "سلام 100000", format); workbook_close(workbook); return 0; } ``` Output: ![Image](https://github.com/user-attachments/assets/4b2e06f5-7e87-408e-9f52-2feb364947ac) Does that look correct?

gitea-mirror commented

2026-05-05 12:12:30 -06:00

Author

Owner

@mehranj73 commented on GitHub (Feb 4, 2025):

I'm a newbie. Would it work if I download the library using vcpkg ?

@mehranj73 commented on GitHub (Feb 4, 2025): I'm a newbie. Would it work if I download the library using vcpkg ?

gitea-mirror commented

2026-05-05 12:12:32 -06:00

Author

Owner

@jmcnamara commented on GitHub (Feb 4, 2025):

I can wrap it up into a vcpkg but it will take a few days.

@jmcnamara commented on GitHub (Feb 4, 2025): I can wrap it up into a vcpkg but it will take a few days.

gitea-mirror commented

2026-05-05 12:12:34 -06:00

Author

Owner

@mehranj73 commented on GitHub (Feb 9, 2025):

Is version 1.1.9 has the new changes in vcpkg?

@mehranj73 commented on GitHub (Feb 9, 2025): Is version 1.1.9 has the new changes in vcpkg?

gitea-mirror commented

2026-05-05 12:12:35 -06:00

Author

Owner

@jmcnamara commented on GitHub (Feb 9, 2025):

No. Not yet.

@jmcnamara commented on GitHub (Feb 9, 2025): No. Not yet.

gitea-mirror commented

2026-05-05 12:12:36 -06:00

Author

Owner

@mehranj73 commented on GitHub (Feb 10, 2025):

I have been trying "Using CMake for Microsoft Visual Studio" in this tutorial for a week and I always get "No package 'zlib' found" error.

@mehranj73 commented on GitHub (Feb 10, 2025): I have been trying "**Using CMake for Microsoft Visual Studio**" in this [tutorial](https://libxlsxwriter.github.io/getting_started.html) for a week and I always get "`No package 'zlib' found`" error.

gitea-mirror commented

2026-05-05 12:12:37 -06:00

Author

Owner

@jmcnamara commented on GitHub (Feb 11, 2025):

I have submitted a request to include the updated version, v1.2.0, in vcpkg: https://github.com/microsoft/vcpkg/pull/43758

@jmcnamara commented on GitHub (Feb 11, 2025): I have submitted a request to include the updated version, v1.2.0, in vcpkg: https://github.com/microsoft/vcpkg/pull/43758

gitea-mirror commented

2026-05-05 12:12:38 -06:00

Author

Owner

@jmcnamara commented on GitHub (Feb 11, 2025):

These changes are now upstream in vcpkg libxlsxwriter package version 1.2.0.

Could you test that and let me know if is fixed. Thanks.

@jmcnamara commented on GitHub (Feb 11, 2025): These changes are now upstream in vcpkg libxlsxwriter package version 1.2.0. Could you test that and let me know if is fixed. Thanks.

gitea-mirror commented

2026-05-05 12:12:40 -06:00

Author

Owner

@mehranj73 commented on GitHub (Feb 11, 2025):

The last version still is 1.1.9 in vcpkg.

@mehranj73 commented on GitHub (Feb 11, 2025): The last version still is 1.1.9 in [vcpkg]( https://vcpkg.io/en/package/libxlsxwriter).

gitea-mirror commented

2026-05-05 12:12:41 -06:00

Author

Owner

@jmcnamara commented on GitHub (Feb 11, 2025):

I don't know how long it takes to become available. The upgrade patch was merged upstream yesterday.

@jmcnamara commented on GitHub (Feb 11, 2025): I don't know how long it takes to become available. The upgrade patch was merged upstream yesterday.

gitea-mirror commented

2026-05-05 12:12:42 -06:00

Author

Owner

@jmcnamara commented on GitHub (Feb 13, 2025):

The last version still is 1.1.9 in vcpkg.

I don't know when/how that gets updated but if you clone and run vcpkg from GitHub you can install v1.2.0.

@jmcnamara commented on GitHub (Feb 13, 2025): > The last version still is 1.1.9 in [vcpkg](https://vcpkg.io/en/package/libxlsxwriter). I don't know when/how that gets updated but if you clone and run vcpkg from GitHub you can install v1.2.0.

gitea-mirror commented

2026-05-05 12:12:44 -06:00

Author

Owner

@mehranj73 commented on GitHub (Feb 13, 2025):

Works fine. I tested it with two different fonts. C++ is really hard. I love how Rust's, Python's and Java's package managers are simpler. Thanks, You can close the issue if you want.

@mehranj73 commented on GitHub (Feb 13, 2025): Works fine. I tested it with two different fonts. C++ is really hard. I love how Rust's, Python's and Java's package managers are simpler. Thanks, You can close the issue if you want.