[GH-ISSUE #181] Feature request: Change format of a cell after it contens have been set #147

Closed
opened 2026-05-05 11:47:08 -06:00 by gitea-mirror · 1 comment
Owner

Originally created by @petricf on GitHub (May 23, 2018).
Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/181

Originally assigned to: @jmcnamara on GitHub.

Sometimes it cam be necesary to modify a format or particular format item of a cell after it has been set by (for example) worksheet_write_string.
A reason may be also to split contents from formatting (maybe design rule) like done for html and css.

A sample workflow could be:

lxw_format * format = worksheet_get_format ("row", "column");
format->setAlign (...);
worksheet_set_format ("row", "column", format);

An other solution could be to define a lxw_cell structure that would result in this workflow:

lxw_cell * cell = worksheet_get_cell ("row", "column");
cell->format->setAlign (...);

Originally created by @petricf on GitHub (May 23, 2018). Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/181 Originally assigned to: @jmcnamara on GitHub. Sometimes it cam be necesary to modify a format or particular format item of a cell after it has been set by (for example) worksheet_write_string. A reason may be also to split contents from formatting (maybe design rule) like done for html and css. A sample workflow could be: >lxw_format * format = worksheet_get_format ("row", "column"); >format->setAlign (...); >worksheet_set_format ("row", "column", format); An other solution could be to define a lxw_cell structure that would result in this workflow: >lxw_cell * cell = worksheet_get_cell ("row", "column"); >cell->format->setAlign (...);
gitea-mirror 2026-05-05 11:47:08 -06:00
Author
Owner

@jmcnamara commented on GitHub (May 23, 2018):

Unfortunately, that isn't something that will be supported. It is a somewhat frequently requested feature in the Python and Perl versions of the library as well but it isn't implemented there either.

<!-- gh-comment-id:391399663 --> @jmcnamara commented on GitHub (May 23, 2018): Unfortunately, that isn't something that will be supported. It is a somewhat frequently requested feature in the Python and Perl versions of the library as well but it isn't implemented there either.
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: github-starred/libxlsxwriter#147
No description provided.