Bug 63608 - FILESAVE: Protected cell get Unprotected post save with option "User Microsoft Excel 2007/2010 XML format"
Summary: FILESAVE: Protected cell get Unprotected post save with option "User Microsof...
Status: RESOLVED DUPLICATE of bug 64753
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.1.2 release
Hardware: x86 (IA32) Windows (All)
: high major
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2013-04-16 14:04 UTC by Ashish Patel
Modified: 2013-05-29 09:48 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
TestCase (312.67 KB, application/vnd.openxmlformats-officedocument.wordprocessingml.document)
2013-04-17 05:42 UTC, Ashish Patel
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Ashish Patel 2013-04-16 14:04:40 UTC
Problem description: Password protected cell are getting editable post save with option "User Microsoft Excel 2007/2010 XML format" and cell width get increased. Please find all steps and xlsx file in attached docx file.

Steps to reproduce:
1. Sheet having some columns are non-editable and some are editable columns.
2. Do some change and save with option "User Microsoft Excel 2007/2010 XML format" and close the file
3. Open saved file, All Non-Editable columns now get editable. It should be non-editable. and Cell Border width now get increased.

Current behavior: 1. Cell border width get increased and 2. Cell should be non-editable

Expected behavior: Cell width should be same as like before saved. Cell should be non-editable as like before saved.

              
Operating System: Windows XP
Version: 4.0.1.2 release
Comment 1 Ashish Patel 2013-04-17 05:42:27 UTC
Created attachment 78121 [details]
TestCase
Comment 2 ign_christian 2013-05-18 09:25:03 UTC
Could you attach sample worksheet & some brief explanation how to test?

Possibly same as Bug 60718
Comment 3 ign_christian 2013-05-18 09:30:04 UTC
I'm sorry, Bug 60718 focus on VLOOKUP function but probably related to Protect Sheet which discussed here.

About cell borders, you could see & comment on Bug 58356 , Bug 52578 , maybe related too with Bug 53287
Comment 4 Ashish Patel 2013-05-28 05:13:17 UTC
Dear Christian,

Thank you for looking into this bug. Given information would be helpful for us. 
Moreover for the test case or other details. I already attached document (TestCase) where you can get steps that would be useful for you and also I have liked xlsx file in the document.

Let me know if you required more input from us.
You can also reach me at nikunjmulani@gmail.com

Thanks,
Nikun and Ashish
Comment 5 ign_christian 2013-05-28 05:45:13 UTC
Hi Ashish

I mean your sample spreadsheet (not screenshot as shown on your attached doc), so others can easily test & check it.

Guess that there is 2 issues:
1. Cell borders -> see comment 3
2. Cell protection -> see Bug 64753 (same problem?)

We only focus on 1 issue per 1 bug report. So if you think it's the same as stated above, you can comment on related bug(s) & mark this bug as Duplicate.
Comment 6 Ashish Patel 2013-05-29 09:04:48 UTC
Thanks Christian, agree.

1. Cell borders -> bug#52578 , bug#53287. should solve the issue. Will verify once these are resolved and if not we will reopen this with more granular test cases.

2. Cell protection -> Though this bug was raised earlier than bug#64753, however as recommended by you we are closing this and marking as duplicate. We will verify once this is resolved and if not we will reopen with more granular test cases.

*** This bug has been marked as a duplicate of bug 64753 ***
Comment 7 ign_christian 2013-05-29 09:48:05 UTC
You're welcome Ashish. I've already been opened Bug 64753 before realized there is a similar issue reported by you :) 
And that bug already confirmed by QA & set to MAB3.6

Please REOPENED this bug if this problem still occur after that bug fixed.