thibaultleouay / native-excel-emitter-birt-plugin Goto Github PK
View Code? Open in Web Editor NEWAutomatically exported from code.google.com/p/native-excel-emitter-birt-plugin
Automatically exported from code.google.com/p/native-excel-emitter-birt-plugin
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.
Original issue reported on code.google.com by [email protected]
on 7 Dec 2011 at 6:16
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.
Original issue reported on code.google.com by [email protected]
on 19 Aug 2013 at 9:03
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.
Original issue reported on code.google.com by dinbtechit
on 27 May 2014 at 1:18
Attachments:
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.
Original issue reported on code.google.com by [email protected]
on 27 Feb 2014 at 9:33
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.
Original issue reported on code.google.com by [email protected]
on 24 Nov 2011 at 2:43
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)
Original issue reported on code.google.com by [email protected]
on 5 May 2015 at 7:13
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.
Original issue reported on code.google.com by [email protected]
on 10 Apr 2012 at 12:00
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)
Original issue reported on code.google.com by [email protected]
on 17 Apr 2012 at 5:28
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.
Original issue reported on code.google.com by [email protected]
on 19 Apr 2012 at 5:21
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.
Original issue reported on code.google.com by [email protected]
on 1 Mar 2012 at 2:06
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.
Original issue reported on code.google.com by konerusuresh
on 24 Oct 2011 at 1:43
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");
Original issue reported on code.google.com by [email protected]
on 10 Apr 2012 at 12:48
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.
Original issue reported on code.google.com by [email protected]
on 30 May 2012 at 4:00
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
Original issue reported on code.google.com by [email protected]
on 18 Jun 2014 at 4:27
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.
Original issue reported on code.google.com by [email protected]
on 7 Nov 2011 at 3:37
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.