Bug 90975 - FILESAVE: if spreadsheet is saved with a window freeze, sheet protection is triggered in Excel
Summary: FILESAVE: if spreadsheet is saved with a window freeze, sheet protection is t...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-04-30 16:17 UTC by js54434
Modified: 2016-07-21 04:37 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description js54434 2015-04-30 16:17:25 UTC
To reproduce:
- Open a new worksheet in Calc, add window splitting somewhere via Window>Split. 
- Save as a .xlsx file. 
- When the worksheet is opened in Excel 2011, sheet protection will be enabled, meaning the window can't be moved or resized until "Unprotect Workbook" is selected in the Excel menus.
Comment 1 js54434 2015-04-30 16:21:16 UTC
(In reply to js54434 from comment #0)
> To reproduce:
> - Open a new worksheet in Calc, add window splitting somewhere via
> Window>Split. 
> - Save as a .xlsx file. 
> - When the worksheet is opened in Excel 2011, sheet protection will be
> enabled, meaning the window can't be moved or resized until "Unprotect
> Workbook" is selected in the Excel menus.

Sorry, that should be Window>Freeze. Window>Split doesn't trigger the problem.
Comment 2 raal 2015-05-04 06:15:02 UTC
With LO 4.4.2, win7 & excel2010: when opening xlsx file in excel, I can write into the file, but I see "Protect workbook" set on.
Comment 3 Alex Thurgood 2015-05-04 09:47:12 UTC
If I use LO master 500 alpha dev, and Excel 15.9, the problem does not appear.
Comment 4 Alex Thurgood 2015-05-04 09:49:47 UTC
I also see no problem when creating the file in LO5 alpha and opening the xlsx in Excel 14.4.9 in Office for Mac 2011
Comment 5 Buovjaga 2015-05-12 13:09:51 UTC
In MSO 2013, I can move the window and input stuff just fine. I don't see the workbook as protected.

Saved with a bit older master:
Version: 5.0.0.0.alpha1+
Build ID: f0edb677f09ad338e22ac3b5d91497b4479e0b3c
TinderBox: Win-x86@39, Branch:master, Time: 2015-04-27_00:34:58
Locale: fi_FI
Comment 6 Yogesh Bharate 2015-05-26 09:56:42 UTC
This is non -reproducible on windows build.

Buid ID :
Version: 5.0.0.0.alpha1+ (x64)
Build ID: 9d0c51daea67104349cac26de9839afa8baeb099
TinderBox: Win-x86_64@42, Branch:master, Time: 2015-05-15_23:59:35
Locale: en-IN (en_IN)