Bug 41544 - Compare spreadsheet with password protected file does not work
Summary: Compare spreadsheet with password protected file does not work
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.4.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 129628 129844 156187 (view as bug list)
Depends on:
Blocks: Password-Protected Document-Comparison
  Show dependency treegraph
 
Reported: 2011-10-06 21:47 UTC by Jean-Baptiste Faure
Modified: 2025-07-11 05:59 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Attachments
test writer file 1 (152.82 KB, application/vnd.oasis.opendocument.text)
2018-11-12 21:11 UTC, Drew Jensen
Details
test writer file 2, with minor changes (152.94 KB, application/vnd.oasis.opendocument.text)
2018-11-12 21:12 UTC, Drew Jensen
Details
Test a.ods (7.42 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-12-26 15:43 UTC, Timur
Details
Test a_mod.ods pass: test (11.54 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-12-26 15:44 UTC, Timur
Details
test package (25.46 KB, application/x-bzip)
2020-01-17 20:57 UTC, Julien Nabet
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jean-Baptiste Faure 2011-10-06 21:47:15 UTC
Problem description: If you compare a spreadsheet document with another which is
password protected, you are asked for the password but your password is refused event it is the correct one.
occur

Steps to reproduce:
1. open an existing spreadsheet document, eg a.ods
2. make some minor change and save this document as a new file with password,
eg. a_mod.ods
3. close a_mod.ods and open a.ods
4. menu Edit > Compare document
5. choose a_mod.ods
6. LibreOffice ask for the password. Type in the password.

Current behavior: error message saying that the password is not correct and the file can't be opened.

Expected behavior: "Accept or Reject Changes" is shown with the minor change
done at step 2.

Analogous bug, but not exactly the same, for Writer: #41493

Defect confirmed on MS-Windows-XP and Ubuntu.

Best regards. JBF
Comment 1 Markus Mohrhard 2011-10-07 05:04:16 UTC
Might be another problem of an missing change to SID_ENCRYPTIONDATA.
Comment 2 Björn Michaelsen 2011-12-23 12:32:33 UTC Comment hidden (obsolete)
Comment 3 Jean-Baptiste Faure 2011-12-26 01:23:13 UTC Comment hidden (obsolete)
Comment 4 QA Administrators 2015-04-19 03:20:03 UTC Comment hidden (obsolete)
Comment 5 Jean-Baptiste Faure 2015-04-25 15:49:51 UTC Comment hidden (obsolete)
Comment 6 QA Administrators 2016-09-20 09:32:06 UTC Comment hidden (obsolete)
Comment 7 Jean-Baptiste Faure 2016-09-24 19:41:13 UTC
Still reproducible in LibreOffice 5.2.3.0+ and master
Version: 5.3.0.0.alpha0+
Build ID: 9aef73aa452f86df8c760ca028914fc542909a58
Threads CPU : 4; Version de l'OS :Linux 4.4; UI Render : par défaut; 
Ubuntu_16.04_x86-64
Locale : fr-FR (fr_FR.UTF-8); Calc: group

Best regards. JBF
Comment 8 QA Administrators 2018-09-14 02:46:21 UTC Comment hidden (obsolete)
Comment 9 Timur 2018-09-14 08:38:38 UTC Comment hidden (obsolete)
Comment 10 Drew Jensen 2018-11-12 21:11:05 UTC Comment hidden (obsolete)
Comment 11 Drew Jensen 2018-11-12 21:11:57 UTC Comment hidden (obsolete)
Comment 12 Drew Jensen 2018-11-12 21:12:45 UTC Comment hidden (obsolete)
Comment 13 Drew Jensen 2018-11-12 22:24:19 UTC Comment hidden (obsolete)
Comment 14 Timur 2019-12-26 13:21:17 UTC
*** Bug 129628 has been marked as a duplicate of this bug. ***
Comment 15 Timur 2019-12-26 15:43:54 UTC
Created attachment 156784 [details]
Test a.ods
Comment 16 Timur 2019-12-26 15:44:52 UTC
Created attachment 156785 [details]
Test a_mod.ods pass: test

Repro 6.5+
Comment 17 Timur 2020-01-17 17:53:52 UTC
*** Bug 129844 has been marked as a duplicate of this bug. ***
Comment 18 Julien Nabet 2020-01-17 20:57:37 UTC
Created attachment 157237 [details]
test package

I created 2 test files (password = test1 and test2)
Also, I retrieved bt from CheckPasswd_Impl, see https://opengrok.libreoffice.org/xref/core/sfx2/source/appl/appopen.cxx?r=947fdbba#168

I expected LO go twice in this method, once per file, it called this method 3 times.
The 2 first times, there was a password dialog, the third time no (it doesn't pass the line "if( xInteractionHandler.is() )", line 218 of the same file.
Comment 19 QA Administrators 2022-01-17 03:37:46 UTC Comment hidden (obsolete)
Comment 20 Jean-Baptiste Faure 2022-01-19 09:30:58 UTC
Still reproducible in Version: 7.3.1.0.0+ / LibreOffice Community
Build ID: 71963c56241cecc77a2bff5434f0a1cf759d744f
CPU threads: 8; OS: Linux 5.13; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Ubuntu_20.04_x86-64
Calc: threaded

Best regards. JBF
Comment 21 Stéphane Guillou (stragu) 2023-07-07 11:40:32 UTC
*** Bug 156187 has been marked as a duplicate of this bug. ***
Comment 22 QA Administrators 2025-07-07 03:10:02 UTC
Dear Jean-Baptiste Faure,

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 with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

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)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug
Comment 23 Jean-Baptiste Faure 2025-07-11 05:59:04 UTC
Still reproducible with 

Version: 25.8.0.1.0+ (X86_64) / LibreOffice Community
Build ID: 34b35c4adb0176fc3b04f938f52485e531bd5a3a
CPU threads: 8; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Ubuntu_22.04_x86-64
Calc: threaded

and

Version: 25.2.6.0.0+ (X86_64) / LibreOffice Community
Build ID: 711ff1b95af0ea2f60f48b3bb4e78b9175d3d732
CPU threads: 8; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Ubuntu_22.04_x86-64
Calc: threaded

Best regards
JBF