Very strange behaviour. For me, I was trying to open a spreadsheet that has come from previous version of Ubuntu (18.04) - it doesn't appear to recognise the filetype. If I try File->Open from within Calc a valid file is an 'OpenDocument Spreadsheet' but I was seeing a filetype of simply 'File'.
So, 2 ways that didn't work & 1 that did, all trying to open the same file without any changes.
These 2 ways of trying to open a spreadsheet don't work for me:-
Open Calc.
Open MySpreadsheet.ods - keyboard not working
From Files right click on MySpreadsheet.ods and 'Open With LibreOffice Calc' doesn't work either
but this sequence does work:-
- Open Calc with new, blank spreadsheet - keyboard works fine.
- Open a new instance of Calc by Shift-click on the Calc App again.
- Then do File->Open and it is now recognised as an 'OpenDocument Spreadsheet'and the MySpreadsheet.ods opens and works.
Although I don't understand exactly what's going on, it is to do with the file extension being missing sometimes when LibreOffice opens files. Renaming files in file manager with the correct file extension (e.g. .odt .ods) seems to fix them? (I hope!)
p.s. just notice files in question were also marked as 'executable' for some reason, which doesn't sound right - so I unticked that permission.
Update, 3 months later (4th Oct 2020)
Turns out I only had problems with 2 files which I'd carried over from previous versions of Ubuntu, both of which sometimes caused the keyboard to freeze. One was a Libreoffice Calc file and one was a Libreoffice Writer file, both of which had password protection turned on. All other files without password protection worked fine. Pretty sure now my problem was to do with password protection on Libreoffice files.
Simply turning off the password protection for these 2 files works fine, but they were password protected for a reason, so would like a fix.