Conditional styling doesnt support color scale with number or percentage

[bokrma]

I checked the code for getting the details of conditional styling, but seems like I cant get the color scale with number or percentage if it was inside the sheet:
Untitled_spreadsheet_7.xlsx

is it gonna be supported?

[oleibman]

Thank you for the sample spreadsheet. PhpSpreadsheet is expecting the following optional xml tags:

<colorScale>
<cfvo type="min"/>
<cfvo type="percentile" val="40"/>
<cfvo type="max"/>
...
</colorScale>

Your sample has the following xml:

<colorScale>
<cfvo type="formula" val="25"/>
<cfvo type="max"/>
...
</colorScale>

The formula tag is obviously taking the place of min here. I imagine it might take the place of either of the other two as well. I need to figure out how it works, especially since, as we see in your sample, at least one of the tags can be omitted.