Problem with php exported xls file in Open Office
<p>I am using PHP to export html table layout into excel format (.xls), well the html format opens up fine in Excel but distorted in OpenOffice..</p>

<p>do i have to add any special config to make html format work in OpenOffice?</p>

<p>Any suggesion would be helpful..</p>

<p>I use the below code</p>

<pre><code>header("Content-Type: application/ms-excel"); 
header("Content-Disposition: attachment;filename=invoice.xls"); 
</code></pre>
