Ubuntu 11.10 - LibreOffice 3.4.4
Trying to migrate from Office 2007. One Calc file (the only one I am aware of so far), which was created in Excel, will not open in Nautilus by double-click or right-click-->Open with Calc; Calc opens with a blank worksheet (although the .ods file name is displayed in the title bar).
It also will not open in Calc if another spreadsheet file is already open. The only method that seems to work is opening a new instance of Calc-->Open-->Navigate to the file and double-click on it. Once open, everything appears to work as expected.
The original Excel file was saved as .ods on Windows, since that was the only way I could find to retain text in the cell Comments. The spreadsheet contains a macro, which generates a warning when opened.
Unfortunately, this file is related to finances/cashflow, and it is accessed often. Not being able to simply double-click or right-click on the file to open it is a royal pain. Any help will be much appreciated
What you could do it to load it into the online ODF file validator to see if it is a valid OpenDocument File or if Excel botched the export.
The validator is at: http://odf-validator.rhcloud.com/.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-03-12 13:52:49 +0200
Seen: 287 times
Last updated: Jun 02 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
Does Save As to odt file format work? And if it is still a problem for you, you should update to 12.04
mahfiaz ( 2012-05-17 18:38:55 +0200 )editHi @JuanDeaux, Did you find an answer to your problem? If not, please let us know so that we may try to assist you further. Thanks!
qubit ( 2013-01-22 04:06:48 +0200 )edit