[Libreoffice-ux-advise] [Bug 114789] STYLES: conditional formatting cannot be applied selectively

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

Buovjaga <todventtu@suomi24.fi> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |needsUXEval
                 CC|                            |libreoffice-ux-advise@lists
                   |                            |.freedesktop.org
           Severity|normal                      |enhancement

--- Comment #8 from Buovjaga <todventtu@suomi24.fi> ---
(In reply to Elmar from comment #7)
> The sequence should be (as it seems to be):
> 1. Application defaults, overridden by
> 2. Application Tools default overrides (typically stored in template),
> overridden by
> 3. Default style, overridden by
> 4. Applied style, overridden by
> 5. Direct cell formatting
> (there seems to be a level between 2 and 3 which happens for the current
> session if I change the settings using the toolbar.)
>
> There seems to be an easy solution:
> Consistently utilise the Y/N/empty binary values, where empty is equivalent
> to greyed.
>
> If Y - then apply the format
> if N - do not do anything
> if grey - inherit
>
> Then if one added a tickbox into any tab, you could determine whether to
> apply the format or not. 
>
> You could make it easy to see if a tab applies or not without having to go
> into it if the tab name text were to be white.
>
> Then the tab contents could be determined by the greyed feature.
>
> MS Excel does a partial implementation of this. They present you a list when
> you modify a style where you can tick boxes to indicate if you want to apply
> the different format sets. But in typical MS fashion, this seems to be more
> an afterthought than a design issue.
Ok, let's show this to the design team.

-- 
You are receiving this mail because:
You are on the CC list for the bug.