You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2015/03/21 10:04:33 UTC
[Issue 126195] New: xls file shows blank while opening in open
office
https://bz.apache.org/ooo/show_bug.cgi?id=126195
Issue ID: 126195
Issue Type: DEFECT
Summary: xls file shows blank while opening in open office
Product: Calc
Version: 4.1.1
Hardware: PC
OS: Windows 7
Status: UNCONFIRMED
Severity: critical
Priority: P5
Component: viewing
Assignee: issues@openoffice.apache.org
Reporter: lbmanikandan@gmail.com
Hi Team,
When i try to open the microsoft excel file whose extension is .xls in
Openoffice CALC version 4.1.1, It is showing blank, but the same file is
opening in microsoft excel and i am able to see the data.
Having gone through couple of existing issues i dont find solution to my
problem.
Would appreciate if you can help me to resolve this issue asap, as this is one
of the live issue i am facing. Kindly help.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126195] xls file shows blank while opening in open office
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126195
--- Comment #10 from orcmid <or...@apache.org> ---
Created attachment 85360
--> https://bz.apache.org/ooo/attachment.cgi?id=85360&action=edit
An Excel 2003 XML file that is acceptable to Excel and OpenOffice
(In reply to orcmid from comment #9)
[ ... ]> 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.
I conducted one additional experiment. Since I formed a .xsl sheet that did
preserve the content of Attachment 84608 and worked with OpenOffice, I used
*that* file, in Microsoft Excel 2016, to create an Excel 2003 XML file. *That*
Excel XML file opens perfectly in Apache OpenOffice.
I have attached it for the information of the original reporter. This may
reveal differences that the original reporter might wish to take into
consideration in generating files that work correctly between products.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126195] xls file shows blank while opening in open office
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126195
Krishna <lb...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Priority|P5 |P1
Severity|critical |blocker
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126195] xls file shows blank while opening in open office
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126195
--- Comment #4 from orcmid <or...@apache.org> ---
(In reply to orcmid from comment #3)
> Created attachment 84609 [details]
> Excel 2013 Warnings about the File
> If I rename the file to have extension .xml, Excel 2013 opens it directly.
> OpenOffice Calc will attempt to open it also, using File > Open ..., and the
> JRE requirement arises again.
>
> On Calc, this is the format "Microsoft Excel 2003 XML (.xml)(*.xml)".
> Without a JRE, Calc will not save in this format either.
WORKAROUND
I assume this file is being computer-generated in XML and that is why that
format is chosen rather than true .xls format.
I suggest that the file be renamed to have extension .xml (since that is even
what Microsoft Office 2013 and Excel prefer).
I further suggest that the file be opened in Excel and save as .xls as a way to
make a form that can be interchanged and also used in OpenOffice without
requiring Java and an under-used conversion.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126195] xls file shows blank while opening in open office
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126195
orcmid <or...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |orcmid@apache.org
--- Comment #3 from orcmid <or...@apache.org> ---
Created attachment 84609
--> https://bz.apache.org/ooo/attachment.cgi?id=84609&action=edit
Excel 2013 Warnings about the File
Excel 2013 detects that the file is not .xls, although it will open the file
and display the data. When I allow it to open and enable editing, I discover
that it is in Excel XML Spreadsheet format.
When opened in Apache OpenOffice 4.1.1 directly, there is an "OpenOffice
requires a Java runtime environment (JRE) to perform this task. Please install
..." message, presumably to attempt conversion, followed by a General
input/output error.
If I rename the file to have extension .xml, Excel 2013 opens it directly.
OpenOffice Calc will attempt to open it also, using File > Open ..., and the
JRE requirement arises again.
On Calc, this is the format "Microsoft Excel 2003 XML (.xml)(*.xml)". Without
a JRE, Calc will not save in this format either.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126195] xls file shows blank while opening in open office
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126195
oooforum <oo...@free.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOT_AN_ISSUE
CC| |oooforum@free.fr
--- Comment #8 from oooforum <oo...@free.fr> ---
No news from author since +30 days: closed
Please report back the outcome of your testing, so this Issue may be reopened
or
progressed as necessary - otherwise the issue may be Resolved as Invalid in the
future.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126195] xls file shows blank while opening in open office
Posted by 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.
[Issue 126195] xls file shows blank while opening in open office
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126195
--- Comment #2 from Krishna <lb...@gmail.com> ---
Created attachment 84608
--> https://bz.apache.org/ooo/attachment.cgi?id=84608&action=edit
sample xls file which is showing blank data in open office.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126195] xls file shows blank while opening in open office
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126195
--- Comment #7 from orcmid <or...@apache.org> ---
(In reply to Krishna from comment #5)
> Thanks,
> Now i have changed the logic of generating excel via asp.net
So these files are being generated on a server, probably from a database?
Is it important for users to be able to edit these in Excel?
Knowing more about the use case would be helpful here.
Why is it important to have these identified as .xls ? What will people be
doing with them?
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126195] xls file shows blank while opening in open office
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126195
--- Comment #6 from orcmid <or...@apache.org> ---
(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?
You have two issues to consider. It depends on who you expect to use this file
and what you require them to have.
1. If you want users to be able to use Microsoft Excel (the reason for .xls,
yes?), your users will see warning messages in the latest versions of Microsoft
Office. Microsoft Office correctly processes the file whether you use either
.xls or .xml, but the preference is for .xml now.
2. If you want users to be able to use the file in OpenOffice, whether named
.xls or .xml, they will have to have Java installed. I don't believe this is
an option for LibreOffice and it is an extra burden on users for current
releases of Apache OpenOffice.
It is about who you are serving and how you want to demonstrate care for them.
Have you considered saving it from OpenOffice as a PDF?
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126195] xls file shows blank while opening in open office
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126195
Regina Henschel <rb...@t-online.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Priority|P1 |P3
Severity|blocker |normal
CC| |rb.henschel@t-online.de
--- Comment #1 from Regina Henschel <rb...@t-online.de> ---
Please attach the file. There is no general problem with .xls files, therefore
it is surely something special with that file.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126195] xls file shows blank while opening in open office
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126195
--- Comment #5 from Krishna <lb...@gmail.com> ---
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?
--
You are receiving this mail because:
You are the assignee for the issue.