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/
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
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 ***
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. > >