| Summary: | Conditional formatting applied to more cell's, can't be edited when not all are selected | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Cor Nouws <cno> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | major | CC: | cno, jmadero.dev, markus.mohrhard |
| Priority: | medium | ||
| Version: | 4.0.0.0.alpha0+ Master | ||
| Hardware: | Other | ||
| OS: | Linux (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | spreadsheet with some condit form. | ||
It stricked me too when working in 3.6.4.x that when I select Format > Condition, that it is applied to more cells with the same cond. formatting. (Dit not yet test at which moment this is going to annoy, but for sure those cases will exist ;-) ) This is a feature in 4.0 Beginning with 4.0 we will be able to define overlapping conditional formats and that is what you did in this case. Use the Manage Conditional Formats dialog and use Edit(still disabled but will be enabled before the feature freeze) for the other cases. (In reply to comment #2) > the Manage Conditional Formats dialog and ... Is where :-) ? What I see now is that I can apply conditional formatting to a range and then select one cell and with the same dialog apply extra conditional formatting. Correct? (In reply to comment #3) > (In reply to comment #2) > > > the Manage Conditional Formats dialog and ... > > Is where :-) ? Format->Conditional Formatting->Manage It has been introduced in 3.6 to allow a better overview about conditional formatting and is a better tool to edit conditional formatting. > > What I see now is that I can apply conditional formatting to a range and > then select one cell and with the same dialog apply extra conditional > formatting. > Correct? Until 3.5 a cell could only have a conditional formatting that was a cell property. 3.6 moved to range based conditional formatting to allow formats that are no longer only local to the current cell but take into account all the other values in the range. For 4.0 I now made it also possible that a cell can contain several independent conditional formats. Imagine you apply a conditional format to A1:A4 for color scales which means that the range the conditional format is applied to is important but you'd like to format A2:A3 also with anothe conditional format. This is now possible by just defining an additional conditional format for A2:A4 which will in contrast to older behavior not overwrite the old conditional format (till 3.5) or change the conditional of A1:A4 ( in 3.6 ) This is a major improvement that was one goal for range based conditional formats. This improves interoperability with MSO and removes nearly all known limitation od conditional formats that we had until now. Together with the new conditional formats in master they are now a universal tool to improve the look of complex spreadsheets. (In reply to comment #4) > (In reply to comment #3) > > Is where :-) ? > > Format->Conditional Formatting->Manage Ah... dragging my older user profiles, with registrymodifications.xcu that holds some of my favorite extra menu items, still prevents new items to show up. God knows how much I may have missed the last years :-) > Until 3.5 a cell could only have a conditional formatting that was a cell > property. 3.6 moved to range based conditional formatting to allow formats > that are no longer only local to the current cell but take into account all > the other values in the range. For 4.0 I now made it also possible that a > cell can contain several independent conditional formats. > [..] All great news \O/ Any idea if there is already something publised on that? If not, I might try to entamate some .. :-) (Sorry for the non-technical comments here ;-) ) |
Created attachment 70338 [details] spreadsheet with some condit form. 1. Spreadsheet 2. Select A1-A3 3. Format > Condition and add something... e.g. Equal "AA" style Result 4. press OK 5. Now select A1 6. start menu Format > Condition .. > no condition is defined / shown