https://bugs.documentfoundation.org/show_bug.cgi?id=101042
--- Comment #4 from Kuno Meyer <kuno.me...@gmx.ch> ---
With Excel 2010 on Windows
--------------------------
- setting workbook protection to "structure" alters:
/xl/workbooks.xml: <workbookProtection lockStructure="1"/> is added
- setting workbook protection to "window" alters:
/xl/workbooks.xml: <workbookProtection lockWindows="1"/> is added
/xl/worksheets/sheet1.xml: windowProtection="1" to the <sheetView> element
/xl/worksheets/sheet2.xml: windowProtection="1" to the <sheetView> element
/xl/worksheets/sheet3.xml: windowProtection="1" to the <sheetView> element
- activating "View > Freeze Panes" alters:
/xl/worksheets/sheet1.xml:
- one <pane> and 3 <section> subelements (none yet there) to the
<sheetView> element
- opening the "window" workbook-protected file in Excel 2011 on OSX exactly
results in the described behaviour a)-c).
With LO 5.1.4, started from scratch:
-------------
- activating "View > Freeze Rows and Columns" alters:
/xl/worksheets/sheet1.xml:
- windowProtection="true" to the <sheetView> element
- one <pane> and 3 additional <section> subelements (one already there)
to the <sheetView> element
Conclusion
----------
- LO really should not set windowProtection="true" in sheet1.xml when panes are
frozen. Excel does not do that either. This is what this bug report is about.
- Excel/Win and Excel/OSX are insofar differently implemented as Excel/Win
seems to look at <workbookProtection lockWindows="1"/> in workbook.xml (and
does not assume workbook protection if it is missing) whereas Excel/OSX does
not (and just follows the windowProtection flag in sheet1.xml).
- Excel uses 0/1 for boolean values, LO true/false. But this might be OK by
definition of the file format.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs