[GH-ISSUE #279] How to get the default format? #225

New issue

Closed

opened 2026-05-05 11:59:01 -06:00 by gitea-mirror · 3 comments

gitea-mirror commented

2026-05-05 11:59:01 -06:00

Owner

Originally created by @znakeeye on GitHub (Mar 30, 2020).
Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/279

Originally assigned to: @jmcnamara on GitHub.

In workbook.c you add a default format:

/* Add the default cell format. */
    format = workbook_add_format(workbook);
    GOTO_LABEL_ON_MEM_ERROR(format, mem_error);

How do you retrieve that format? E.g. I would like to change the default font for all cells, so I expected something like this:

format = workbook_get_default_format(workbook);

But no such API. Ideas?

Originally created by @znakeeye on GitHub (Mar 30, 2020). Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/279 Originally assigned to: @jmcnamara on GitHub. In `workbook.c` you add a default format: ```c /* Add the default cell format. */ format = workbook_add_format(workbook); GOTO_LABEL_ON_MEM_ERROR(format, mem_error); ``` How do you retrieve that format? E.g. I would like to change the default font for all cells, so I expected something like this: ```c format = workbook_get_default_format(workbook); ``` But no such API. Ideas?

gitea-mirror

2026-05-05 11:59:01 -06:00

closed this issue
added the
wontfix

question
labels

gitea-mirror commented

2026-05-05 11:59:11 -06:00

Author

Owner

@jmcnamara commented on GitHub (Mar 30, 2020):

That font isn't exposed, deliberately, since changing it generally affects size calculations used for image insertion and other cell measurements.

If you really want to access it anyway, then you can do so via the workbook->formats linked list. However, things may break and I don't recommend it.

@jmcnamara commented on GitHub (Mar 30, 2020): That font isn't exposed, deliberately, since changing it generally affects size calculations used for image insertion and other cell measurements. If you really want to access it anyway, then you can do so via the `workbook->formats` linked list. However, things may break and I don't recommend it.

gitea-mirror commented

2026-05-05 11:59:14 -06:00

Author

Owner

@znakeeye commented on GitHub (Mar 30, 2020):

Thanks for clarification! Then I'm probably better off adding a custom format and provide that instance when writing cell values.

@znakeeye commented on GitHub (Mar 30, 2020): Thanks for clarification! Then I'm probably better off adding a custom format and provide that instance when writing cell values.

gitea-mirror commented

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

Author

Owner

@jmcnamara commented on GitHub (Mar 30, 2020):

Then I'm probably better off adding a custom format and provide that instance when writing cell values.

Yes. That is safer.

@jmcnamara commented on GitHub (Mar 30, 2020): > Then I'm probably better off adding a custom format and provide that instance when writing cell values. Yes. That is safer.