Community
Participate
Working Groups
Build Identifier: Birt 2.6.0 GA We are trying to upgrade from Birt 2.3.0 to 2.6.0. Earlier in 2.3 when exporting report to Excel it used to hide all the images (company logo, chart images, footer etc) and that was an OK behavior for us as we don't need images to show up in Excel, but in 2.6 we have noticed that the excel emitter puts in empty space for the images (no image is shown, but the space is taken) and following warning message is thrown in the log, Sep 14, 2010 11:43:39 AM org.eclipse.birt.report.engine.emitter.excel.ExcelEmitter needOutputInMasterPage WARNING: Excel page header and footer don't support embeded grid. Is there any way (configuration change or something) so we can go back to 2.3 behavior for Excel export? As putting empty cells just messes up the formatting in Excel if the user wants to do any data manipulation in spreadsheet. I saw couple of related bugs filed - not sure if they are related, https://bugs.eclipse.org/bugs/show_bug.cgi?id=246249 https://bugs.eclipse.org/bugs/show_bug.cgi?id=237488 Reproducible: Always Steps to Reproduce: 1. Create a report with charts and some png image (logo) 2. Export it in Excel 3. There will be a warning message in the log and empty space where the images are to show up.
This looks similar bug .. but still I can see this issue in BIRT 2.6 https://bugs.eclipse.org/bugs/show_bug.cgi?id=301983
Can you hide the images for "xls" format?
Is there any configuration changes to hide images for "xls" format?
In report, you can set visibility for images, and hide them in "xls".
We got over 70 reports and hiding charts, images for each report is going to be painful - have to go through QA testing and all. Also, we don't want to set the hide for each report as in future if the charts are available for Excel we may just want them to show up automatically. Is there any specific change in the Excel emitter that's causing this behavior (empty space and warning)? Is there any configuration change or setting that we can do to get the Birt 2.3 Excel behavior back?
See the attached sample report with charts. When run from application ( server side code) in HTMl format you will see charts. Once exported to excel or run as xls format on Birt 2.6.1, you will see xls shows blank space in place of charts. Same report in birt 2.3 don't used to show blank spaces.
Created attachment 180374 [details] Report design with sample db with chart.
Created attachment 180541 [details] Excel emitter not outputing image
Please try the emitter attached which doesn't output image/chart items in Excel. You can also try BIRT design engine API to modify report in batch, which will also be easy and fast.
Jun Oyuang, I just tried out the new xls emitter. It works as expected we are not getting big blank spaces for the charts or any other images. Will this change be incorporated as part of any coming release? If so when? Also note, with this I was seeing xls1 in the dropdown when clicked on Export Report button of viewer. I added viewer.extension.xls=xls1 in viewer.properties to display the option back as Excel. Thanks a lot for the fix. We highly appreciate your help.
1. for the format name(xls1) issue, if you want it to be "xls", please modify the "plugin.xml" file in the jar file, change the attribute "format=xls1" to "format=xls". 2. We will consider to fix this bug by one of following solutions: a. provide an option for user to choose between displaying blank space for image or just ignoring image. b. Support image in xls.
Add render option "excelRenderOption.ignoreImage". By default, the value is "true", and XLS will ignore all images.
