Bug 99488 - Writer: Cells protected with Table-Protect Cells not protected when saving to DOC or DOCX
Summary: Writer: Cells protected with Table-Protect Cells not protected when saving to...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:doc, filter:docx
Depends on:
Blocks: DOCX-Tables DOC-Tables
  Show dependency treegraph
 
Reported: 2016-04-24 20:16 UTC by Tom Williams
Modified: 2020-04-22 00:53 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
The original ODT document with the protected table cells. (13.34 KB, application/vnd.oasis.opendocument.text)
2016-04-24 20:26 UTC, Tom Williams
Details
The original ODT document saved in MS Word 2003 (DOC) format (28.50 KB, application/msword)
2016-04-24 20:27 UTC, Tom Williams
Details
The original ODT document saved in MS Word 2007/2010 (DOCX) format (7.23 KB, application/vnd.openxmlformats-officedocument.wordprocessingml.document)
2016-04-24 20:27 UTC, Tom Williams
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Tom Williams 2016-04-24 20:16:32 UTC
When I save a document with a table that contains some protected cells in MS Word 2003 (DOC) or MS Word 2007/2010 (DOCX) format, the protected cells are not protected when the document is loaded in MS Word.

Expected result: Cells protected in Writer should remain protected when the document is saved in MS Word 2003 (DOC) and MS Word 2007/2010 (DOCX) formats.

Actual result:  Cells protected in Writer lose the protected "state" when the document is saved in MS Word 2003 (DOC) or MS Word 2007/2010 (DOCX) formats.

I created a table with some empty/blank columns to be used as "spacers".  To make sure the "spacer" columns contain no data, I mark them as being protected.  This is being lost when I save the document in MS Word 2003 (DOC) or MS Word 2007/2010 (DOCX) formats.

I'll attach sample documents for troubleshooting purposes.  Both LibreOffice Writer and MS Word 2007 are running on the same Windows XP SP3 system.

Thanks!
Comment 1 Tom Williams 2016-04-24 20:26:40 UTC
Created attachment 124615 [details]
The original ODT document with the protected table cells.
Comment 2 Tom Williams 2016-04-24 20:27:14 UTC
Created attachment 124616 [details]
The original ODT document saved in MS Word 2003 (DOC) format
Comment 3 Tom Williams 2016-04-24 20:27:39 UTC
Created attachment 124617 [details]
The original ODT document saved in MS Word 2007/2010 (DOCX) format
Comment 4 Terrence Enger 2016-04-25 19:55:26 UTC
I have reproduced the unprotected cells in but daily Linux bibisect
repository version 2016-04-25 and 43max bibisect repository version
oldest.  So, I am setting but status NEW.
Comment 5 QA Administrators 2018-10-02 02:56:34 UTC Comment hidden (obsolete)
Comment 6 Timur 2018-10-02 08:40:36 UTC
Repro 6.2+.
Comment 7 QA Administrators 2019-10-03 02:59:02 UTC Comment hidden (obsolete)
Comment 8 Tom Williams 2019-10-18 03:04:13 UTC
This issue still occurs in LibreOffice Writer 6.2.7.1 on Ubuntu Linux.  I'll see if I can try a newer version of LibreOffice, when I get a chance.  This is what I did:

1) Open the test ODT file in Writer
2) Save it as a DOCX file
3) Open the DOCX file in Writer
4) Try to enter values in a protected cell

Actual results:  The value I attempted to enter into a protected cell was successfully entered.

Expected results:  The value I attempted to enter into a protected call should NOT have been successfully entered.

When I perform these same steps with the original ODT file, I get an error popup indicating I can't enter data in a protected cell.
Comment 9 Justin L 2020-04-21 15:36:50 UTC
I don't see any option to protect cells in MICROSOFT WORD 2003 or 2016. I think for this report to be valid, you would have to produce a document in Word, and then have LO not be able to import or export it properly.

My guess (and my conclusion from a google search) is that LO has functionality that MSO doesn't have, so you loose that when saving in a proprietary format.
Comment 10 Tom Williams 2020-04-22 00:53:51 UTC
(In reply to Justin L from comment #9)
> I don't see any option to protect cells in MICROSOFT WORD 2003 or 2016. I
> think for this report to be valid, you would have to produce a document in
> Word, and then have LO not be able to import or export it properly.
> 
> My guess (and my conclusion from a google search) is that LO has
> functionality that MSO doesn't have, so you loose that when saving in a
> proprietary format.

Makes sense to me.  Thanks for the update!