Bug 69735 - Unable to Open Spreadsheets after Saving them to Google Drives Desktop Folder
Summary: Unable to Open Spreadsheets after Saving them to Google Drives Desktop Folder
Status: RESOLVED DUPLICATE of bug 68894
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: x86-64 (AMD64) Windows (All)
: high critical
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-09-23 20:37 UTC by Vaughn Reid III
Modified: 2014-03-09 18:25 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Vaughn Reid III 2013-09-23 20:37:13 UTC
I keep several important LibreOffice Spreadsheets in Google Drive. I've noticed in the past few weeks (using libreoffice current version stable) that I am no longer able to consistently open these spreadsheets. A blank libreOffice spreadsheet window appears and then just hangs. Now, if I do an installation repair with LibreOffice .msi then I can usually open the spreadsheet one more time before I get the LibreOffice hanging behavior.

I have tried the following: 1. Completely uninstalling LibreOffice, removing libreoffice from appdata and program files(x86) and then re-installing LibreOffice 2. Experienced the same behavior with OpenOffice 4.0 (did not have it installed concurrently with LibreOffice)

I am always able to open these damaged files with Microsoft Excel. It reports that the files are damaged and does a repair, but if I save the files, excel removes all of my spreadsheet formulas.

I am still seeing the behavior I've noted above, even with LibreOffice 4.1.1 stable release.  I'll be a bit more specific.

Steps to Reproduce with LibreOffice Calc File:

1.  Create LibreOffice Calc file
2.  Move File to Google Drive Desktop  Windows Folder
3.  It appears to open once or twice with LibreOffice from the Desktop Google Drive Folder (not simultaneously open the file multiple time, but open it then close it, then open it, etc.)
4.  Future attempts to open the file results in the file being unable to open and in LibreOffice hanging.
5.  After this happens, we are able to open the file from the Desktop Google Apps folder with Microsoft Excel, but Excel reports that is has found errors and requests to fix them.  Click yes runs Excel's "Fix" which makes it possible to open the file in Excel and look at it, but removes all formulas, etc. since those are not specified in the ODF specification.
6.  After running Excel's fix, and attempting to open the file again with LibreOffice Calc, the whole process starts over on the "fixed" file at step 3.  

Steps to Reproduce with Microsoft Excel Files:
1.  Create a Microsoft Excel file with Microsoft Office Excel.
2.  Save the file and move it to the Google Drive Desktop Folder.
3.  The file can be re-opened with Microsoft Excel without issues, but LibreOffice exhibits the same hanging behavior as mentioned above.

I've marked this as a critical bug because it has the potential to cause serious data loss for users and major headaches for organizations attempting to use LibreOffice.

Also, this issue appears to affect OpenOffice 4.0 as well.  
Note:  Please see this discussion that I started on Ask LibreOffice  http://ask.libreoffice.org/en/question/20924/unable-to-open-libreoffice-spreadsheets-in-google-drive/
Comment 1 Joel Madero 2014-03-08 23:50:15 UTC
I just did a really simple test case of this one:
Windows 7
Google Drive just installed
LibreOffice 4.2.2.1 rc

I cannot reproduce. 

My steps:
Open Excel
A1=1, A2=2, A3=SUM(A1:A2)
Save to Google Drive Folder
Close Excel
Open Spreadsheet
Open file created in google drive folder
Opens no problem
Added new value to A4
Save, exit
Open with Excel - everything is fine.

Am I doing something different? Do you still experience this with 4.1.2? If so, does it only happen with a single test case or any file?

Marking as NEEDINFO - please provide additional information and mark as UNCONFIRMED.

Thanks
Comment 2 Joel Madero 2014-03-08 23:56:20 UTC
I believe that this is a duplicate - marking as such and it should be fixed in 4.2. If not please set to UNCONFIRMED again and answer the previous questions. Thanks!

*** This bug has been marked as a duplicate of bug 68894 ***
Comment 3 Vaughn Reid III 2014-03-09 18:25:57 UTC
I do not appear to have this problem on 4.2. I believe we can mark this as
fixed
On Mar 8, 2014 6:56 PM, <bugzilla-daemon@freedesktop.org> wrote:

>  Joel Madero <jmadero.dev@gmail.com> changed bug 69735<https://bugs.freedesktop.org/show_bug.cgi?id=69735>
>  What Removed Added  Status NEEDINFO RESOLVED  Resolution --- DUPLICATE
>
>  *Comment # 2 <https://bugs.freedesktop.org/show_bug.cgi?id=69735#c2> on
> bug 69735 <https://bugs.freedesktop.org/show_bug.cgi?id=69735> from Joel
> Madero <jmadero.dev@gmail.com> *
>
> I believe that this is a duplicate - marking as such and it should be fixed in
> 4.2. If not please set to UNCONFIRMED again and answer the previous questions.
> Thanks!
>
> *** This bug has been marked as a duplicate of bug 68894 <https://bugs.freedesktop.org/show_bug.cgi?id=68894> ***
>
>  ------------------------------
> You are receiving this mail because:
>
>    - You reported the bug.
>
>