| Summary: | FILESAVE: Protected cell get Unprotected post save with option "User Microsoft Excel 2007/2010 XML format" | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Ashish Patel <ashish.nfdl> |
| Component: | Spreadsheet | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED DUPLICATE | QA Contact: | |
| Severity: | major | ||
| Priority: | high | CC: | ashish.nfdl, corrado.viazzi, ign_christian |
| Version: | 4.0.1.2 release | ||
| Hardware: | x86 (IA32) | ||
| OS: | Windows (All) | ||
| See Also: | https://bugs.freedesktop.org/show_bug.cgi?id=60718 | ||
| Whiteboard: | BSA | ||
| i915 platform: | i915 features: | ||
| Attachments: | TestCase | ||
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 *** |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.
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