Ask Your Question
0

Can Calc save a document as an .XLSX doc?

asked 2015-09-17 18:24:09 +0100

bhfhcc gravatar image

Work computer doesn't have Microsoft Excel, and OpenOffice cannot save as the .XLSX format.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

answered 2016-03-20 05:31:54 +0100

LKeithJordan gravatar image

updated 2016-03-21 14:14:10 +0100

UPDATE 2016.0321 I just checked and need to correct myself. LO uses dot+asterisk not underscore+asterisk as previously stated.
^^^^^^^^^^^^^^^
Yes. You should check to make sure everything works as expected in the converted file, however. While most things should be fine, a couple of things I have noticed are:

  • Wildcards used in formulas will need adjustment. Calc uses underscore+asterisk where Excel uses only the asterisk to denote wildcards.
  • Pivot tables in Calc look more like Excel Pivot tables prior to 2007, so you may need to recreate them in Excel from the dataset if you need the look of Excel 2007 and higher. Be sure you have the most recent version and update of LO Calc before converting to xlsx.
  • Please click the checkmark next to the response you believe best answers your question.

edit flag offensive delete link more

Comments

I believe in v5.2.0 full support of Excel-style wildcards has been implemented. Refer tdf#72196.

oweng gravatar imageoweng ( 2016-03-21 07:30:48 +0100 )edit

That's GREAT to know, @oweng. Right now, I am running LO Version: 5.1.0.3 for Windows and LO Version 5.1.1.2 for Linux. As far as I am aware, LO Version 5.2.0 has not been released as a stable version -- but I definitely look forward to seeing this issue resolved when it is.

LKeithJordan gravatar imageLKeithJordan ( 2016-03-21 14:23:39 +0100 )edit
0

answered 2015-10-05 20:45:01 +0100

Alex Kemp gravatar image

updated 2016-03-19 05:59:50 +0100

Yes. See Q59178 for more info.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2015-09-17 18:24:09 +0100

Seen: 705 times

Last updated: Mar 21 '16