[Libreoffice-bugs] [Bug 126047] FORMATTING

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=126047

m.a.riosv <miguelangelrv at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |miguelangelrv at libreoffice.o
                   |                            |rg

--- Comment #1 from m.a.riosv <miguelangelrv at libreoffice.org> ---
(In reply to syllaslp from comment #0)
> Suggestion: Calc should allow different styles, applied to the same range,
> in conditional formatting.
> 
> The way it works nowadays is awful.
> 
> How it should work:
> 
> 1. It should allow setting up the order the conditional formats are applied.
Editing the conditional format it's possible to move up/down the inner
conditions

> 
> 2. If a conditional format affects DIFFERENT cell attributes: both
> conditional formats should be applied. Ex.: CF1 changes only cells
> background and CF2 changes only font color. If a cell content matches both
> CF1 and CF2, it will have a background ant color font changed.
Maybe amazing, but I think we are not going to view such enhancement in a short
time if implemented at some time, because I think not so easy to code, generate
an internal style mixing those, and perhaps slowing the spreadsheet.
In any case as the styles has inheritance, you can make a tree of styles and
apply the one that meets the conditions.

> 
> 3. If a conditional format affects the SAME cell attribute, I imagine 2
> possibilities, to be thought and chosen:
> 
> 3.1. Only the first CF is applied.
> 
> 3.2. Both of them are applied, so the last one remains.
> 
> 3.3. Another possibility is to warn the user and ask her/him to choose the
> desired behavior.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190621/ee87bda4/attachment.html>