title: How to save .ods spread sheet (OpenOffice.org) to .xlsx (MS Office Excel 2007)
body: <p>Recently I switched from <strong>MS Office</strong> to <strong>OpenOffice.org 3.4.1</strong>. </p>
  
  <p>Here are my questions:</p>
  
  <ol>
  <li><p>I was not able to save .ods spread sheet to .xlsx 2007 Format.<br>
  The option which I got when I use <strong>Save As</strong> was <strong>Microsoft Excel 97/2000/XP (.xls) (*.xls)</strong></p></li>
  <li><p><s>I was not able to use in MS Office Excel 2007 <strong>formula</strong> in Open Office org.<br>
  Example a Formula like<br>
  <code>=IF(AND(A2&lt;&gt;"";B3&lt;&gt;"");"";IF(AND(B3="";B2&lt;&gt;"");"GO";IF(A3="";",";"")))</code><br>
  Here is the test file for <strong><code>Formula</code> <a href="http://www.ziddu.com/download/22229892/TestFormula.zip.html" rel="nofollow noreferrer">MS Excel 2007 and Office Org</a></strong></s></p></li>
  </ol>
  
  <p><strong>Edit:</strong> </p>
  
  <p>Problem 2 is solved. The formula couldn't be copies at first. Also instead of <code>,</code> we have to use <code>;</code> in <strong>OpenOffice.org</strong></p>
  
  <p>But I am still couldn't figure out how to save as xlsx.</p>
  
  <p>I hope someone can help me.</p>