https://bugs.freedesktop.org/show_bug.cgi?id=69735
Priority: medium
Bug ID: 69735
Assignee: [email protected]
Summary: Unable to Open Spreadsheets after Saving them to
Google Drives Desktop Folder
Severity: critical
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: unspecified
Component: Spreadsheet
Product: LibreOffice
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/
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
