11

My colleagues have lots of Microsoft spreadsheet documents. I am using LibreOffice 3.5.4.2.

Without changing / converting / renaming / touching the documents at all, is there a way I can open (and hopefully also make changes to) these documents?

Right now it seems I can't open doc's of that type using LibreOffice Calc.

I am in a corporate environment where I am the only Linux user and asking for a company change in procedures is not very practical.

  • OpenOffice and LibreOffice are similar, but ultimately different things. Which are you using? What version? – trognanders Oct 31 '12 at 20:20
  • Libre Office 3.5.4.2 – Michael Durrant Oct 31 '12 at 23:54
11

My copy of LibreOffice, version 3.5.0rc3, is capable of opening and saving xlsx files. Presumably any version after that will, and probably some version before. LibreOffice has more community developed plugins in its package, so OpenOffice may not have xlsx capabilities.

Who knows if every weird format will work correctly either.

Ubuntu 12.10 has libreoffice 3.6.2, which really should have the support you need.

Install LibreOffice:

sudo apt-get update
sudo apt-get install libreoffice
  • My version is pretty new at 3.5.4.2 but doesn't open .xlsx – Michael Durrant Oct 31 '12 at 22:39
  • Are you using OpenOffice or LibreOffice? – trognanders Oct 31 '12 at 23:16
  • Libre Office 3.5.4.2 – Michael Durrant Oct 31 '12 at 23:55
  • That is pretty weird, maybe they did not end up putting xlsx support in the release version? Either way, Ubuntu 12.10 has LibreOffice 3.6.2 in the repos right now. I will put the command in my answer to install it. – trognanders Nov 1 '12 at 0:17
3

You can try later versions of LibreOffice (3.6.2 is declared stable) and also the latest version of Apache OpenOffice, AOO 3.4.1.

If your colleagues are using the new version, Office 2013 Excel, the best route may be to have them save the documents as ODF for you.

Another alternative is to upload the .xslx files to SkyDrive by creating an account at http://skydrive.live.com. You can then view and edit them in a browser (Internet Explorer, Firefox, or Chrome). You don't need Microsoft Office installed. You'll be warned if a spreadsheet uses features not supported by the SkyDrive versioin.

In all cases, you will have to experiment to see which routes provide the greatest preservation of fidelity in the spreadsheets.

Your colleagues who have Microsoft Office can obtain them back directly from SkyDrive and also save them to SkyDrive from current versions of Office, if that makes it easier for you (and for all of you when not in the office). You'll probably want to create a folder in which only those live.com accounts that you give permission can see and/or edit the documents.

  • Where would I get the later versions from ? – Michael Durrant Oct 31 '12 at 23:56
2

Try the latest version of LibreOffice (3.6.2). I had some trouble opening .xlsx files in the 3.5.X version, but it seems that they've fixed some bugs in the latest version :-)

0

I can open and save modified .xlsx files, using LibreOffice Calc version 6.0.2.1.

Note: LibreOffice Calc yelled at me when closing a modified .xlsx file. He asked me if I wanted to "use the default ODF file format to be sure that the document is saved correctly". I personally consider that to be my employer's problem.

The version of LibreOffice Calc I tested was provided by whatever repository Ubuntu Budgie 18.04 was using on 2018-04-05 (sudo apt-get install libreoffice-calc).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.