Bug 157930

Summary: MENU: Easily insert commonly used conditional formatting rules
Product: LibreOffice Reporter: Paris Oplopoios <parisoplop>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: enhancement CC: aron.budea, heiko.tietze, ilmari.lauhakangas, parisoplop
Priority: medium    
Version: unspecified   
Hardware: All   
OS: All   
Whiteboard: target:24.2.0
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 85811    
Attachments: Screenshot

Description Paris Oplopoios 2023-10-26 09:48:22 UTC
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:
-
Comment 1 Heiko Tietze 2023-10-26 11:44:09 UTC
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).
Comment 2 Paris Oplopoios 2023-10-26 16:03:10 UTC
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)
Comment 3 Tomaz Vajngerl 2023-10-27 03:45:15 UTC
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.
Comment 4 Heiko Tietze 2023-10-27 08:09:26 UTC
The range selection works but without the button it is not clear for the users.
Comment 5 Paris Oplopoios 2023-10-27 10:20:23 UTC
Added the button in https://gerrit.libreoffice.org/c/core/+/158555, also updated the spacing, what do you think Heiko?
Comment 6 Commit Notification 2023-10-27 16:15:51 UTC
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.
Comment 7 Commit Notification 2023-10-28 23:06:34 UTC
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.
Comment 8 Commit Notification 2023-10-31 13:23:12 UTC
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.
Comment 9 Buovjaga 2024-05-04 16:21:42 UTC
Can this be added to the release notes https://wiki.documentfoundation.org/ReleaseNotes/24.2 ? Thanks.