thibaultleouay / native-excel-emitter-birt-plugin Goto Github PK

At first we're really grateful for that you provided us this useful tool. 
Unfortunately we have a problem with excel output design when we use merged 
cells in our reports. 

Here is how to recall the problem:

1. Put grid of 2 columns and 3 rows on your report.
2. Select all cells in the grid and set "All borders" property to them.
3. Merge two cells in lower right corner (second row, second column cell is now 
merged with third row, second column cell)

Now, when you try to get xls output, the border is missing on the lower right 
corner of the table in the output. Last cell (third row, second column) doesn't 
have it's right and it's bottom border.

We are using Birt 2.6.2 version combined with latest version of the emitter. 
Stuff is deployed on JBOSS 5.1 server running on W7 32bit.

Thank you for your help, we really appreciate it.

What steps will reproduce the problem?
1. Generate .xls file with more than 4000 records 
2.
3.

What is the expected output? What do you see instead?


What version of the product are you using? On what operating system?


Please provide any additional information below.


org.eclipse.birt.report.engine.emitter.xls.layout.Page needOutputInMasterPage
WARNING: Excel page header and footer don't support html text.
Apr 28, 2015 5:44:59 AM org.eclipse.birt.report.engine.api.impl.EngineTask 
handleFatalExceptions
SEVERE: An error happened while running the report. Cause:
java.lang.IllegalStateException: The maximum number of cell styles was 
exceeded. You can define up to 4000 styles in a .xls workbook
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.createCellStyle(HSSFWorkbook.java:1120)

What steps will reproduce the problem?
1. Run a report, generate a rptdocument
2. from the generated rptdocument generate excel
3. throws error

What is the expected output? What do you see instead?
Excel should be generated

What version of the product are you using? On what operating system?
Linux / BIRT 3.7

Please provide any additional information below.

org.eclipse.birt.report.engine.api.impl.RenderTask.render]  : Error happened 
while running the report.java.lang.StackOverflowError
        at org.eclipse.birt.report.engine.emitter.xls.BlankData.setHeight(BlankData.java:61)
        at org.eclipse.birt.report.engine.emitter.xls.BlankData.setHeight(BlankData.java:61)
        at org.eclipse.birt.report.engine.emitter.xls.BlankData.setHeight(BlankData.java:61)
        at org.eclipse.birt.report.engine.emitter.xls.BlankData.setHeight(BlankData.java:61)
        at org.eclipse.birt.report.engine.emitter.xls.BlankData.setHeight(BlankData.java:61)
        at org.eclipse.birt.report.engine.emitter.xls.BlankData.setHeight(BlankData.java:61)
        at org.eclipse.birt.report.engine.emitter.xls.BlankData.setHeight(BlankData.java:61)

hi，
 I have two questions.
1、What is the property "caches" of class 
"org.eclipse.birt.report.engine.emitter.xls.layout.Page" working for?
2、When I export 100,000 records,the style is missing.It is works perfect 
about 80,000 records.When I export more records,I got an OOM exception.

What version of the product are you using? On what operating system?
PC
window XP
birt engine 2.6.2

Please provide any additional information below.
Thanks for your plugin,it helps.

What steps will reproduce the problem?
1. Install Birt 4.3.1
2. Export reports that were working in 4.2

What is the expected output?
Working Excel spreadsheet.

What do you see instead?
An Excel spreadsheet with a list of exceptions and their stack trace:
...
java.lang.ClassCastException: 
org.eclipse.birt.report.engine.css.engine.value.StringValue cannot be cast to 
org.eclipse.birt.report.engine.css.engine.value.FloatValue
at 
org.eclipse.birt.report.engine.emitter.xls.POIWriterXLS.declareStyle(POIWriterXL
S.java:263)
...

For some reason StyleEntry.getProperty( StyleConstant.TEXT_INDENT ) returns a 
StringValue with contents "none", not a FloatValue.

What version of the product are you using?
org.eclipse.birt.report.engine.emitter.nativexls_1.0.0.201110122114.jar

On what operating system?
Windows 7

Please provide any additional information below.
Is there any plan to upgrade the native excel emitter to Birt 4.3.1? This would 
be great as neither of the new Birt Excel emitters offers cell merging for 
headers.

What steps will reproduce the problem?
1. run sample file in birt runtime 2.6.2
2. export to excel 
3. Output in single sheet only even if the page break is set.

What is the expected output? What do you see instead?
Want to export into excel with multiple sheets according to page break through 
birt runtime . Instead got in single sheet only.

What version of the product are you using? On what operating system?
Birt 2.6.2 , OS - windows XP

Please provide any additional information below.
As in docs provided,multi-sheet excel conversion working with Report Designer 
RCP 2.6.2 But not with runtime. Also can we name the multiple sheets according 
to table,grid name OR any script.

Awesome work on emitter. It works like a charm. Thanks a lot.

What version of the product are you using? On what operating system?
BIRT 3.7,Windows 7

Please provide any additional information below.
I want the report to be exported into excel with Text as the format cell 
option. If you export  a report to excel and select a cell and right click 
there and go to format cell option , I need to see Text as the Category.
At present I am seeing the General as format cell option.

Thanks for this awesome Excel Emitter it has met the majority of our needs. We 
are just having a bit of an issue with regards to exceeding the maximum number 
of fonts allowed.

Our setup is as follows:

BIRT runtime 2.6.2
Excel 2010
Windows 7 Professional

1. Using BIRT runtime 2.6.2 we are creating a report that spans 144 rows and 9 
columns. The report is making use of a styles library.
2. After exporting the report as Excel and opening it in Excel 2010 we get the 
following message:

Protected View - Office has detected a problem with this file. Editing it may 
harm your computer. Click for more details.

3. When we selected all the rows of the Excel file and manually set their font 
to be "Arial", closed the file and opened it again we no longer got the 
Protected View message.
4. With a fresh version of the problematic report we then tried limiting the 
number of rows produced to just 5 and no longer got the Protected View message.
5. We also tried removing all styles from the BIRT library ran a fresh report, 
exported as Excel and got the following message when we opened it:

Some text formatting may have changed in this file because the maximum number 
of fonts was exceeded. It may help to close other documents and try again.

While it is still possible to view / edit Excel reports that show this message 
it would be great if there was a way to do away with it.

What steps will reproduce the problem?
1. Export a report with Page Orientation set to Landscape in the Design
2.
3.

What is the expected output? What do you see instead?
After it is exported, check for Print Preview, it is expected to have the Page 
setup as Landscape. But it would have the page set up as Portrait.

What version of the product are you using? On what operating system?
org.eclipse.birt.report.engine.emitter.nativexls_1.0.0.201110122114.jar on 
Windows

Please provide any additional information below.

What steps will reproduce the problem?
This issue occurs intermittently.

What is the expected output? What do you see instead?
Date in excel output is displayed as '1/1/4713' and '1/0/0000' instead of
'2/14/2014' and '2/11/2014'

What version of the product are you using? On what operating system?
Environmental Details:

App server : Weblogic 11
BIRT - 3.7.0
Java - 1.6
OS - unix
Database - Oracle11g

Please provide any additional information below.
In on render property of date column we are using following script:

this.setDisplayValue(Formatter.format(this.getValue(),"M/d/yyyy"));

We are using native excel emitter :

org.eclipse.birt.report.engine.emitter.nativexls

First of all, Thank you very much for the Excel Emitter for Birt Report. We are 
using it to generate Binary version. I was not able to switch off Multi sheet 
generation. We are using repot Engine (BIRT 3.7).

EXCELRenderOption emitter = new EXCELRenderOption();       
emitter.setOutputFormat();                                          
emitter.setOption("org.eclipse.birt.report.engine.emitter.nativexls");
emitter.setEnableMultipleSheet(false);

I did try to debug your source code and I came across             public void 
startPage( IPageContent pageContent ) throws BirtException Line 137 of 
ExcelLayoutEngine.java being called twice and each time inside  the if statement

if ( page == null || context.isEnableMultipleSheet( ) ){
.....
......
}

page variable is null

I Suspect page variable need to be set before the if statement

i.e 
page = context.getPage();
if ( page == null || context.isEnableMultipleSheet( ) ){
 .....
 .....
}

Could you please advice me on the above problem.
Your help is highly Appreciated.

What steps will reproduce the problem?
1) Remove the following jars from the eclipse\plugin folder
• org.eclipse.birt.report.engine.emitter.excel.config_2.6.2.r262_v20110127.jar
• 
org.eclipse.birt.report.engine.emitter.prototype.excel_2.6.2.r262_v20110215.jar
2) Copy org.eclipse.birt.report.engine.emitter.nativexls_1.0.0.201110122114 
into eclipse\plugin folder 

What is the expected output? What do you see instead?

Now if i click on "View Report as XLS" option from eclipse,then I am able to 
see the image in excel file. when i call the report from a java page,then the 
image is getting displayed in the BIRT report viewer but if I export it as 
excel from the BIRT report viewer window, then image is not getting exported in 
the excel file.

What version of the product are you using? On what operating system?
BIRT 3.7
Windows

Please provide any additional information below.

What steps will reproduce the problem?
1. define the value for one of the column and make that no wrapping.
2. define other column values as '' or null
3.

What is the expected output? What do you see instead?
the column value of the first cell should display at its full length i.e. 
across the cell. I am getting this using default BIRT emitter, but not through 
native excel emitter.

What version of the product are you using? On what operating system?
I am using 
"org.eclipse.birt.report.engine.emitter.nativexls_1.0.0.201110122114.jar" on 
windows XP OS.


Please provide any additional information below.

What steps will reproduce the problem?
1. Download Eclipse BIRT Designer 4.3.0 all-in-one  
2. Delete the following jars 
 - .prototype.excel_4.3.0.v201306041519.jar
 - .config.excel_4.3.0.v201306041519.jar

3. Copy the nativexls jar to the plugins directory.

What is the expected output? What do you see instead?
An excel file with an image in it.
Instead I saw a huge error. (Please refer the attached excel.)

What version of the product are you using? On what operating system?
Eclipse BIRT Designer 4.3.0, 
org.eclipse.birt.report.engine.emitter.nativexls_1.0.0.201110122114.jar, 
OS - Windows 7

Please provide any additional information below.

What steps will reproduce the problem?
1. I have created cells. merged the cells 
2. Defined the label and background color to merged cell
3. Call the file using IExcelRenderOption.OFFICE_VERSION, "office2007" option

What is the expected output? What do you see instead?
The column should display with specified color, but the column is displayed in 
black color.

What version of the product are you using? On what operating system?
I am using 
"org.eclipse.birt.report.engine.emitter.nativexls_1.0.0.201110122114.jar" and 
windowsXP OS.

Please provide any additional information below.

I have merged the cell using following code:
CellHandle cell1 = (CellHandle) tableheader.getCells().get(i+7); 
                CellHandle cell2 = (CellHandle) tableheader.getCells().get(i+8); 
                CellHandle cell3 = (CellHandle) tableheader.getCells().get(i+9); 
                CellHandle cell4 = (CellHandle) tableheader.getCells().get(i+10);
                CellHandle cell5 = (CellHandle) tableheader.getCells().get(i+11); 
                CellHandle cell6 = (CellHandle) tableheader.getCells().get(i+12); 
                CellHandle cell7 = (CellHandle) tableheader.getCells().get(i+13);
                CellHandle cell8 = (CellHandle) tableheader.getCells().get(i+14);
                CellHandle cell9 = (CellHandle) tableheader.getCells().get(i+15); 
                CellHandle cell10 = (CellHandle) tableheader.getCells().get(i+16); 
                CellHandle cell11 = (CellHandle) tableheader.getCells().get(i+17);  
                cell1.drop();
                cell2.drop();
                cell3.drop();
                cell4.drop();
                cell5.drop();
                cell6.drop();
                cell7.drop();
                cell8.drop();
                cell9.drop();
                cell10.drop();
                cell11.drop();
                CellHandle cell12 = (CellHandle) tableheader.getCells( ).get(i+6);
                cell12.setColumnSpan(12);
                //cell.setProperty(CellHandle.WIDTH_PROP, "0.4");
                cell12.getContent().add(label1);  
                styleHandle = cell12.getPrivateStyle();
                styleHandle.setProperty(StyleHandle.BACKGROUND_COLOR_PROP, "BLUE");
                styleHandle.setProperty(StyleHandle.FONT_FAMILY_PROP, "Arial");
                styleHandle.setProperty(StyleHandle.FONT_SIZE_PROP, 14);


and call the excel using following code: 
EXCELRenderOption options = new EXCELRenderOption();   
            options.setOutputFormat("xls");  
            options.setOutputFileName("c:/test5.xls");  
            options.setOption( IExcelRenderOption.OFFICE_VERSION, "office2007"); 
            options.setOption(IRenderOption.EMITTER_ID,"org.eclipse.birt.report.engine.emitter.nativexls");