[Issue 126195] xls file shows blank while opening in open office

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=126195

orcmid <or...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|NOT_AN_ISSUE                |WONT_FIX

--- Comment #9 from orcmid <or...@apache.org> ---
(In reply to orcmid from comment #6)
> (In reply to Krishna from comment #5)
> > Thanks,
> > Now i have changed the logic of generating excel via asp.net, So i jus opend
> > this file in openoffice and whn i try to click saveas i see that the file
> > extension shows .xml (i.e. microsoft excel 2003 XML) because of which i have
> > to choose option called "Microsoft excel 97 - 2003 Workbook". Is it possible
> > to avoid this option of showing .xml with file name and show it as .xls?

I happened to look at the sample file in hex.

It is *not* a .xls file.  It is a Microsoft Excel 2003 XML file and that is
different.  This is a special file type and the correct extension *is* .xml.

If you use the .xml extension, Microsoft Office will open it correctly without
complaint, and all of the data shows.

However, Microsoft OpenOffice Calc still opens the file with no data in the
sheet cells.

It appears that the Calc input filter for Excel 2003 XML format is failing for
your generated document.

We are not in a position to determine what the failure is and whether or not
the generated document is correct or not.

I recommend as a workaround that you open the generated document in Microsoft
Office Excel and save it as .xls from Excel if that is what you want the
recipients of the document to receive.  I have done this and confirm that the
result is also readable by LibreOffice and Apache OpenOffice as well as
Microsoft Office.  One thing to do before saving it from Excel, though, is to
adjust the column widths of the data so the sheet appears in a pleasant form.

-- 
You are receiving this mail because:
You are the assignee for the issue.