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