spreadsheet file with pivot table when saved in Microsoft Excel 97/2000/xp/2003 (.xls)with password, the pivot table will not work when re-open
Steps to reproduce:
1. create a simple spreadsheet with a pivot table either in MS Excel or LO Calc
2. save it as file type "Microsoft Excel 97/2000/xp/2003 (.xls) with the save with password option enable.
3. key in a password for the file and close it
4. re-open the file
Pivot table in .xls with password protection will not work upon re-open the file
Pivot table in .xls with password protection should work when re-open
Platform (if different from the browser):
Browser: Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.4 (KHTML, like Gecko) Chrome/22.0.1229.94 Safari/537.4
Confirmed on LO 22.214.171.124 Vista 32bit. I created the original spreadsheet in LO Calc.
To clarify the pivot table "not working"; after reopening the .xls, the pivot table sheet has only 2 cells on it:
A1 contains the text "Filter"
A3 contains the text "(empty)"
It should contain an actual pivot table.
The problem seems to be the specific combination of xls and password protection. I tried other combinations and could not reproduce the problem:
Microsoft Excel 97/2000/xp/2003 (.xls); password -> Doesn't work
Microsoft Excel 97/2000/xp/2003 (.xls); no password -> Works
ODF Spreadsheet (.ods); password -> Works
Excel 2007/2010 XML; no password -> Works
** Please read this message in its entirety before responding **
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present on a currently supported version of LibreOffice (4.3.5 or later): https://www.libreoffice.org/download/
If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System
Please DO NOT
Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case)
Thank you for your help!
-- The LibreOffice QA Team
Could not repro.
I used an example pivot table from here: http://www.ahuka.com/?page_id=911
In LibO, I did Tools - Protect document - Sheet. Saved as .xls. Nothing was lost.
Closing as WFM.
Win 8.1 32-bit
LibreOffice Version: 126.96.36.199.alpha0+
Build ID: 784d069cc1d9f1d6e6a4e543a278376ab483d1eb
TinderBox: Win-x86@62-TDF, Branch:MASTER, Time: 2015-01-25_23:07:36