Bug 68425 - Spreadsheet with protected cells does export nicely to .xls, but not to .xlsx
Summary: Spreadsheet with protected cells does export nicely to .xls, but not to .xlsx
Status: RESOLVED DUPLICATE of bug 64753
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.0.4 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-08-22 11:20 UTC by Gerry
Modified: 2013-08-26 13:00 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
missing-export-of-protected-cells.ods (17.27 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-08-22 11:21 UTC, Gerry
Details
missing-export-of-protected-cells.xlsx (7.63 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2013-08-22 11:21 UTC, Gerry
Details
missing-export-of-protected-cells.xls (27.50 KB, application/x-download)
2013-08-22 11:22 UTC, Gerry
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gerry 2013-08-22 11:20:36 UTC
The attached spreadsheet (missing-export-of-protected-cells.ods) contains protected cells. All the cells where you see "#REF!" are protected and therefore cannot be changed unless the user unprotects the sheet. 
However, there is a problem with the export of this file:

This sheet exports nicely to .xls including the protected cells (attachment missing-export-of-protected-cells.xls).
However, it does not export nicely to .xlsx. The cell protection is lost and the user can edit the cells (which should not be the case). (attachment missing-export-of-protected-cells.xlsx )

I assume that protected cells are not handled properly in the XLSX-Export. Please add support for protected cells in .xlsx-files.

Files tested in MS Office 2010
Comment 1 Gerry 2013-08-22 11:21:29 UTC
Created attachment 84446 [details]
missing-export-of-protected-cells.ods
Comment 2 Gerry 2013-08-22 11:21:46 UTC
Created attachment 84447 [details]
missing-export-of-protected-cells.xlsx
Comment 3 Gerry 2013-08-22 11:22:02 UTC
Created attachment 84448 [details]
missing-export-of-protected-cells.xls
Comment 4 ign_christian 2013-08-26 13:00:00 UTC
Hi..I guess what you meant was filesave problem with sheet protection in XLSX.

*** This bug has been marked as a duplicate of bug 64753 ***