https://bugs.freedesktop.org/show_bug.cgi?id=88755
Bug ID: 88755
Summary: LibreOffice Calc - Conditional Format - Color Bar
functionality desperately needs improvements and
corrections
Product: LibreOffice
Version: 4.3.5.2 release
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Libreoffice
Assignee: [email protected]
Reporter: [email protected]
Working on a quick table to analyze some information and figuring Conditional
Format - > Color bars would be great. Just green to red.
It is a struggle to pick the same colors over time for several sets of data,
because:
- you can only see three colors at a time in a scrolling menu
>>> request a larger UI window with 24-36 or so most common quick picks - see
>>> for example the font or background color picker
- like colors are not grouped, for instance no grouping of greens reds blues
etc they're all over the list
- some of the colors are imo grossly unusable or non-existent some of the reds
for instance are just black on screen, one sees this in the font and background
color picker too, but it is easier to ignore.
- there are also problems whereby a green to red scale turns certain cells
black, which I cannot figure out. I have a simple 0 - 60 value bar and the
exact middles turn black???
>>> Added problem here is that when the cell turns dark, there is no automatic
>>> switching to white font, so you could actually read the value in the cell.
So you'd need an additional conditional format or systemwide preference, if
cell is shaded above a certain value and contrast between cell shade and font
color is less than x then switch default text color from black to white.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
