If the users clicks at a cell with that Calc features are linked (like Names/Name ranges, Conditional formatting, Validity) now it's not visible what features are already used in that cell. I would suggest to give the user the possibility to see and use the available features in the context menu. In the attached file, 3 features are used: 1. A2-A4 are cells that have the cell range name "numbers". If clicking at one or all of the cells, then it should be possible to open the "Sheet > Names Ranges and Expressions > Manage" dialog with the context menu. 2. Cell B2 contains the validity feature with cell range "numbers". If clicking at the cell, then it should be possible to open the "Data > Validity" dialog with the context menu. 3. Cell C2 contains conditional formatting. If clicking at the cell, then it should be possible to open the "Format > Conditional Formatting > Condition..." dialog with the context menu. I open only this bug and not a bug for every Calc feature that I would like to have in the context menu because I want a discussion with UX team which feature can be and is worth to be in the context menu. If any. I think this would improve the usability of Calc features.
Created attachment 134516 [details] 3 example features that should be acessible in the context menu
Sounds like a very helpful enhancement. But is such a context dependent function feasible, Timur, Eike, Moggi?
(In reply to Thomas Lendo from comment #0) > 3. Cell C2 contains conditional formatting. If clicking at the cell, then it > should be possible to open the "Format > Conditional Formatting > > Condition..." dialog with the context menu. Already suggested in bug 87357.
The 3 examples of features I mentioned in my initial post stand for all possible features that could be promoted to the user. I don't know more so it's to others to bring them up - here or in another bug(s). Ist it ok to have both features (validity and name ranges) in this bug? I hear the devs rant in my thoughts. :) And for the record, there are some use cases (collaboration with others, forgotten use of a feature in a cell, short mouse ways, overview what is applied to the selected cell ...) where a context menu entry would help to find and to (re)use a feature that is applied to a cell or cell range.
https://gerrit.libreoffice.org/#/c/47925/ solves only named ranges part. The other two patches are on the way.
(In reply to Gülşah Köse from comment #5) > https://gerrit.libreoffice.org/#/c/47925/ solves only named ranges part. The > other two patches are on the way. Happy to review when all is complete.
Thanks Heiko, i will send seperate patches for validation and conditional format issues. fyi.
@Heiko completed https://gerrit.libreoffice.org/#/c/48067/ for validity https://gerrit.libreoffice.org/#/c/48417/ for conditional format https://gerrit.libreoffice.org/#/c/47925/ for named range
Gulsah Kose committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=844c92793c1399e2f14f671f964ea35e1bce24ac [Pardus] tdf#108989 Add contextual validity command. It will be available in 6.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Gulsah Kose committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=a626e249033fb9a7ac117e28f3152cedf98b61fc [Pardus] tdf#108989 Add contextual manage names command. It will be available in 6.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
(In reply to Yousuf Philips (jay) from comment #3) > (In reply to Thomas Lendo from comment #0) > > 3. Cell C2 contains conditional formatting. If clicking at the cell, then it > > should be possible to open the "Format > Conditional Formatting > > > Condition..." dialog with the context menu. > > Already suggested in bug 87357. Because of request 3 has seperate bug report, reported by Yousuf, and request 1(named ranges) and 2(validity) is completed, i'm moving that bug as RESOLVED FIXED. Feel free to change it if there is a problem. Request 3 is solved by https://gerrit.libreoffice.org/#/c/48417/ waiting for code review.
Useful. Deserves to be put in https://wiki.documentfoundation.org/ReleaseNotes/6.1.
(In reply to Timur from comment #12) > Useful. > Deserves to be put in https://wiki.documentfoundation.org/ReleaseNotes/6.1. Done :) Thank you all for supporting.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=707e0f4e6b6e36432c0f04f22719428a7e1a50ee coverity#1428613 check IsValidReference() return value, tdf#108989 follow-up It will be available in 6.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.