Ask Your Question

Revision history [back]

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.

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.

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.