How do I open a spreadsheet in Libre Office?

Question

How do I open a spreadsheet in Libre Office?

I have a new iMac with Maverick 10.9.5, and downloaded Libre Office 4.3.1.2

I want to download spreadsheets from a government website, and always open in Libre Office.

I don't want to download in Numbers, export to excel, and export again to Libre Office.

Where is a setting to "always use Libre Office"?

If I single-click the downloaded spreadsheet, then right-click, "open with" and hit Libre Office, then it appears as a spreadsheet, but crashes when I try to sort the columns.

iMac (21.5-inch, Mid 2014), OSX 10.9.5

Posted on Oct 6, 2014 1:24 AM

Reply

Answer 1

Naikosen

Level 2

247 points

Oct 6, 2014 1:39 AM in response to mollymelhuish

Hi mollymelhuish;

Right click the downloaded spreadsheet, and choose Get Info.

Under Open With, select LibreOffice.

Click the Change All button, confirm the action, and close the window.

Now, the selected file type will always be opened with LibreOffice.

Regards,

Reply

Answer 2

Oct 6, 2014 2:43 AM in response to Naikosen

Thanks Naikosen, worked perfectly.

I wonder what format it actually is in, in Finder, and on the title bar, it says .xls,

I would have thought it was .ods or something like that?

Reply

Answer 3

Oct 6, 2014 2:46 AM in response to Naikosen

Aha, I'd set up Libre Office to always save in .xls. Problem solved, thanks!

Reply

Answer 4

Naikosen

Level 2

247 points

Oct 6, 2014 3:09 AM in response to mollymelhuish

HI mollymelhuish;

There are compatibility problems with LibreOffice for handling Microsoft Office documents, esp. with fonts, borders, hidden rows & columns, and so on.

Regards,

Reply

Answer 5

Oct 6, 2014 12:48 PM in response to Naikosen

Hi Naikosen, I've just downloaded a big spreadsheet from a Government site, it came with the extension .xls.xlsx, and the menu bar said "Numbers".

I said "get info" and it said it was in LibreOffice.app

Message comes up : "Electricity.xls.xlsx" can't be opened because it is from an unidentified developer. Your security preferences allow istakation of only apps from the Mad App Store and identified developers.

what next?

Reply