[Libreoffice-bugs] [Bug 101042] XLSX file with a frozen column causes Excel on OSX to degrade

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=101042

Bartosz  changed:

   What|Removed |Added

   Assignee|libreoffice-b...@lists.free |gan...@poczta.onet.pl
   |desktop.org |

-- 
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

[Libreoffice-bugs] [Bug 101042] XLSX file with a frozen column causes Excel on OSX to degrade

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=101042

--- Comment #4 from Kuno Meyer  ---
With Excel 2010 on Windows
--

- setting workbook protection to "structure" alters:
/xl/workbooks.xml:  is added

- setting workbook protection to "window" alters:
/xl/workbooks.xml:  is added
/xl/worksheets/sheet1.xml: windowProtection="1" to the  element
/xl/worksheets/sheet2.xml: windowProtection="1" to the  element
/xl/worksheets/sheet3.xml: windowProtection="1" to the  element

- activating "View > Freeze Panes" alters:
/xl/worksheets/sheet1.xml:
- one  and 3  subelements (none yet there) to the
 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  element
- one  and 3 additional  subelements (one already there)
to the  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  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

[Libreoffice-bugs] [Bug 101042] XLSX file with a frozen column causes Excel on OSX to degrade

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=101042

Aron Budea  changed:

   What|Removed |Added

   Keywords||filter:xlsx
 Whiteboard||interoperability

-- 
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

[Libreoffice-bugs] [Bug 101042] XLSX file with a frozen column causes Excel on OSX to degrade

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=101042

Bartosz  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1

-- 
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

[Libreoffice-bugs] [Bug 101042] XLSX file with a frozen column causes Excel on OSX to degrade

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=101042

--- Comment #3 from Bartosz  ---
Created attachment 126351
  --> https://bugs.documentfoundation.org/attachment.cgi?id=126351=edit
File created with LO 5.1.4 with manual fix (remove windowProtection="true")

-- 
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

[Libreoffice-bugs] [Bug 101042] XLSX file with a frozen column causes Excel on OSX to degrade

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=101042

--- Comment #2 from Kuno Meyer  ---
Attachment 126330 indeed has workbook protection flag set. I did not set this,
so this might indeed be bug 90975, despite of the fact that that bug is
RESOLVED WORKSFORME. 

According to
https://support.office.com/en-us/article/Protect-a-workbook-7e365a4d-3e89-4616-84ca-1931257c1517,
there are multiple types of workbook protection: a) structure protection, b)
window protection. According to that link, Window protection has been dropped
with MSO 2013, but what I observe here with Excel 2010 on Windows, it comes
quite close to what I remember having observed with Excel 2011 on OSX.

More investigation needed at home this evening.

-- 
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

[Libreoffice-bugs] [Bug 101042] XLSX file with a frozen column causes Excel on OSX to degrade

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=101042

Aron Budea  changed:

   What|Removed |Added

 CC||ba...@caesar.elte.hu
   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=10
   ||0014,
   ||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=90
   ||975

--- Comment #1 from Aron Budea  ---
Someone had a similar issue in bug 100014 (and bug 90975 was also similar).
Is Protect Workbook set in Excel with this file, and does unsetting it fixes
the incorrect behavior?

-- 
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