[Libreoffice-bugs] [Bug 114221] Calc has changed the file password

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=114221

--- Comment #10 from francis-maryl...@wanadoo.fr ---
You are right, it works great when saving the file with "Save as". I am able to
open it again.
What about the file which is corrupted (CA2017)? I really would like to open it
again. Do you have a way to recover it?
Thanks very much to you guys.
I really appreciate your help.
Francis

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114221] Calc has changed the file password

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=114221

--- Comment #9 from Aron Budea  ---
Created attachment 138257
  --> https://bugs.documentfoundation.org/attachment.cgi?id=138257=edit
Sample XLS created in Excel (password: 1234)

Apparently it's easy to reproduce, here's a minimal sample created in Excel
2013, password is 1234, simply open, save and try to reopen.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114221] Calc has changed the file password

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=114221

Aron Budea  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||caol...@redhat.com
Version|5.3.7.2 release |5.3.0.3 release
 Ever confirmed|0   |1
 OS|Windows (All)   |All
   Severity|normal  |major

--- Comment #8 from Aron Budea  ---
Thanks for the sample, Francis!
Reproduced using 6.0beta1 & 5.3.0.3 / Windows 7. Assuming the bug isn't OS
dependent, unless claimed otherwise.
Also, it only occurs if you save the file, not when you do Save As.

The import of encryption was added with the commit referenced below. Caolán,
could you please check what is going wrong here?

https://cgit.freedesktop.org/libreoffice/core/commit/?id=1473ce030314027c01c98f513407ed0897328585
author  Caolán McNamara 2016-10-20 16:07:11
+0100
committer   Caolán McNamara 2016-10-21 11:16:11
+0100

implement CryptoAPI RC4+SHA1 encryption scheme for xls import

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114221] Calc has changed the file password

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=114221

--- Comment #7 from francis-maryl...@wanadoo.fr ---
Please find 2 files attached :
 - The first one (CA2016 OK.xls) with password (6061)which is correct
 - The second one (CA2017 with bug.xls)wich is corrupted (Same initial password
6061)
Both files are similar, one for year 2016 and one for year 2017

With the first one and after having done a copy (as recommended by you), I can
reproduce the bug. Steps : I open the file with CALC, type the password, may do
any change in the file, save the file. Then when I try to open it again with
either CALC or EXCEL, I get the error "Password is incorrect. Impossible to
open the file"

I have no correct copy of the second one. It is impossible to open it with
either software. I get the same error message.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114221] Calc has changed the file password

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=114221

--- Comment #6 from francis-maryl...@wanadoo.fr ---
Created attachment 138255
  --> https://bugs.documentfoundation.org/attachment.cgi?id=138255=edit
File with bug - Password not found

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114221] Calc has changed the file password

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=114221

--- Comment #5 from francis-maryl...@wanadoo.fr ---
Created attachment 138254
  --> https://bugs.documentfoundation.org/attachment.cgi?id=138254=edit
Similar file - No issue

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114221] Calc has changed the file password

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=114221

--- Comment #4 from Buovjaga  ---
What about the original .xls file, you don't have it anymore? Anyway, we would
require the original file + original password to confirm the bug.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114221] Calc has changed the file password

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=114221

Aron Budea  changed:

   What|Removed |Added

   Keywords||dataLoss
 Blocks||108914, 109072


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108914
[Bug 108914] [META] Password protected file bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=109072
[Bug 109072] [META] XLS (binary) format bug tracker
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114221] Calc has changed the file password

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=114221

francis-maryl...@wanadoo.fr changed:

   What|Removed |Added

 CC||francis-maryl...@wanadoo.fr

--- Comment #3 from francis-maryl...@wanadoo.fr ---
Comment on attachment 138221
  --> https://bugs.documentfoundation.org/attachment.cgi?id=138221
Snapshot of the requested password to open file

Hello,

Thanks very much for your help.


Question : Does it ask the password upon file open?

Answer : Yes, it asks the password upon file open. Please see attached file


Yes, next time I know I should save the file under another name. I thought it
was possible to open, edit, save .xls or .xlsx with any software (Office or
LibreOffice).

For information, initial Excel password was a rather simple password built with
4 numbers (1 through 9). Now I have no idea how many digits and which type of
caracters are in the new password assigned by CALC.


I have already had the file scanned by the tool : Advanced Office 97 Password
Recovery. Although I set this tool o scan all types of caracteres from 1 up to
5 digits, it failed to find out the password.


I look forward to hearing from you.

Francis HERBERT

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114221] Calc has changed the file password

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=114221

--- Comment #2 from francis-maryl...@wanadoo.fr ---
Created attachment 138221
  --> https://bugs.documentfoundation.org/attachment.cgi?id=138221=edit
Snapshot of the requested password to open file

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 114221] Calc has changed the file password

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=114221

Buovjaga  changed:

   What|Removed |Added

 CC||todven...@suomi24.fi

--- Comment #1 from Buovjaga  ---
Does it ask the password upon file open? Or is only a sheet protected?
In any case, you have to use a password cracking tool, but we just need to find
out which one.

In the future, never replace a file in the way you did, but save it under
another name.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs