the style preview area(s) should now show the text that is also shown in the top-left cell of the range.it might prove relatively hard to make the user adequately aware of status changes without some use of animations (see the slide sorter in Impress which now uses very nice animations when dragging and dropping).adding ↑/↓ down buttons for sorting is simple but seems a clumsy workaround (it could be used as an accessible fallback method though).the preferred way of sorting should be drag and drop, but development resources are too limited right now to implement that (as per discussion with Markus).adding a mechanism for sorting conditions is not part of this proposal, but could be added later on.the first condition is readily available.open Format > Conditional Formatting > Condition.the usual workflow of defining a conditional formatting remains, i.even before actually performing actual math. She uses Calc to do so and conditional formatting helps her visually spot things like outliers etc. Ingrid: Ingrid is responsible for interpreting the results of a survey.To get a quick overview over all relevant factors, she uses conditional formatting. She uses a macro to insert live stock market data into her spreadsheet. Hermione: Hermione is a home user of LibreOffice, who has recently begun investing in the stock market.She is a visual type and thus likes colorful visualization methods. Geraldine: An HR person who uses a spreadsheet to track work metrics of employees, such as overtime, pay, and illnesses.Overlapping Ranges of Conditional Formats: If one defines conditionally formatting for two or more ranges that partially overlap, like A1:B4 together with B2: C3.
Conditional formatting: If a style is applied to a spreadsheet cell when a certain condition regarding its value is met.tdf#43937 - Conditional formatting dialog scroll slider function partial broken.difficult-to-implement features, namely: drag-and-drop, animations.maybe some new capabilities (sorting of conditions etc.).More usable dialog for Calc's Conditional Formatting feature ( Format → Conditional Formatting.)
4.1.2.2 Managing conditional formatting.