Excel conversion between Libre Office and Microsoft Office.

My personal life got upended by a sewer failure, and I couldn't access my Win7 home computer. There is an Excel spreadsheet I maintain for a club. I tossed it onto a USB "stick" and tried using it at the hotel where my insurance company planted me while my house is re-constructed.

Somehow, I got my spreadsheet going with Libre Office running on a Win10 laptop.

Spreadsheet has four "pages" (tabs on the bottom).

Question 1: Libre seems unable to "print to pdf" the individual spreadsheet pages. How can I get it to do that? It seems to be stuck on one specific page for printing, no matter which one I am looking at.

Question 2: I don't have Libre on my home Win7 machine. And Microsoft Office cannot open the Libre spreadsheet. How can I convert back to Microsoft Office format?

I'm frustrated. Appreciate any help.
Norma PosyPhysicistAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dave BaldwinFixer of ProblemsCommented:
In LibreOffice, do Save As and select 'xls' or 'xlsx' format.  In the PDF dialog window, one of the first options is which pages to print.  Unfortunately, LibreOffice's idea of what a page is may require some experimenting to get what you want.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Norma PosyPhysicistAuthor Commented:
1. Figured out how to print a specific excel page from Libre: You have to highlight the page first.

2. "Save as .xls or .xlsx" does not work.

Here's the situation: Copied files to a usb "stick" before vacating house. Mocrosoft Office Excel running under Win7.

Got stuck with a laptop running Win10 without Microsoft Office. With Libre Office.
Imported from usb stick into Libre ok. Can't go the other direction. Mocrosoft Office can't open Libre spreadsheets.
Dave BaldwinFixer of ProblemsCommented:
"Save as .xls or .xlsx" does not work.
Works every day here and has for years.  What problem are you having?

Libre Office Save as
Starting with Angular 5

Learn the essential features and functions of the popular JavaScript framework for building mobile, desktop and web applications.

Norma PosyPhysicistAuthor Commented:
To clarify: I'm stuck in a hotel while my house is being reassembled following a sewer disaster. I'm stuck with Libre Office on a Win10 laptop. No Microsoft Office.

At home (where I am now amidst the turmoil) I have Microsoft Office under Win7.

At the hotel, From Libre I save as xls and as xlsx to a memory stick.

Here at home, Microsoft Office Excel cannot open either file on the memory stick. Says they are corrupted.

Maybe Libre tacks its own dot-suffix on the end of the files?

Maybe I should download Libre to this machine?
Dave BaldwinFixer of ProblemsCommented:
Interesting.  Can you post an example of an exported file that doesn't open in Excel?
Norma PosyPhysicistAuthor Commented:
Damn. I left the memory stick at the hotel.

I can get here via the laptop at the hotel and send you the files from there.
Dave BaldwinFixer of ProblemsCommented:
Ok.  I have LibreOffice 4.4.5.2 on this machine and Microsoft Office 2007 on another machine.  It would be interesting to see both the 'ods' and 'xls' versions that you have.
Norma PosyPhysicistAuthor Commented:
OK. In Libre: Saved to the memory stick in both xls and xlsx

At home using Microsoft Office, Excel reports that the format of the xls is incompatible, but opened it anyway.

Excel reported that the xlsx file is corrupt, and could not open it.

Having "saved as", I don't think the ods versions are on the memory stick any more.

I've attached the xlsx spreadsheet.
Dave BaldwinFixer of ProblemsCommented:
No, it's not here...  Which version of Microsoft Office?
Norma PosyPhysicistAuthor Commented:
I'm (finally) back in my house.

I thought I attached the file. There is a blue "Attach File" beneath this panel. I will try again later.

I'm used to the older Microsoft Office. There used to be an "About" up in the menu bar. How do I find the version of Office I have on this Win7 machine?

I have my original files on a CD, but they are several weeks old, and would take some manual catching up. I may do that. If I do that, I will be back in business, and this entire issue will no longer be essential. But it will still be of academic interest.

Lesson learned: Don't mix third-party Offices with Microsoft Office.
Dave BaldwinFixer of ProblemsCommented:
Lesson learned: Don't mix third-party Offices with Microsoft Office.
But I don't have any problems with the current version of LibreOffice 4.4.5.2 and Microsoft Office 2007.  So it would be interesting to know why you are.
Norma PosyPhysicistAuthor Commented:
Time to close this question.

I'm back in my house, though will be living with contractor underfoot for weeks yet.

"Save As"  From Libre to Microsoft Office worked as .xls, but not as .xlsx -- but then Microsoft Office itself converted the xls to xlsx. So I am back in business.

Thank you for your help. I appreciate it.

- - Norma
Dave BaldwinFixer of ProblemsCommented:
You're welcome, glad to help.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.