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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #12 from Elmar <roberg at iafrica.com> ---
@Heiko, let's see if I can be more explicit.

Yes, I appreciate my long story might be a problem, but I had to do that to
justify my issue.

To cut to the chase, here is a proposal which should solve all the problems.

See together with my latest attachments (styles1-2 proposal.odp and styles1-2
proposal.jpg). the jpg is just a screenshot of the picture in the odp.

Add a checkbox to each of the "Format Cells" tabs. Good place is top right hand
corner, so it will not be missed.

If it is ticked, then change the tab label colour to white, so you can see
without entering the table whether it is active or not.

If the checkbox is ticked, then disable that formatting.

This means that any tab which has been disabled will be ignored when I apply
the formatting.

So, let's say I want to create a style which only changes the Numbers formats.
If I tick all of the other tabs, then they will be ignored.

--------------------------------------

I do see a problem: if one cannot attach more than one style to a cell, then
this cannot be used.

-------------------------------------

In practice though, I would typically only want to have a variable Numbers
formats, whilst all the others could be kept in one style.

So that I can apply the same colours, borders, etc but have the target cells
containing numbers, text, etc.

But the solution could still work if the checkbox option were added, not to the
style, but to the override "Format Cells" feature (when using feature in the
Menu, Toolbar, or context dialog (right-click on cell or range of cells).

Does this make more sense?

-------------------------------------
When saving to Excel file, there has always been a problem with styles. My
suggestion is that one does not try to fight MS in spite of how unpalatable
that might be.

Excel's solution (see the attachment  styles1-2 excel.png) is to allow one
choose which of the tabs to use by having a separate list. But I think that my
suggestion is more elegant.

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