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
Created attachment 78121 [details] TestCase
Could you attach sample worksheet & some brief explanation how to test? Possibly same as Bug 60718
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
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
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.
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 ***
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.