Re: [libreoffice-users] Unable to Protect/Unprotect cells in Libreoffice 5
On 8/27/2015 8:51 AM, Mike Scott v...@scottsonline.org.uk wrote: On 27/08/15 13:30, Tanstaafl wrote: We have a ton of Writer Templates with Tables in them, that have protected cells (with formulas in them), that users sometimes unprotect (right-click on cell Cell Unprotect) to delete the formula and manually enter numbers. I just discovered - after updating a lot of our users - that apparently this is broken in the first 5.x release. There simply is no 'Cell' context menu option, and nothing in any of the Menus to allow me to unprotect the cell... Can anyone else confirm this? Yes. (5.0.0.5/mint) Thanks, bug 93713 reported... https://bugs.documentfoundation.org/show_bug.cgi?id=93713 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Unable to Protect/Unprotect cells in Libreoffice 5
On 8/27/2015 10:01 AM, Mike Scott v...@scottsonline.org.uk wrote: But I think you may have misread my note. Nope... If you R-click the table *in the navigator* (use F5) there's a Table|Unprotect option. It only appears though if the table does have a protected cell. At least here and I have just checked it. That is what I did, and you are correct that the choice is there. But my point was that it did not unprotect the cell. It allowed me to unprotect the entire Table, but the cell was still protected. So, it doesn't 'work' as a workaround. Also, Cor just confirmed that they intentionally (WHY???) removed the context menu, but that there is a bug in that there should be an option to unprotect the cell from the Table Menu. Now to go open a bug/feature request to bring back the most useful context menu choice for this... -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Unable to Protect/Unprotect cells in Libreoffice 5
On 8/27/2015 10:26 AM, Tanstaafl tansta...@libertytrek.org wrote: Now to go open a bug/feature request to bring back the most useful context menu choice for this... Done... bug 93714 https://bugs.documentfoundation.org/show_bug.cgi?id=93714 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Unable to Protect/Unprotect cells in Libreoffice 5
On 8/27/2015 8:51 AM, Mike Scott v...@scottsonline.org.uk wrote: On 27/08/15 13:30, Tanstaafl wrote: I just discovered - after updating a lot of our users - that apparently this is broken in the first 5.x release. There simply is no 'Cell' context menu option, and nothing in any of the Menus to allow me to unprotect the cell... Can anyone else confirm this? Yes. (5.0.0.5/mint) There's a main menu option Table|Protect Cells, but apparently no inverse. However, it seems you can R-click on the table in the navigator and unprotect the entire table. Clumsy. Clumsy is an understatement - and on top of that it doesn't even work. Unprotect is not an option, only Protect, so I tried Protecting the entire Table, then Unprotecting it, but the individual protected cell(s) remain protected... -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Unable to Protect/Unprotect cells in Libreoffice 5
On 27/08/15 14:01, Tanstaafl wrote: On 8/27/2015 8:51 AM, Mike Scott v...@scottsonline.org.uk wrote: On 27/08/15 13:30, Tanstaafl wrote: I just discovered - after updating a lot of our users - that apparently this is broken in the first 5.x release. There simply is no 'Cell' context menu option, and nothing in any of the Menus to allow me to unprotect the cell... Can anyone else confirm this? Yes. (5.0.0.5/mint) There's a main menu option Table|Protect Cells, but apparently no inverse. However, it seems you can R-click on the table in the navigator and unprotect the entire table. Clumsy. Clumsy is an understatement - and on top of that it doesn't even work. Unprotect is not an option, only Protect, so I tried Protecting the entire Table, then Unprotecting it, but the individual protected cell(s) remain protected... But I think you may have misread my note. If you R-click the table *in the navigator* (use F5) there's a Table|Unprotect option. It only appears though if the table does have a protected cell. At least here and I have just checked it. So to recap: pick a cell and use main menu Table | Protect Cells then to do a gross undo, F5 to show the Navigator if necessary, R-click on the table's name and select Table | Unprotect. As I said, clumsy. -- Mike Scott (unet2 at [deletethis] scottsonline.org.uk) Harlow Essex England -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Unable to Protect/Unprotect cells in Libreoffice 5
On 27/08/15 13:30, Tanstaafl wrote: Before I go open a bug for this, would appreciate if someone could confirm this... We have a ton of Writer Templates with Tables in them, that have protected cells (with formulas in them), that users sometimes unprotect (right-click on cell Cell Unprotect) to delete the formula and manually enter numbers. I just discovered - after updating a lot of our users - that apparently this is broken in the first 5.x release. There simply is no 'Cell' context menu option, and nothing in any of the Menus to allow me to unprotect the cell... Can anyone else confirm this? Yes. (5.0.0.5/mint) There's a main menu option Table|Protect Cells, but apparently no inverse. However, it seems you can R-click on the table in the navigator and unprotect the entire table. Clumsy. -- Mike Scott (unet2 at [deletethis] scottsonline.org.uk) Harlow Essex England -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Unable to Protect/Unprotect cells in Libreoffice 5
Before I go open a bug for this, would appreciate if someone could confirm this... We have a ton of Writer Templates with Tables in them, that have protected cells (with formulas in them), that users sometimes unprotect (right-click on cell Cell Unprotect) to delete the formula and manually enter numbers. I just discovered - after updating a lot of our users - that apparently this is broken in the first 5.x release. There simply is no 'Cell' context menu option, and nothing in any of the Menus to allow me to unprotect the cell... Can anyone else confirm this? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted