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: 2014-12-20 09:43 UTC (History)
1 user (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

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