Created attachment 110896 [details]
When creating conditional formatting data bars on non-white cell backgrounds, the data bar gradient fade to white doesnt look that nice. Excel fixes this issue by having the data bar color used as a 1-pixel inner stroke around each data bar.
Created attachment 110897 [details]
Data Bars on different background colors - Calc vs Excel
Look at Excel's data bar features dialog (attachment 110901 [details]), they have a setting for Border and Border Color to achieve this look.
I confirm the current behavior and the enhancement sounds good to me, so setting to NEW.
Win 7 64-bit Version: 18.104.22.168.alpha0+
Build ID: 170616e9f2d30c1302bbb5a7a4b588bc05cd5cc9
TinderBox: Win-x86@39, Branch:master, Time: 2014-12-12_01:58:46
Created attachment 111073 [details]
the excel file used
Created attachment 157071 [details]
Screenshot showing gradient in calc filling cells too much
Build ID: libreoffice-22.214.171.124-snap1
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3;
Locale: en-US (en_US.UTF-8); UI-Language: en-US
The gradient itself looks nice now (no more color banding), but the bars now cover the cell borders (see attachment).
If no gradient is used (Fill: Color) it works fine.
So can this bug be seen as resolved and a new one should be filed (I could not find a related report yet) or is this related enough to keep this one going?
(In reply to firstname.lastname@example.org from comment #5)
> The gradient itself looks nice now (no more color banding), but the bars now
> cover the cell borders (see attachment).
> If no gradient is used (Fill: Color) it works fine.
> So can this bug be seen as resolved and a new one should be filed (I could
> not find a related report yet) or is this related enough to keep this one
As Jay said "Excel fixes this issue by having the data bar color used as a 1-pixel inner stroke around each data bar" let's keep this open.