Bug 121237 - FILEOPEN: Cannot open a password protected spreadsheet copied from one client to another (different os)
Summary: FILEOPEN: Cannot open a password protected spreadsheet copied from one client...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.1.2 release
Hardware: x86-64 (AMD64) OpenBSD
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Password-Protected
  Show dependency treegraph
 
Reported: 2018-11-07 11:04 UTC by ruggero.dallaglio
Modified: 2019-07-31 13:49 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Test file password protected (17 bytes, text/plain)
2018-11-12 09:14 UTC, ruggero.dallaglio
Details
Password protected spreadsheet. Password already attached as plaintext (11.93 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-11-20 12:31 UTC, ruggero.dallaglio
Details
Password protected ODS. Password: TestBSD (11.47 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-11-20 12:32 UTC, ruggero.dallaglio
Details

Note You need to log in before you can comment on or make changes to this bug.
Description ruggero.dallaglio 2018-11-07 11:04:52 UTC
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:
Comment 1 Xisco Faulí 2018-11-07 12:02:30 UTC Comment hidden (obsolete)
Comment 2 ruggero.dallaglio 2018-11-12 09:14:46 UTC
Created attachment 146556 [details]
Test file password protected
Comment 3 Joel Madero 2018-11-20 11:30:45 UTC Comment hidden (obsolete)
Comment 4 ruggero.dallaglio 2018-11-20 12:31:08 UTC
Created attachment 146823 [details]
Password protected spreadsheet. Password already attached as plaintext
Comment 5 ruggero.dallaglio 2018-11-20 12:32:18 UTC
Created attachment 146824 [details]
Password protected ODS. Password: TestBSD
Comment 6 ruggero.dallaglio 2018-11-20 12:33:44 UTC
Added 2 ods, one Windows.ods created on Windows os; the other OpenBSD created on OpenBSD platform.
Comment 7 ruggero.dallaglio 2018-11-20 12:37:16 UTC
Both opens correctly on os they've been created on. Both give "The password is incorrect. [...]" when opened on the other os.
Comment 8 Chen-Ku 2018-11-29 09:34:07 UTC
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
Comment 9 ruggero.dallaglio 2018-11-29 09:55:54 UTC
Reproduced on Windows 2012 R2
Comment 10 Xisco Faulí 2018-11-29 10:08:39 UTC
(In reply to ruggero.dallaglio from comment #9)
> Reproduced on Windows 2012 R2

which version of LibreOffice ? 6.1.3.2 ?
Comment 11 ruggero.dallaglio 2018-11-29 13:37:46 UTC
As written in the description "LO 6.1.1.2 on OpenBSD 6.4" and LO 6.0.7.3 on Windows 2012 R2
Comment 12 raal 2018-12-18 10:02:52 UTC
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
Comment 13 Xisco Faulí 2019-01-09 15:32:02 UTC
(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
Comment 14 ruggero.dallaglio 2019-01-10 11:25:06 UTC
(In reply to Xisco Faulí from comment #13)
[snip]
> Ruggero, Are you sure the password is TestBSD ?
> Setting to NEEDINFO

YES.
Comment 15 Xisco Faulí 2019-01-10 12:34:01 UTC
(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?
Comment 16 ruggero.dallaglio 2019-01-10 13:23:27 UTC
(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
Comment 17 Xisco Faulí 2019-07-31 12:02:55 UTC
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.
Comment 18 ruggero.dallaglio 2019-07-31 13:39:00 UTC
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
Comment 19 Xisco Faulí 2019-07-31 13:49:18 UTC
(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.