https://bugs.freedesktop.org/show_bug.cgi?id=68425
Priority: medium
Bug ID: 68425
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: Spreadsheet with protected cells does export nicely to
.xls, but not to .xlsx
Severity: normal
Classification: Unclassified
OS: All
Reporter: gerry.trep...@googlemail.com
Hardware: Other
Status: UNCONFIRMED
Version: 4.1.0.4 release
Component: Spreadsheet
Product: LibreOffice
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
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
