Currently, there is no way to clear all unprotected cells in protected sheet, and that option would be very useful. Question is: how to do it? Some options: - keep Clear Cells available on a protected sheet, that would delete unprotected cells only, or - add Select Unprotected Cells to Edit menu, and if unprotected cells only are selected Clear Cells should be available
It sounds good, so setting to NEW. Let's involve UX in the discussion.
Or would it be the new Sheet menu?
This would be very useful indeed. In my spreadsheet, there are multiple sheets. We have to keep the contents of one sheet week by week, but we have to clear all input values from another sheet. But only the values, the formulas must be kept. It would be very useful to be able to clear all unprotected cells from the second sheet. Currently we are manually selecting each value and clearing them. Because the sheet is rather large, it is tedious.
Yes, please! Have missed this for quite a while. I'm creating a weekly timetable, and would love to have a column of cells calculating the total daily hours. Currently the timetable can be cleared by selecting all relevant (yellow) cells in one swipe, but the hour calculators between the days would prevent this. Selecting all cells and clearing only the un-protected cells would make this possible.
We're replacing our use of the 'ux-advise' component with a keyword: Component -> LibreOffice Add Keyword: needsUXEval [NinjaEdit]
Select unprotected cells is more make sense. You can clear, copy, change attributes so on. Now working on it.
Gulsah Kose committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=ed715a460254e4d72c78ff6eb244a9fc6692e2a6 tdf#95883 Select Unprotected Cells in Calc It will be available in 6.0.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.
It's in Edit-Select menu. Fine. Since 5.4 is still not out, and per https://wiki.documentfoundation.org/ReleasePlan/5.4#5.4.0_release UI freeze is still not done, please backport.
With the comments in the patch that state that additional work needs to happen, i dont think this will be backported in time. https://gerrit.libreoffice.org/#/c/37424/
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d48ea7a1db4eaae0bae094f2155dcd3bc87720eb Prevent excess rows included in the resulting range list, tdf#95883 follow-up It will be available in 6.0.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.