Description: In order to make it easier for individuals to add conditional formattings to a spreadsheet, we could create a menu like this: Format->Conditional->Condition->Greater than/Less than/Equals etc. Which would open a dialog where you can specify the value (ie. Greater than X) and the style to add the conditional formatting into the selected range, with a possiblity to reconfigure said range. Excel has similar functionality. There's a WIP patch for this here: https://gerrit.libreoffice.org/c/core/+/156831 Steps to Reproduce: - Actual Results: - Expected Results: - Reproducible: Always User Profile Reset: No Additional Info: -
Created attachment 190438 [details] Screenshot Nice improvement. I miss a button to select the range, and it would be nice to auto-expand to the next empty cell on top and bottom. The UI needs a bit spacing. Take a look at https://wiki.documentfoundation.org/Design/Guidelines/PropertyDialog for the recommendation. I wonder in what situation the popup menu appear. For now I see the command only in the main menu (might be this is a pop-up).
The range should be selectable the same way in other similar dialogs (just reselect the range in the spreadsheet and it will update in the dialog)
Similar dialogs that have an entry to select a range usually have a button next to the range entry to switch to the spreadsheet range selection view, which I think Heiko is referring to. See any of the Data -> Statistics dialogs. Without that in some cases the range selection doesn't work properly.
The range selection works but without the button it is not clear for the users.
Added the button in https://gerrit.libreoffice.org/c/core/+/158555, also updated the spacing, what do you think Heiko?
Paris Oplopoios committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/217f23f6437b1cac10fb4ea09b72fa896d46bd6b tdf#157930 sc: Add easy to use conditional formatting menu It will be available in 24.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Paris Oplopoios committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/f8f8d5ec4568a10dc77144369f52b2dd165e66c5 tdf#157930 Add button to switch to range view in condformateasydlg It will be available in 24.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
offtkp committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/c8da023efe26efcb166c3525ca73fe62f26e154c tdf#157930 Add Contains Text rule to easy conditional format dialog It will be available in 24.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Can this be added to the release notes https://wiki.documentfoundation.org/ReleaseNotes/24.2 ? Thanks.