[Negative progress] <as proxy for conditional formatting - databars like excel>

[parthi2929]

Description

Excel has this super cool data bars from conditional formatting..

which also supports negative vlaues..

Your progress bar is a wonderful proxy to achieve same affect (give a plain markdown file, a python snippet could update the numbers column with your proxy as conditional formatting databars).. if you could also support negative numbers, that need would be much more complete.. Kindly consider..

Tech notes

No response

Screenshots or Diagrams

No response

Additional information

No response

[guibranco]

Hi @parthi2929, cool!

Could you give me some clarification here?
Under the current approach, the bar is filled from left to right with the percentage. Should it be from right to left for a negative value? Is that the expected outcome?

[guibranco]

@parthi2929 could you please confirm my understanding of your request?

[parthi2929]

@guibranco Sorry for the delay. Kindly find an example below. For below numbers in excel, I get below conditional formatting.

I would like to get this effect for markdown table, with each cell as proxy bar from your lib

[parthi2929]

@guibranco excel achieves this, based on entire value of data selected (for ex, if I selected just 100 to 0 in above cells, the bar would have been different)..

However, each proxy bar's is independent, unaware of any data outside, so to achieve similar effect, we should be able to set the center (or origin or start) of progress from middle or from left.

A. If origin set as middle, and negative value given, the progress emanates from middle to left..
B. If origin set as middle, and positive value given, the progress emanates from middle to right..
C. If origin set as left, and negative value given, it can be NA or absolute (negative negated)
D. If origin set as left, and positive value given, current behavior
E. If origin set as right, and negative or positive value given, NA or can also be absolute, negating sign, but progress from right to left

I request A and B. Others, can be, as you see fit.

[gitauto-ai]

@parthi2929 Pull request completed! Check it out here #74 🚀

Note: I automatically create a pull request for an unassigned and open issue in order from oldest to newest once a day at 00:00 UTC, as long as you have remaining automation usage. Should you have any questions or wish to change settings or limits, please feel free to contact [email protected] or invite us to Slack Connect.