Download it now!
Bug 87355 - CONDITIONAL FORMATTING: Data bar doesnt render well on non-white cell background
Summary: CONDITIONAL FORMATTING: Data bar doesnt render well on non-white cell background
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.5.0.0.alpha0+ Master
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Conditional-Formatting
  Show dependency treegraph
 
Reported: 2014-12-16 09:11 UTC by Yousuf Philips (jay) (retired)
Modified: 2020-01-11 10:20 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
sample file (11.55 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-12-16 09:11 UTC, Yousuf Philips (jay) (retired)
Details
Data Bars on different background colors - Calc vs Excel (46.81 KB, image/png)
2014-12-16 09:12 UTC, Yousuf Philips (jay) (retired)
Details
the excel file used (9.54 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-12-20 09:43 UTC, Yousuf Philips (jay) (retired)
Details
Screenshot showing gradient in calc filling cells too much (23.80 KB, image/png)
2020-01-11 04:33 UTC, s5t1e3v4e3m11@hotmail.com
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Yousuf Philips (jay) (retired) 2014-12-16 09:11:18 UTC
Created attachment 110896 [details]
sample file

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.
Comment 1 Yousuf Philips (jay) (retired) 2014-12-16 09:12:03 UTC
Created attachment 110897 [details]
Data Bars on different background colors - Calc vs Excel
Comment 2 Yousuf Philips (jay) (retired) 2014-12-16 11:01:24 UTC
Look at Excel's data bar features dialog (attachment 110901 [details]), they have a setting for Border and Border Color to achieve this look.
Comment 3 Buovjaga 2014-12-16 11:15:09 UTC
I confirm the current behavior and the enhancement sounds good to me, so setting to NEW.

Win 7 64-bit Version: 4.5.0.0.alpha0+
Build ID: 170616e9f2d30c1302bbb5a7a4b588bc05cd5cc9
TinderBox: Win-x86@39, Branch:master, Time: 2014-12-12_01:58:46
Comment 4 Yousuf Philips (jay) (retired) 2014-12-20 09:43:39 UTC
Created attachment 111073 [details]
the excel file used
Comment 5 s5t1e3v4e3m11@hotmail.com 2020-01-11 04:33:56 UTC
Created attachment 157071 [details]
Screenshot showing gradient in calc filling cells too much

Version: 6.3.4.2.0+
Build ID: libreoffice-6.3.4.2-snap1
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded

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?
Comment 6 Buovjaga 2020-01-11 10:20:15 UTC
(In reply to s5t1e3v4e3m11@hotmail.com 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
> going?

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.