Community
Participate
Working Groups
Build Identifier: 2.6.1 I am able to generate reports using Birt. Downloaded report(excel & ppt) are not opened in open office. Reproducible: Always
Excel and ppt output by BIRT is in xml and mhtml format correspondingly. These 2 formats are not supported by OS.
Correction: I mean the 2 formats are not supported by open office.
(In reply to comment #2) > Correction: I mean the 2 formats are not supported by open office. We also faced problem while opening it with MS Office 2010.
We are using OpenOffice and LibreOffice in out company. With BIRT 2.5.1 and 2.6.0 it was no problem for OO and LO to open the Excel 2003 XML (Export as Excel => rename .xls to .xml). Since BIRT 2.6.2 (also tested with 3.7.0) the import into OpenOffice/LibreOffice does not work anymore. (I know that there is a ODF export option as well, but the excel xml export is much better for our purposes (e.g. numbers are exported as numbers not text, there are no repeated header lines etc.). But that is a different question).
Just to clarify: When I open the xml document (generated with 2.6.2 / 3.7.0) LO needs minutes to open the file and displays then a blanc document. Additional information: The size of the XML file generated with - BIRT 2.6.0 is 1011kb (and it works perfectly) - BIRT 2.6.2 is 2868kb (does NOT work) - BIRT 3.7.0 is 2872kb (does NOT work)
Created attachment 201620 [details] xls renamed to xml
I've attached a xml renamed from xls which is exported by Birt 3.7.1 and seems fine to open in openOffice 3.3.0. Would you please attach your rptdesign and generated xls? Thanks
Thanks for your quick response! I could open the file you attached. It is not a difficult file. I will try to generate a simple file on my system and see if I can open that, too.
I just generated a report with no data and I could export and open it, too.
It also works with small reports (tabs and crosstabs). I try to figure out at what point they don't work anymore.
Created attachment 201625 [details] Exported XML file
Created attachment 201626 [details] report file (rptdesign)
I just rebuild the report (with copy & past) and it does work. Now I examined the two produced xml files. In the first (not working one) there are two lines at the end of the document which seem to cause the problem. <Header/> <Footer x:Data="&L&"sans-serif"&"10.0"&K00000017.08.2011 10:14"/> If I delete those lines, I can open the document with LO. The report was created with 2.6.0 and then imported in 3.7.0. Perhaps in this process a little detail with the footer line got wrong.
As checked, the color format code K000000 is not working in openOffice. It also works differently between excel 2003 and 2007. This is a compatibility issue between Ms excel and openOffice.
Now I know the issue. The footer (see "Master Page") created by a older version of BIRT contains a grid around the text. I deleted the the grid and copied the footer from a new created report. Now I can load the XML file with OpenOffice/LibreOffice. Finally one part of the problem is solved for me. The file size of the XML files produced by version 2.6.2+ are still twice the size of those build with version 2.6.0. (And the layout does fit as good as before; e.g. the small dark borders are now gray and very bold.) Thanks for having a look into that issue and for giving me the hint into the right direction. You rock!
The file size problem should be fixed by Bug 350806 recently. Please check the latest build. Thanks
Created attachment 208092 [details] Error message with 3.7.1 I tested the report with the current 3.7.1 version. With the date in a grid on the master page I get an error (see the exported Excel xml file attached). When I remove the grid and place the date directly in the foot it works fine. When I add the grid again, LibreOffice opens an empty document. The issue seems not to be completely solved in the current version. All in I have to say, that (as I know to use no grid on the footer of the master page) it WORKS FOR ME. (More important - but that is another issue - would be a better ODS export filter.) Thanks for your work!
I have a similar problem where if I view reports as PPT saved to the file system, the file wont open. PowerPoint gives this error "PowerPoint can't read ...ppt." Yet if opened in the BIRT viewer, it opens correctly in Powerpoint. I can then save it to the file system. Steps to reproduce: With BIRT 3.7, View a report using View Report > As PDF .. Report viewer opens with a browser file download dialog box "Do you want to open or save this file". 1. Choose Open: The report seems to be processed by the viewer, then opens in PowerPoint (2010) with the correct contents. Save to file and it's still readable. Attachment "Preview Open.zip". 2. Choose Save: The report is saved to disk but in another format which PowerPoint doesn't like. Attachment "Preview SaveAs.zip". The contents of the "Save As" output seems to need further processing. The same output is produced by the RunTime engine. Could be related to other bugs https://bugs.eclipse...gi?id=328982#c8 regards Brian
Created attachment 222212 [details] Example of Save output in Comment 18 See Comment 18
Created attachment 222214 [details] Example of Open output in Comment 18 See Comment 18