Description: A password protected spreadsheet, created with version 5.* on a Windows os, cannot be opened with LO 6.1.1.2 on OpenBSD 6.4. Thought it'd be a version issue, so I removed the password, upgraded LO to 6.0.7.3, then re-set a password with a Windows os. Still cannot open file in OpenBSD. In OpenBSD changed file extension into .zip, opened it and opened manifest.xml which contains referrals to sha256-1k and aes256-cbc that should be managed by OS. Steps to Reproduce: 1.Open a password protected spreadsheet 2. 3. Actual Results: Pop-up: "Enter password" (I entered the correct password, tried to type it in a different application) Pop-up: "The password is incorrect. The file cannot be opened" Expected Results: File opened. Reproducible: Always User Profile Reset: No Additional Info:
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Created attachment 146556 [details] Test file password protected
Please attach a password protected document. That attachment is just a txt file with a password. Mark as UNCONFIRMED once the document is attached. Thank you.
Created attachment 146823 [details] Password protected spreadsheet. Password already attached as plaintext
Created attachment 146824 [details] Password protected ODS. Password: TestBSD
Added 2 ods, one Windows.ods created on Windows os; the other OpenBSD created on OpenBSD platform.
Both opens correctly on os they've been created on. Both give "The password is incorrect. [...]" when opened on the other os.
no reproducible on 版本：6.1.3.2 (x64) 組建 ID：86daf60bf00efa86ad547e59e09d6bb77c699acb CPU 執行緒：12; OS：Windows 10.0; UI 算繪：GL; 語言地區：zh-TW (zh_TW); Calc: CL i type the password and it can be opened
Reproduced on Windows 2012 R2
(In reply to ruggero.dallaglio from comment #9) > Reproduced on Windows 2012 R2 which version of LibreOffice ? 6.1.3.2 ?
As written in the description "LO 6.1.1.2 on OpenBSD 6.4" and LO 6.0.7.3 on Windows 2012 R2
I can confirm with Version: 6.3.0.0.alpha0+ Build ID: 2b6bd096f5bd9d250e4590d7150190086ad282b2 CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; and Version 4.0.0.3 (Build ID: 7545bee9c2a0782548772a21bc84a9dcc583b89) File OpenBSD.ods -> password: TestBSD -> error The password is incorrect. The file cannot be opened
(In reply to raal from comment #12) > I can confirm with Version: 6.3.0.0.alpha0+ > Build ID: 2b6bd096f5bd9d250e4590d7150190086ad282b2 > CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; > and Version 4.0.0.3 (Build ID: 7545bee9c2a0782548772a21bc84a9dcc583b89) > > File OpenBSD.ods -> password: TestBSD -> error The password is incorrect. > The file cannot be opened This issue has been incorrectly confirmed... I get the incorrect password error in Version: 6.3.0.0.alpha0+ Build ID: 54515a6a01a372729bf8a7f9e992c51f214ec9a6 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US Calc: threaded Versión: 6.2.0.1 Id. de compilación: 0412ee99e862f384c1106d0841a950c4cfaa9df1 Subprocs. CPU: 1; SO: Windows 6.1; Repres. IU: predet.; VCL: win; Configuración regional: es-ES (es_ES); Idioma de IU: es-ES Calc: threaded and Version: 6.3.0.0.alpha0+ Build ID: a5aeb6b52327565523be406e0082fe0122c48e03 CPU threads: 16; OS: Windows 6.3; UI render: default; VCL: win; Locale: en-GB (en_GB); UI-Language: en-US Calc: threaded so this could be only confirmed if it can be open on Win but not on Linux, which is not the case, right now, I can't open it in any OS, which indicates the password is incorrect. Ruggero, Are you sure the password is TestBSD ? Setting to NEEDINFO
(In reply to Xisco Faulí from comment #13) [snip] > Ruggero, Are you sure the password is TestBSD ? > Setting to NEEDINFO YES.
(In reply to ruggero.dallaglio from comment #14) > (In reply to Xisco Faulí from comment #13) > [snip] > > Ruggero, Are you sure the password is TestBSD ? > > Setting to NEEDINFO > > YES. So this file was created in OpenBSD?
(In reply to Xisco Faulí from comment #15) > (In reply to ruggero.dallaglio from comment #14) > > (In reply to Xisco Faulí from comment #13) > > [snip] > > > Ruggero, Are you sure the password is TestBSD ? > > > Setting to NEEDINFO > > > > YES. > > So this file was created in OpenBSD? yep
A new major release of LibreOffice is available since this bug was reported. Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
Works both ways (create a password proteccted file from one OS and open it from the other); maybe a little slow while opening in OpenBSD. OpenBSD 6.5 + LO 6.2.2.2 Windows 2012 R2 + LO 6.2.5.2 x64
(In reply to ruggero.dallaglio from comment #18) > Works both ways (create a password proteccted file from one OS and open it > from the other); maybe a little slow while opening in OpenBSD. > OpenBSD 6.5 + LO 6.2.2.2 > Windows 2012 R2 + LO 6.2.5.2 x64 Thanks for retesting with the latest version. Setting to RESOLVED WORKSFORME as the commit fixing this issue hasn't been identified.