Bug 65383 - Correct password doesn't open protected spreadsheet on Linux LO 4.1.0.0
Summary: Correct password doesn't open protected spreadsheet on Linux LO 4.1.0.0
Status: RESOLVED DUPLICATE of bug 64916
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.0.0.beta1
Hardware: All Linux (All)
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 67070 (view as bug list)
Depends on:
Blocks:
 
Reported: 2013-06-05 01:51 UTC by Marcelo Soares
Modified: 2013-08-06 15:26 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments
Password spreadsheet (10.08 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-06-14 12:16 UTC, Chris
Details
attachment-13351-0.html (458 bytes, text/html)
2013-06-16 11:55 UTC, Marcelo Soares
Details
attachment-13351-1.dat (1 bytes, multipart/alternative)
2013-06-16 11:55 UTC, Marcelo Soares
Details
MMS_Files.zip (905.38 KB, application/zip)
2013-06-16 11:55 UTC, Marcelo Soares
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Marcelo Soares 2013-06-05 01:51:25 UTC
Gentlemen, good evening.

I have a control sheet which many use in my day-to-day which I protect with a password. I'm doing tests with the new version of LibreOffice 4.1.0.0 (beta), and I am not able to open my file because Calc 4.1.0.0 says my password is wrong, whereas in previous versions I can not open normally. I have written including the password in Gedit and copied and pasted it but still says it is wrong.
Could analyze this problem? Grateful.

Sincerely,

Marcelo Soares
Comment 1 Chris 2013-06-09 23:51:48 UTC
Confirm in 4.1.0.0.beta2.
Comment 2 Jacques Guilleron 2013-06-11 18:07:49 UTC
Hello Marcello,

Can you provide a small document with this behaviour, but without apppreciable datas, please?

Thank you,

Jacques Guilleron
Comment 3 Chris 2013-06-14 12:16:22 UTC
Created attachment 80808 [details]
Password spreadsheet

Try to open this spreadsheet in LO 4.1 beta2 and type password: 4321

Calc display box information with "wrong password".
Comment 4 Jacques Guilleron 2013-06-14 13:23:56 UTC
Hi Chris,

I get it, but I wait for Marcello's answer for C5.

LO 4.2.0.0.alpha0+ (master version near by LO 4.1.0.0.beta2)
Build ID: c36348f20c4fcb6ae1acb0fd06c19edfa9fb108
Windows 7 Home Premium

Jacques Guilleron
Comment 5 Marcelo Soares 2013-06-14 14:27:54 UTC
I'm at work right now, so you're at home I send you my spreadsheet
that presents the same problem cited by: Comment # 3 on bug 65383 from
Chris:

Created attachment 80808 [details]
Password spreadsheet

Try to open this spreadsheet in LO 4.1 beta2 and type password: 4321

Calc display box information with "wrong password".

Marcelo Soares
Consultor Imobiliário - CRECI nº 8457
(71) 9265-8740


2013/6/14  <bugzilla-daemon@freedesktop.org>:
> Comment # 4 on bug 65383 from Jacques Guilleron
>
> Hi Chris,
>
> I get it, but I wait for Marcello's answer for C5.
>
> LO 4.2.0.0.alpha0+ (master version near by LO 4.1.0.0.beta2)
> Build ID: c36348f20c4fcb6ae1acb0fd06c19edfa9fb108
> Windows 7 Home Premium
>
> Jacques Guilleron
>
> ________________________________
> You are receiving this mail because:
>
> You reported the bug.
Comment 6 Jacques Guilleron 2013-06-14 16:50:18 UTC
Hi Mercello,

When you want, you send it.

Jacques Guilleron
Comment 7 Jacques Guilleron 2013-06-16 08:51:09 UTC
Hi Marcello,

No issue for me to open your spreadsheet. 
Which Linux distribution and version are you using?
Can you or not open the Password spreadsheet proposed by Chris?

@ Chris: Precise too which distribution and version you are using.

Thank you,

Jacques Guilleron
Comment 8 Marcelo Soares 2013-06-16 11:55:25 UTC
Created attachment 80904 [details]
attachment-13351-0.html

Go file for analise.
Password is: 368210.

Atc,

Marcelo Soares
Tel.: (71) 9265-8740

Em 14/06/2013 13:50,
<bugzilla-daemon@freedesktop.org>
escreveu:Comment # 6 on bug 65383 from Jacques Guilleron

Hi Mercello, When you want, you send it.

Jacques Guilleron

You are receiving this mail because:You reported the bug.
Comment 9 Marcelo Soares 2013-06-16 11:55:26 UTC
Created attachment 80905 [details]
attachment-13351-1.dat
Comment 10 Marcelo Soares 2013-06-16 11:55:26 UTC
Created attachment 80906 [details]
MMS_Files.zip
Comment 11 Jacques Guilleron 2013-06-16 13:45:34 UTC
Hi Marcelo,

I can open without problem your spreadsheet, but I work with Windows 7. Can you also provide the name and number version of your Linux ditribution? So someone with the same distribution will can test.

Thank you very much for your collaboration,

Jacques Guilleron
Comment 12 Marcelo Soares 2013-06-16 14:29:01 UTC
Hello,

I'm on Linux Mint 15 (Olivia) and Ubuntu 13.04.
Atc,

Marcelo Soares
Tel.: (71) 9265-8740
Em 16/06/2013 10:45, <bugzilla-daemon@freedesktop.org> escreveu:

>   *Comment # 11 <https://bugs.freedesktop.org/show_bug.cgi?id=65383#c11>on bug
> 65383 <https://bugs.freedesktop.org/show_bug.cgi?id=65383> from Jacques
> Guilleron <guilleron29@aol.com> *
>
> Hi Marcelo,
>
> I can open without problem your spreadsheet, but I work with Windows 7. Can you
> also provide the name and number version of your Linux ditribution? So someone
> with the same distribution will can test.
>
> Thank you very much for your collaboration,
>
> Jacques Guilleron
>
>  ------------------------------
> You are receiving this mail because:
>
>    - You reported the bug.
>
>
Comment 13 Jacques Guilleron 2013-06-17 17:46:44 UTC
Set this report to NEW. We have enough information.

Jacques Guilleron
Comment 14 Marcelo Soares 2013-06-17 18:43:23 UTC
Thank you. I hope I have helped.

Marcelo Soares
Consultor Imobiliário - CRECI nº 8457
(71) 9265-8740


2013/6/17 <bugzilla-daemon@freedesktop.org>

>  Jacques Guilleron <guilleron29@aol.com> changed bug 65383<https://bugs.freedesktop.org/show_bug.cgi?id=65383>
>  What Removed Added  Status NEEDINFO NEW
>
>  *Comment # 13 <https://bugs.freedesktop.org/show_bug.cgi?id=65383#c13>on bug
> 65383 <https://bugs.freedesktop.org/show_bug.cgi?id=65383> from Jacques
> Guilleron <guilleron29@aol.com> *
>
> Set this report to NEW. We have enough information.
>
> Jacques Guilleron
>
>  ------------------------------
> You are receiving this mail because:
>
>    - You reported the bug.
>
>
Comment 15 Julien Nabet 2013-07-04 19:56:54 UTC
On pc Debian x86-64 with master sources updated today, I don't reproduce this problem.
Comment 16 Marcelo Soares 2013-07-04 20:39:33 UTC
This means that the problem was solved?

Marcelo Soares
Consultor Imobiliário - CRECI nº 8457
(71) 9265-8740


2013/7/4 <bugzilla-daemon@freedesktop.org>

>  Julien Nabet <serval2412@yahoo.fr> changed bug 65383<https://bugs.freedesktop.org/show_bug.cgi?id=65383>
>  What Removed Added  CC   serval2412@yahoo.fr
>
>  *Comment # 15 <https://bugs.freedesktop.org/show_bug.cgi?id=65383#c15>on bug
> 65383 <https://bugs.freedesktop.org/show_bug.cgi?id=65383> from Julien
> Nabet <serval2412@yahoo.fr> *
>
> On pc Debian x86-64 with master sources updated today, I don't reproduce this
> problem.
>
>  ------------------------------
> You are receiving this mail because:
>
>    - You reported the bug.
>
>
Comment 17 Julien Nabet 2013-07-04 20:42:08 UTC
Marcelo: it only means I don't reproduce it with future 4.2.0. Now I haven't tested the case with 4.1 beta and LO Debian testing package is 4.0.3
Comment 18 Julien Nabet 2013-07-04 20:42:58 UTC
Marcelo: please don't answer from your emailer but directly on bugtracker (just click https://bugs.freedesktop.org/show_bug.cgi?id=65383#)
Comment 19 retired 2013-08-06 02:57:43 UTC
*** Bug 67070 has been marked as a duplicate of this bug. ***
Comment 20 retired 2013-08-06 03:13:44 UTC
May this here be a duplicate of https://bugs.freedesktop.org/show_bug.cgi?id=59520 ?

Same error message, same behavior from what I can tell.
Comment 21 Todd 2013-08-06 04:55:58 UTC
Scientific Linux 6.4, 64 bit

This bug almost gave me heart failure.

When I upgraded from
    Old: LibreOffice_4.0.4_Linux_x86-64_rpm.tar.gz

    New: LibreOffice_4.1.0_Linux_x86-64_rpm.tar.gz
         Version: 4.1.0.4
         Build ID: 89ea49ddacd9aa532507cbf852f2bb22b1ace28

I was no longer able to open my encrypted documents (or save them with a password either).  The following error was reported:

   The password is incorrect. The file cannot be opened

The following work around corrected the problem:

   # ln -s /usr/lib64/libsqlite3.so.0 /opt/libreoffice4.1/program/libsqlite3.so

The "#" means "root" user.  The work around corrected the save as with password error too, which was an I/O Error.

Please fix this immediately, before you give some folks real heart attacks.

Many thanks,
-T
Comment 22 Julien Nabet 2013-08-06 06:29:22 UTC
Todd: thank you for the interesting feedback about this workaround:
ln -s /usr/lib64/libsqlite3.so.0 /opt/libreoffice4.1/program/libsqlite3.so

Kohei/Markus/Eike: would it be du to a LO packaging bug or rather a Calc bug? (or completely something else?)
Comment 23 Kohei Yoshida 2013-08-06 15:06:18 UTC
Look for a thread on the mailing list about this.  This has already been fixed and there should be a duplicate bug report for this for 4.1.
Comment 24 Julien Nabet 2013-08-06 15:26:36 UTC
Ok I found the thread (http://nabble.documentfoundation.org/LibreOffice-4-1-0-4-can-t-open-any-of-my-ods-password-files-created-before-LO-4-1-td4067373.html#a4067479) and the fdo (https://bugs.freedesktop.org/show_bug.cgi?id=64916)

Thank you a lot Kohei!

*** This bug has been marked as a duplicate of bug 64916 ***