[GH-ISSUE #32] Feature request: worksheet_conditional_formatting() #25

Closed
opened 2026-05-05 11:25:44 -06:00 by gitea-mirror · 15 comments
Owner

Originally created by @jmcnamara on GitHub (Dec 10, 2015).
Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/32

Originally assigned to: @jmcnamara on GitHub.

Add worksheet_conditional_formatting() function like the Python XlsxWriter Worksheet method conditional_formatting().
See http://xlsxwriter.readthedocs.io/working_with_conditional_formats.html

  • Difficulty: 4 (Easy 1 - 5 Hard)
  • Priority: 2 (High 1 - 5 Low)

Add +1 as a comment to vote for this feature and to get an update when it is implemented.

If you would like to make a donation to accelerate this feature you can do so via PayPal or contact me directly. Currently $0 of $800.

Originally created by @jmcnamara on GitHub (Dec 10, 2015). Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/32 Originally assigned to: @jmcnamara on GitHub. Add `worksheet_conditional_formatting()` function like the Python XlsxWriter Worksheet method `conditional_formatting()`. See http://xlsxwriter.readthedocs.io/working_with_conditional_formats.html - Difficulty: 4 (Easy 1 - 5 Hard) - Priority: 2 (High 1 - 5 Low) Add +1 as a comment to vote for this feature and to get an update when it is implemented. If you would like to make a donation to accelerate this feature you can do so via [PayPal](https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=ATE9EFWNF7PBJ) or contact me [directly](jmcnamara@cpan.org). Currently $0 of $800.
gitea-mirror 2026-05-05 11:25:44 -06:00
Author
Owner

@Diddlik commented on GitHub (Jan 24, 2017):

+1

<!-- gh-comment-id:274807719 --> @Diddlik commented on GitHub (Jan 24, 2017): +1
Author
Owner

@Diddlik commented on GitHub (Jun 26, 2017):

Hello, is it known when this feature is finished?
It is the last thing, what I'm missing in this library.
BR Pavel

<!-- gh-comment-id:311031903 --> @Diddlik commented on GitHub (Jun 26, 2017): Hello, is it known when this feature is finished? It is the last thing, what I'm missing in this library. BR Pavel
Author
Owner

@jmcnamara commented on GitHub (Jun 26, 2017):

There is no planned date for this. It is on the shorter todo list but it is also non-trivial and I don't have a lot of time at the moment.

You will get an update on this issue when there is something new.

<!-- gh-comment-id:311035103 --> @jmcnamara commented on GitHub (Jun 26, 2017): There is no planned date for this. It is on the shorter todo list but it is also non-trivial and I don't have a lot of time at the moment. You will get an update on this issue when there is something new.
Author
Owner

@patrick-rotsaert commented on GitHub (Jul 5, 2017):

+1

<!-- gh-comment-id:313028329 --> @patrick-rotsaert commented on GitHub (Jul 5, 2017): +1
Author
Owner

@thdankert commented on GitHub (Oct 13, 2017):

+1

<!-- gh-comment-id:336435161 --> @thdankert commented on GitHub (Oct 13, 2017): +1
Author
Owner

@spulchtopek commented on GitHub (Oct 13, 2017):

+1

<!-- gh-comment-id:336482416 --> @spulchtopek commented on GitHub (Oct 13, 2017): +1
Author
Owner

@jmcnamara commented on GitHub (Aug 6, 2018):

Since I've had a few requests about this I've added a note about making donations to prioritize this feature.

<!-- gh-comment-id:410818162 --> @jmcnamara commented on GitHub (Aug 6, 2018): Since I've had a few requests about this I've added a note about making donations to prioritize this feature.
Author
Owner

@Tangjiahui26 commented on GitHub (Nov 20, 2018):

Since I've had a few requests about this I've added a note about making donations to prioritize this feature.

That'd be great.
Conditional formatting is also an important feature for xlsxwriter Python module.

<!-- gh-comment-id:440135162 --> @Tangjiahui26 commented on GitHub (Nov 20, 2018): > Since I've had a few requests about this I've added a note about making donations to prioritize this feature. That'd be great. Conditional formatting is also an important feature for xlsxwriter Python module.
Author
Owner

@romul commented on GitHub (Mar 22, 2019):

+1
Is there any news on this issue?

<!-- gh-comment-id:475766742 --> @romul commented on GitHub (Mar 22, 2019): +1 Is there any news on this issue?
Author
Owner

@TricksterGuy commented on GitHub (Jul 3, 2020):

+1 on this. However...

I couldn't wait, so I forked and implemented enough of the code just to support my use case. I used the python version of this library as a guide.

If its okay with you... I would be fine with finishing the implementation, cleaning up the code, and adding unit tests for it and submitting a pull request.

If we can get an API hammered down (there appears to be a ton of different conditional format options and flavors) then I can continue.

<!-- gh-comment-id:653518295 --> @TricksterGuy commented on GitHub (Jul 3, 2020): +1 on this. However... I couldn't wait, so I forked and implemented enough of the code just to support my use case. I used the python version of this library as a guide. If its okay with you... I would be fine with finishing the implementation, cleaning up the code, and adding unit tests for it and submitting a pull request. If we can get an API hammered down (there appears to be a ton of different conditional format options and flavors) then I can continue.
Author
Owner

@jmcnamara commented on GitHub (Jul 24, 2020):

@TricksterGuy Thanks for the suggestion and sorry for not replying sooner.

I'm going to pass on collaborating on this, at this point, since I need to work on the other items on the Roadmap in order (conditional formatting is third on the current list). Also, I need to work through my process for implementing a feature in the same way that I always do. I'll ping back into this thread once I have started on it. Thanks. -- John

<!-- gh-comment-id:663479387 --> @jmcnamara commented on GitHub (Jul 24, 2020): @TricksterGuy Thanks for the suggestion and sorry for not replying sooner. I'm going to pass on collaborating on this, at this point, since I need to work on the other items on the [Roadmap](https://github.com/jmcnamara/XlsxWriter/issues/653) in order (conditional formatting is third on the current list). Also, I need to work through my process for implementing a feature in the same way that I always do. I'll ping back into this thread once I have started on it. Thanks. -- John
Author
Owner

@jmcnamara commented on GitHub (Aug 18, 2020):

I'm closing this feature request and replacing it with #302 so as not to spam people who subscribed to this feature request three years ago. Anyone who is still interested in this feature can +1/subscribe to #302.

<!-- gh-comment-id:675319932 --> @jmcnamara commented on GitHub (Aug 18, 2020): I'm closing this feature request and replacing it with #302 so as not to spam people who subscribed to this feature request three years ago. Anyone who is still interested in this feature can +1/subscribe to #302.
Author
Owner

@jmcnamara commented on GitHub (Aug 25, 2020):

I've added some information about work in progress code for conditional formatting in #302, if anyone is interested in trying it.

<!-- gh-comment-id:680322761 --> @jmcnamara commented on GitHub (Aug 25, 2020): I've added some information about work in progress code for conditional formatting in #302, if anyone is interested in trying it.
Author
Owner

@jmcnamara commented on GitHub (Sep 5, 2020):

This feature is now on master for anyone who wants to try it. Docs are here: http://libxlsxwriter.github.io/working_with_conditional_formatting.html

<!-- gh-comment-id:687674581 --> @jmcnamara commented on GitHub (Sep 5, 2020): This feature is now on master for anyone who wants to try it. Docs are here: http://libxlsxwriter.github.io/working_with_conditional_formatting.html
Author
Owner

@jmcnamara commented on GitHub (Sep 7, 2020):

This feature is now available in version 1.0.0 of libxlsxwriter.

<!-- gh-comment-id:688537044 --> @jmcnamara commented on GitHub (Sep 7, 2020): This feature is now available in version 1.0.0 of libxlsxwriter.
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#25
No description provided.