[Libreoffice-ux-advise] [Bug 95883] CALC: Add option to clear all unprotected cells in protected sheet

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95883

Stéphane Guillou (stragu)  changed:

   What|Removed |Added

 Blocks||107450, 109139
 Whiteboard|target:6.0.0|target:6.0.0
   ||inReleaseNotes:6.0


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=107450
[Bug 107450] [META] Cell and sheet protection bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=109139
[Bug 109139] [META] Cell selection bugs and enhancements
-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Libreoffice-ux-advise] [Bug 95883] CALC: Add option to clear all unprotected cells in protected sheet

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95883

Stéphane Guillou (stragu)  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=15
   ||2327

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Libreoffice-ux-advise] [Bug 95883] CALC: Add option to clear all unprotected cells in protected sheet

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95883

--- Comment #10 from Commit Notification 
 ---
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.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 95883] CALC: Add option to clear all unprotected cells in protected sheet

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95883

--- Comment #9 from Yousuf Philips (jay)  ---
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/

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 95883] CALC: Add option to clear all unprotected cells in protected sheet

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95883

Timur  changed:

   What|Removed |Added

 Status|RESOLVED|VERIFIED
 CC||gti...@gmail.com,
   ||philip...@hotmail.com

--- Comment #8 from Timur  ---
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.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 95883] CALC: Add option to clear all unprotected cells in protected sheet

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95883

--- Comment #7 from Commit Notification 
 ---
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.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 95883] CALC: Add option to clear all unprotected cells in protected sheet

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95883

Commit Notification  changed:

   What|Removed |Added

 Whiteboard||target:6.0.0

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 95883] CALC: Add option to clear all unprotected cells in protected sheet

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95883

--- Comment #6 from Gülşah Köse  ---
Select unprotected cells is more make sense. You can clear, copy, change
attributes so on. Now working on it.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 95883] CALC: Add option to clear all unprotected cells in protected sheet

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95883

Gülşah Köse  changed:

   What|Removed |Added

 CC||gulsah.1...@gmail.com
   Assignee|libreoffice-b...@lists.free |gulsah.1...@gmail.com
   |desktop.org |

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 95883] CALC: Add option to clear all unprotected cells in protected sheet

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95883

Timur  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=10
   ||2162

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 95883] CALC: Add option to clear all unprotected cells in protected sheet

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95883

Heiko Tietze  changed:

   What|Removed |Added

  Component|LibreOffice |Calc

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 95883] CALC: Add option to clear all unprotected cells in protected sheet

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95883

--- Comment #4 from mrelw...@yahoo.com ---
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.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 95883] CALC: Add option to clear all unprotected cells in protected sheet

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95883

pelladiga...@gmail.com changed:

   What|Removed |Added

 CC||pelladiga...@gmail.com

--- Comment #3 from pelladiga...@gmail.com ---
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.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise