Created attachment 114686[details]
Sample XLSX showing issue with importing Data Bar
Steps to reproduce:
1. Open WinterOlympics.xlsx in Excel
2. Open WinterOlympics.xlsx in Calc
3. Compare Row F5:F30
Note the color of the Data Bar is set to "Orange" in Excel but shows Green in Calc. In Calc,
Format -> Manage Conditional Formatting -> F5:F30 -> Edit -> More shows the strange value of Red (negative) to White (positive). Editing these values has no effect.

This bug fix is mentioned in the release notes of the coming LibreOffice 5.0 (see release notes https://wiki.documentfoundation.org/ReleaseNotes/5.0). Therefore it would be wonderful if this feature really worked well, otherwise it should not be mentioned in the release notes. In the notes it reads:
Import of Data bars and Color Scales color values handles theme colors. tdf#90511 (Markus Mohrhard)

(In reply to darshan.gandhi from comment #12)
> Verified today in LO Version: 5.0.0.0.beta1
> Build ID: 0a16c3dda4150008d9be6f24cbd15ac198d116d3
> Locale: en-US (en_US)
>
> Its still reproducible.
> Results are: Note the color of the Data Bar is set to "Orange" in Excel but
> shows Green in Calc.
>
> Please find attached screenshot.
That is a totally different problem and has nothing to do with the imported color. The imported color has been fixed as part of this bug.
The difference that you see now in Calc vs Excel is a difference in selecting the conditional formatting when you have two overlapping conditional formats. There is no way to get this correct in all cases as Libreoffice and Excel use a different concept for how they represent conditional formats.