Problem description: I can't delete rows that are unprotected in a document with protection turned on Steps to reproduce: 1. New Spreadsheet 2. Select a number of rows via the row header and unprotect 3. Set sheet protection on the sheet 4. Attempt to delete rows using the row header Current behavior: I get a 'Protected cells can not be modified' warning Expected behavior: I should be able to delete the rows since they aren't protected. Platform (if different from the browser): Browser: Opera/9.80 (Windows NT 5.1; U; en) Presto/2.9.168 Version/11.52
I am pretty sure that this is a user error. You can not do changes that would touch position of protected contents, so in my "Sample0.ods" you only can delete rows/columns below/behind the protected cell. Help and documentation seem to be a little vague concerning these facts, in the Calc Manual under "Cell protection" I read "Use the Cell Protection options to protect cells against certain types of editing" @Mark C Please attach a sample document!
Created attachment 54132 [details] Sample0.ods See comment 1!
I understand what you're saying, but this is different from the behaviour of MS Excel and breaks compatibility with it. Corel's Quattro Pro does have the same behaviour though ;-) interestingly enough. Your attachment is exactly what I produce as well. Mark
MS Office 2010 has more fine-grained control over protection. You can set various levels, including the ability to delete rows, but this affects the whole sheet, whether or not there are protected cells.
Gnumeric ignores my sheet protection :-( So at least we should have selectors. Not only "Protected", but - Protect Cell(s) contents - Protect Cell contents' position in the sheet. For my needs that would be useful. But we additionally have to keep in mind compatibility to other programs and ODF and and... @David: Can you help with ODF knowledge or should this be handled by Spreadsheet team?
Please read this message in its entirety before responding. Your bug was confirmed at least 1 year ago and has not had any activity on it for over a year. Your bug is still set to NEW which means that it is open and confirmed. It would be nice to have the bug confirmed on a newer version than the version reported in the original report to know that the bug is still present -- sometimes a bug is inadvertently fixed over time and just never closed. If you have time please do the following: 1) Test to see if the bug is still present on a currently supported version of LibreOffice (preferably 4.2 or newer). 2) If it is present please leave a comment telling us what version of LibreOffice and your operating system. 3) If it is NOT present please set the bug to RESOLVED-WORKSFORME and leave a short comment telling us your version and Operating System Please DO NOT 1) Update the version field 2) Reply via email (please reply directly on the bug tracker) 3) Set the bug to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + LibreOffice is powered by a team of volunteers, every bug is confirmed (triaged) by human beings who mostly give their time for free. We invite you to join our triaging by checking out this link: https://wiki.documentfoundation.org/QA/BugTriage There are also other ways to get involved including with marketing, UX, documentation, and of course developing - http://www.libreoffice.org/get-help/mailing-lists/. Lastly, good bug reports help tremendously in making the process go smoother, please always provide reproducible steps (even if it seems easy) and attach any and all relevant material
This problem is still present on 4.2.5.2 running under Arch Linux.
I'll piggyback on this one. I'm currently working on adding four new sheet protection options for Calc. They conditionally support: * insert columns. * insert rows. * delete columns. * delete rows. over unprotected cells on a protected sheet, provided that the sheet protection options specifically enable one or more of these options.
The new change will add ods import and export as well. The xls and xlsx import and export should already be working even without my change.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=034be10413ed4915090678ad4f1d48596cf5e206 tdf#43535: support additional sheet protection options. It will be available in 5.4.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.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=7ae50f522f94987afe85674f6691fc37c55bd3d1 tdf#43535: add unit test for this. It will be available in 5.4.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.
What Mark noticed corresponds with unselected "delete rows/columns" now. Looks like Fixed for Delete, but I can't confirm for Insert, there are commands, but I still get "Protected cells..". @Kohei: please add to https://wiki.documentfoundation.org/ReleaseNotes/5.4#Calc.
What Mark noticed corresponds with unselected "delete rows/columns" now. Looks like Fixed for Delete. I can't confirm for Insert, there are Insert.. available on all rows even protected. Is it OK? On a second thought, probably yes if given that right. @Kohei: please add to https://wiki.documentfoundation.org/ReleaseNotes/5.4#Calc but with those details.
(In reply to Timur from comment #13) > What Mark noticed corresponds with unselected "delete rows/columns" now. > > Looks like Fixed for Delete. I can't confirm for Insert, there are Insert.. > available on all rows even protected. Is it OK? Yes, if the insert rows option is checked in the dialog, you should be able to insert rows even over the protected region. I took that behavior from how Excel handles it.
Just added an entry for this enhancement on the release notes page. I'll mark this as finished.
Hi (In reply to Kohei Yoshida from comment #15) > I'll mark this as finished. Thanks for these new options. Can I ask if access to these options via the API is possible, see Bug 55969 Best regards Pierre-Yves
(In reply to pierre-yves samyn from comment #16) > Hi > > (In reply to Kohei Yoshida from comment #15) > > I'll mark this as finished. > > Thanks for these new options. Can I ask if access to these options via the > API is possible, see Bug 55969 I have no idea. But since I didn't do anything special to handle the API, it's most likely a "no". That would be another enhancement that needs to be worked on separately, I'm afraid.
Great work! I looked at your patch, sadly I don't understanding it as my programming skills are very limited, to say the list. Do you know if there is any plans / possibilites to add the following options to select from from when protecting a sheet to allow users to: - allow to format columns: (allowing to hide / unhide columns) (allowing to resize columns) - allow to format rows: (allowing to add / unhide rows) (allowing to resize rows) These would be very useful to have and have been in MS Excel since at least Excel 2010.