Bug 101555

Summary: Apply conditional formatting
Product: LibreOffice Reporter: lukas.wischounig
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED INSUFFICIENTDATA    
Severity: enhancement CC: franciscoadriansanchez, ilmari.lauhakangas, libreoffice-ux-advise
Priority: medium Keywords: needsUXEval
Version: 5.1.4.2 release   
Hardware: All   
OS: All   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=101553
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 87351    

Description lukas.wischounig 2016-08-16 10:52:43 UTC
Add the ability to apply conditional formatting (cell format equals conditional formatting settings when conditional formatting is not applied anymore)
Comment 1 Buovjaga 2016-09-15 18:47:30 UTC
Could you please describe this proposal in more detail?

Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided the information.
Comment 2 lukas.wischounig 2016-09-21 13:38:28 UTC
(In reply to Buovjaga from comment #1)
> Could you please describe this proposal in more detail?
> 
> Set to NEEDINFO.
> Change back to UNCONFIRMED after you have provided the information.


Hi Buovjaga,

when i was working on a file with many entries i found conditional formattion is very useful for visually highlighting cells according to a specific condition. But when you have a bigger number of conditions (for example when looking for a numer of keywords in a coloumn) it is very unhandy to define a big numer of several conditions. i found it useful to be able to aply the current conditional format to the desired cells (meaning that the cell format equals that one defined in the conditiona format - e.g. backgroundcolor = red, text heigth = 13 etc.) and "reuse" one conditional format to the new needs (e.g. other keyword, other background color etc.)

Best Reguards
Lukas
Comment 3 Buovjaga 2016-09-21 17:37:27 UTC
I still do not quite understand.
So this is something that Clone formatting tool would not solve?
Comment 4 Francisco 2016-09-22 08:09:01 UTC
(In reply to Buovjaga from comment #3)
> I still do not quite understand.
> So this is something that Clone formatting tool would not solve?

He wants that it happens automatically: he changes the value of the cell, the formatting chanhes accordingly. Howevet, AFAIK, it already exists, but uses styles and not direct formating.
Comment 5 Buovjaga 2016-09-22 08:31:49 UTC
Lukas: maybe a picture would help more than a 1000 words? :)
Comment 6 Heiko Tietze 2017-01-15 11:42:40 UTC
Don't get it as well. Either the dialog becomes unhandy with many conditions (that could be a good question for UX) or the workflow is unclear with styles/formatting etc.

Just reopen if you can explain the use case ideally with an example/picture.