| Summary: | CALC Conditional Formatting - Simplified single background colour fill | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Colin <that.man.colin> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | enhancement | CC: | miguelangelrv |
| Priority: | medium | ||
| Version: | 7.0.6.2 release | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
Sample conditional format background
Sample conditional format background 2 |
||
|
Description
Colin
2021-08-18 12:41:12 UTC
Created attachment 174379 [details]
Sample conditional format background
Styles can inherit from other styles, so you only need to change in the new style, e.g. the background color.
See the attached file 'Untitle1' style applies the green background for the cells.
'Untitle 1' inherits from 'Default'
Cells CF range has 'Hyperlink' style.
CF applies 'Untitle1' for odd rows, green background, but respects the rest of the attributes, because only 'background' attribute is modified in it.
(In reply to m.a.riosv from comment #1) > Created attachment 174379 [details] > Sample conditional format background > > Styles can inherit from other styles, so you only need to change in the new > style, e.g. the background color. > > See the attached file 'Untitle1' style applies the green background for the > cells. > 'Untitle 1' inherits from 'Default' > Cells CF range has 'Hyperlink' style. > > CF applies 'Untitle1' for odd rows, green background, but respects the rest > of the attributes, because only 'background' attribute is modified in it. My point is If I already have all the cells defined and there is no default stylesheet or user stylesheet even vaguely resembling what is already in the cell why is it not possible to just make what it sees a style for which I can then simply change the background colour? I have to search and experiment with the existing styles to discover the alignment or font name, size, colour or background is of no use to me. I want what I see(have) with a different background colour. Compare 1 Search for style 2 Does it look right 3 Try it 4 Was it right 5 No Change it 6 ......repeat from 2 (Or 1 if the stylesheet was a total failure) OK Remember, after the new stylesheet has been completed and failed and a new stylesheet commenced then it's practically impossible to remove failures from the list of 22,372 useless styles. With 1 Change the attributes I want to change OK Then, if I want to change another cell or collection of cells to the same style I can just add them to the conditional format I created in 1 step. If I want a different test utilising my accepted style then I can re-use that stylesheet modifying as appropriate. Still with only a couple of steps. Created attachment 174388 [details]
Sample conditional format background 2
Attached the sample file with a more explicit use of the styles.
Only one style, it's needed to modify the background of cells with different styles.
Seems you want a direct format from the CF, what it's achieved, I think, with the sample file, without any search.
(In reply to m.a.riosv from comment #3) > Created attachment 174388 [details] > Sample conditional format background 2 > > Attached the sample file with a more explicit use of the styles. > > Only one style, it's needed to modify the background of cells with different > styles. > > Seems you want a direct format from the CF, what it's achieved, I think, > with the sample file, without any search. I think I've found your page now. I was always working from the "styles selection and maintenance" within the conditional formatting management facility - a nightmare for the uninitiated. Now I've "found" the "manage styles" sidebar it becomes a lot clearer. Some experimentation is called for. Perhaps a status change to idiot user is appropriate. Thanks. Don't worry, nobody is borne knowing. And this is the typical, no easy, to find how. In any case, when you have doubts, better begin asking on our forum. https://ask.libreoffice.org/ |