Chart conditional format : color scale

edit

Updated thanks to @ouleyang's hint (upvoted).

Still a little handwork is needed:

1. Select the cells with the conditional format color scale applied (column C), and export it as PDF.
2. Import the PDF in Draw.
3. In Calc: Secondary click on the chart, choose Edit, click on the bars.
4. Click on the n-th data point node, secondary click on the data point and choose Format Data Point….
5. In Draw: Copy Area color Hex code from n-th "cell".
6. In Calc: Paste it in Area color next the Fill Color data range of n-th bar (column A).
7. Repeat for the next bar from step 5.
8. Add the formula =HEX2DEC(A2) in column B.
9. Edit the chart's Data Range to add Range for Fill Color.

Tested with LibreOffice 6.4.7.2 (x86); OS: Windows 6.1.

It would be great if someone finds a simpler way.

Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information. Thanks.

Check the mark ( → ) to the left of the answer that solves your question.