Bug 101555 - Apply conditional formatting
Summary: Apply conditional formatting
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.4.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsUXEval
Depends on:
Blocks: Conditional-Formatting
  Show dependency treegraph
 
Reported: 2016-08-16 10:52 UTC by lukas.wischounig
Modified: 2017-01-15 11:42 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.