[PR #68] [CLOSED] [PROPOSAL] ability to specify cell's format without changing cell's content #408

New issue

Closed

opened 2026-05-05 12:15:06 -06:00 by gitea-mirror · 0 comments

gitea-mirror commented

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

Owner

📋 Pull Request Information

Original PR: https://github.com/jmcnamara/libxlsxwriter/pull/68
Author: @lemmel
Created: 7/19/2016
Status: ❌ Closed

Base: master ← Head: master

📝 Commits (1)

68782f6 [PROPOSAL] added the ability to specify cells format without changing cells value.

📊 Changes

2 files changed (+155 additions, -3 deletions)

View changed files

📝 include/xlsxwriter/worksheet.h (+47 -0)
📝 src/worksheet.c (+108 -3)

📄 Description

Hi.

I have the need to play with borders and it is easier for me to set the data and the cells format at different time.

So as I found this in the FAQ:

Q. Can I apply a format to a range of cells in one go?

I told myself: why not contribute to that library that is usefull for you (and you seemed a little tired as I readed it through some of your messages).

This is not a real proposal for a pull as:

I loosely checked your coding style
I didn't add any test
I didn't perform real test (but the code is fully fonctionnal in my use cases)
I have some doubt (please take a look at src/worksheet.c comments)

I just want a small code review, advices, and validation of the way to do it.

Commit message:
[PROPOSAL] added the ability to specify cells format without changing cells value.

I used a "phantom" cell type (NULL_CELL), and altered _insert_cell_list and _insert_cell.
There is still question about how clean a cell (c.f. /*Waiting comment ).

Two public functions are now available:

worksheet_write_format that allows to change format of one cell
worksheet_write_range_format that allows to change format of a range of cells

_{🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.}

## 📋 Pull Request Information **Original PR:** https://github.com/jmcnamara/libxlsxwriter/pull/68 **Author:** [@lemmel](https://github.com/lemmel) **Created:** 7/19/2016 **Status:** ❌ Closed **Base:** `master` ← **Head:** `master` --- ### 📝 Commits (1) - [`68782f6`](https://github.com/jmcnamara/libxlsxwriter/commit/68782f66a3936f26d3dbcf2f61083cd8b0ac4f01) [PROPOSAL] added the ability to specify cells format without changing cells value. ### 📊 Changes **2 files changed** (+155 additions, -3 deletions) <details> <summary>View changed files</summary> 📝 `include/xlsxwriter/worksheet.h` (+47 -0) 📝 `src/worksheet.c` (+108 -3) </details> ### 📄 Description Hi. I have the need to play with borders and it is easier for me to set the data and the cells format at different time. So as I found this in the FAQ: > Q. Can I apply a format to a range of cells in one go? I told myself: why not contribute to that library that is usefull for you (and you seemed a little tired as I readed it through some of your messages). This is not a real proposal for a pull as: - I loosely checked your coding style - I didn't add any test - I didn't perform real test (but the code is fully fonctionnal in my use cases) - I have some doubt (please take a look at src/worksheet.c comments) I just want a small code review, advices, and validation of the way to do it. Commit message: [PROPOSAL] added the ability to specify cells format without changing cells value. I used a "phantom" cell type (NULL_CELL), and altered _insert_cell_list and _insert_cell. There is still question about how clean a cell (c.f. /*Waiting comment ). Two public functions are now available: - worksheet_write_format that allows to change format of one cell - worksheet_write_range_format that allows to change format of a range of cells --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>