[GH-ISSUE #182] Question: Change row/column width without changing format #150

New issue

Closed

opened 2026-05-05 11:47:20 -06:00 by gitea-mirror · 3 comments

gitea-mirror commented

2026-05-05 11:47:20 -06:00

Owner

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

The functions worksheet_set_row and worksheet_set_column allow to change the width and height of the rows/columns.

But they always come with a lxw_format parameter.

The doc is not clear - passing NULL as lxw_format changes the formatting on all rows/columns to default ?
Or does it leave the formatting info as is ?

If the former applies - how to change the row/column size, but let the formatting info unchanged ?

Originally created by @petricf on GitHub (May 23, 2018). Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/182 The functions worksheet_set_row and worksheet_set_column allow to change the width and height of the rows/columns. But they always come with a lxw_format parameter. The doc is not clear - passing NULL as lxw_format changes the formatting on all rows/columns to default ? Or does it leave the formatting info as is ? If the former applies - how to change the row/column size, but let the formatting info unchanged ?

gitea-mirror closed this issue

2026-05-05 11:47:24 -06:00

gitea-mirror commented

2026-05-05 11:47:27 -06:00

Author

Owner

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

A cell format will override a column or row format.

@jmcnamara commented on GitHub (May 23, 2018): A cell format will override a column or row format.

gitea-mirror commented

2026-05-05 11:47:30 -06:00

Author

Owner

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

But if the worksheet_set_row call comes AFTER a worksheet_write_* - which format parameter takes precedence ?

@petricf commented on GitHub (May 23, 2018): But if the worksheet_set_row call comes AFTER a worksheet_write_* - which format parameter takes precedence ?

gitea-mirror commented

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

Author

Owner

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

The order doesn’t matter the cell format still takes preference. This is Excel’s rule which is something like Cell > Row > Column.

Excel, the application, creates new formats at the intersection of Cell/Row/Column formats but that isn’t an automatic feature of the file format so libsxwriter users need to create and apply the intersection formats if required.

@jmcnamara commented on GitHub (May 24, 2018): The order doesn’t matter the cell format still takes preference. This is Excel’s rule which is something like Cell > Row > Column. Excel, the application, creates new formats at the intersection of Cell/Row/Column formats but that isn’t an automatic feature of the file format so libsxwriter users need to create and apply the intersection formats if required.