[libreoffice-users] Unprotecting table cells
Hi! I've read many questions and answers regarding unprotection of table cells, however none of the replies I have seen worked in my case. When I try to edit a table cell text, I get the famous popup saying Readonly content cannot be changed. No modifications will be accepted. However, I can edit the content of some of the other cells in the same table. I do have read-write permission on the filesystem level. As mentioned, I can edit some other parts of the document. There is no unprotect option in the cell submenu on the right-click context menu in the cell. It only says No selection possible in greyed out text. Format - Sections is greyed out, so I have no access to any security settings there. The file properties shows that the document has no password protection. Nothing is activated on the Security tab there. One reply mentioned something about Design Mode, but I could not edit the text after activating that either. I'm using Libreoffice 3.4.5 OOO340m1 (Build:502) on Debian Sid Linux. Any ideas? This is often a problem for me when filling out downloadable forms with Libreoffice. Does it have some sort of Make everything editable option? That would have saved me many hours... Best regards, Torquil Sørensen -- For unsubscribe instructions e-mail to: users+h...@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] Unprotecting table cells
On 28/02/12 14:47, Brad Rogers wrote: On Tue, 28 Feb 2012 14:18:42 +0100 Torquil Macdonald Sørensentorq...@gmail.com wrote: Hello Torquil, Any ideas? This is often a problem for me when filling out downloadable forms with Libreoffice. Does it have some sort of Make everything editable option? That would have saved me many hours... It might be Tools menu -- Protect Document... Hi Brad! I don't seem to have that menu item. Thanks anyway! :-) For clarification, I'm talking about a table in a Libreoffice Writer document. Best regards Torquil Sørensen -- For unsubscribe instructions e-mail to: users+h...@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] Re: Unprotecting table cells
On 28/02/12 14:48, Andreas Säger wrote: This is the same in OpenOffice.org, LibreOffice, Excel, Gnumeric and other spreadsheet programs. menu:ToolsProtectionSheet=OFF opens the locks of all the cells on that sheet having a lock attached. Now you can edit any cell. FormatCellsTab:Protection allows you to add or remove a lock to selected cells. Cells without a lock remain editable when sheet protection closes all cell locks. By default all cells have a lock, so the sheet protection locks all cell. You have to remove the locks from those cells you want to keep editable. Oops, I'm talking about a table in the Libreoffice Writer program. Not a spreadsheet. As I understand it, your explanation is only in the context of a spreadsheet? As far as I can see, I cannot follow your procedure in Writer. But thanks anyway, and sorry for causing confusion! Best regard, Torquil Sørensen -- For unsubscribe instructions e-mail to: users+h...@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] Unprotecting table cells
On 28/02/12 15:40, Brad Rogers wrote: On Tue, 28 Feb 2012 15:17:35 +0100 Torquil Macdonald Sørensentorq...@gmail.com wrote: Hello Torquil, I don't seem to have that menu item. Thanks anyway! :-) For clarification, I'm talking about a table in a Libreoffice Writer document. Ah, I didn't realise. Yes, my, and Andreas' solutions are for Calc. I hope my problem is not the same as this: http://user.services.openoffice.org/en/forum/viewtopic.php?f=7t=19668 That one seems to be unsolvable without having access to MS Word: As of this moment the bug still exists in OO 3.1.1 for Windows, I haven't checked my Linux or Mac systems yet. OO Writer honours the protection status of a document but doesn't have any way of changing it. If a document has been locked in MS Word there is no way to unlock it without passing it through a copy of Word. My document was originally a *.doc, probably created in MS Word. When I saved my first modified version, I let Libreoffice save it as an ODT-file. Best regards, Torquil Sørensen -- For unsubscribe instructions e-mail to: users+h...@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] Re: Unprotecting table cells
On 28/02/12 14:18, Torquil Macdonald Sørensen wrote: Hi! I've read many questions and answers regarding unprotection of table cells, however none of the replies I have seen worked in my case. When I try to edit a table cell text, I get the famous popup saying Readonly content cannot be changed. No modifications will be accepted. However, I can edit the content of some of the other cells in the same table. I do have read-write permission on the filesystem level. As mentioned, I can edit some other parts of the document. There is no unprotect option in the cell submenu on the right-click context menu in the cell. It only says No selection possible in greyed out text. Format - Sections is greyed out, so I have no access to any security settings there. The file properties shows that the document has no password protection. Nothing is activated on the Security tab there. One reply mentioned something about Design Mode, but I could not edit the text after activating that either. I'm using Libreoffice 3.4.5 OOO340m1 (Build:502) on Debian Sid Linux. Any ideas? This is often a problem for me when filling out downloadable forms with Libreoffice. Does it have some sort of Make everything editable option? That would have saved me many hours... Best regards, Torquil Sørensen Hi, me! Abiword was able to edit the read-only parts of the document, so I'm happy now :-) I still welcome suggestions here on how to achieve this in Libreoffice Writer. Best regards Torquil -- For unsubscribe instructions e-mail to: users+h...@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
