Solid DataBar conditional formatting not persisting & defaulting to gradient databar. Add solid/gradient option?
I am loading a template workbook, modifying it by writing values to cells, and saving it as a new workbook.
I added and saved a solid fill DataBar conditional formatting rule to the template workbook.
Upon opening the workbook, updating the values, and saving via openpyxl, the DataBar reverts to a gradient fill.
It would be greatly appreciated if the solid fill could persist, or if the the openpyxl syntax for creating a DataBar rule could include a parameter for solid/gradient fill. Thank you.
Also, bi-directional conditional formatting (negative/positive values) reverts to one direction:
Edited by maxipaddy