https://bugs.freedesktop.org/show_bug.cgi?id=70499
Priority: medium
Bug ID: 70499
Assignee: [email protected]
Summary: FILEOPEN Cannot select unprotected cells in XSLX sheet
with worksheet protection
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 4.1.1.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 87673
--> https://bugs.freedesktop.org/attachment.cgi?id=87673&action=edit
Spreadsheet showing problem
When a protected [No Password]excel (2007) worksheet having unprotected cells
is saved as xslx and opened in LibreOffice 4.1.2.3 it is not possible to select
the unprotected cells or to make any changes to protected cells.
The problem does not arise in 4.0.3 or if the worksheet is saved as xls.
How to recreate problem
Create sheet in excel 2007 range d4:g9 formatted as unprotected and rest of
cells protected. Fill with yellow to make it clear which cells are unprotected.
Save sheet as xslx.
Open sheet in LibreOffice 4.1.2 as released.
try and select yellow (unprotected) cell - not possible.
Select protected cell - it is possible, though it should not be since
protection set to allow selection of unprotected cells and not of protected
cells.
Workaround
None identified.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
