Bug 105038

Summary: Conditional formatting: more control
Product: LibreOffice Reporter: librelibre
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED INSUFFICIENTDATA    
Severity: enhancement CC: libreoffice-ux-advise
Priority: medium Keywords: needsUXEval
Version: 5.2.4.2 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 87351    

Description librelibre 2017-01-02 06:38:02 UTC
Description:
for continuous value affect formatting:
support for cell values affecting the sRGB or linearSRGB-709/XYZ..
and affecting possibility also font weight, opacity, 

for more discrete, font-family, pattern, 

via not only based of that cell's values but also relative/absolute mixed references, 
!!same even for graphs, the option for individual data points' various formatting settings and lines also (maybe since #=n-1 maybe, index of line based on previous point) 

so can use formulas to directly control but fine and coarse basis, and ability to change precendence, e.g. series formatting, indivdual data points, axis, graph; cell, row, column, whole area, and maybe if row and column intersect make the combo also possibly a combination of both previous settings
(node-based UI and coding?)

Actual Results:  
only color ramp supported or discrete formatting based on boolean conditions , >,<,=,not's  chart point's formatting have no ability yet to base on cell/relative-offset's contents

Expected Results:
more versatile as listed above


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:51.0) Gecko/20100101 Firefox/51.0
Comment 1 Heiko Tietze 2017-01-05 08:56:02 UTC
I don't get what you mean, sorry. Conditional formatting means to apply a style to a cell for a defined condition. That's a WORKSFORME, despite the issue that background (color) uses the pre 5.3 approach and does not allow to set every area properties as known from shapes, for instance.

Do you suggest to enhance the cell style? That is a WONTFIX as we are bound to ODF. Or to fix an issue? And if you are talking about more elaborated conditions please specify what you expect (there are plenty right now).
Comment 2 Heiko Tietze 2017-03-21 16:47:32 UTC
Cell style works for me and there are not enough input to comment on this ticket.