Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Editing Birt xls prototype emitter(need help with starting editing xls prototype emitter)
Editing Birt xls prototype emitter [message #553685] Wed, 18 August 2010 13:44 Go to next message
Janusz Paszynski is currently offline Janusz Paszynski
Messages: 8
Registered: August 2010
Location: Warsaw, Poland
Junior Member

There is some issues with this standart emitter. I think I can edit source to make it better.

1. Row Auto Height in MS Excell is enabled by default, this atribute should be deleted, and when height is not specified in rptdesign it shouldnt be exported to excell as 15.

2. Formulas would be automaticly detected. Formula starts from = and doesnt have to be made from agreagation function, but might be created from text (cells adresses must be wrote as relatives)

3. Antidiagonal border is not supported for cells.

4. HTML Tags in cells are not supported. It could be ussing additional attribut by default for text element

So I need some help how to start. I added source from source package of emitter and added reference to org.eclipse.birt.engine.emitter.jar, but unfortunatly there are some errors. After export using manifest from source package isn't recognised by Birt Viewer in which I was trying to test my changes.

I will be thankful for any help.

It would be helpful: I was working on emitter from 2.5.2, but those things haven't changed in 2.6.0. I have examined 2.6.0 emitters source too.

[Updated on: Wed, 18 August 2010 13:56]

Report message to a moderator

Re: Editing Birt xls prototype emitter [message #553749 is a reply to message #553685] Wed, 18 August 2010 16:21 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Did you use the export wizard? Can you email the exported emitter to me
at jasonweathersby at windstream dot net?

Jason



On 8/18/2010 9:45 AM, Janusz Paszynski wrote:
> There is some issues with this standart emitter. I think I can edit
> source to make it better.
>
> 1. Row Auto Height in MS Excell is enabled by default, this atribute
> should be deleted, and when height is not specified in rptdesign it
> shouldnt be exported to excell as 15.
>
> 2. Formulas would be automaticly detected. Formula starts from = and
> doesnt have to be made from agreagation function, but might be created
> from text (cells adresses must be wrote as relatives)
>
> 3. Antidiagonal border is not supported for cells...
>
> So I need some help how to start. I added source from source package of
> emitter and added reference to org.eclipse.birt.engine.emitter.jar, but
> unfortunatly there are some errors. After export using manifest from
> source package isn't recognised by Birt Viewer in which I was trying to
> test my changes.
>
> I will be thankful for any help.
>
> It would be helpful: I was working on emitter from 2.5.2, but those
> things haven't changed in 2.6.0. I have examined 2.6.0 emitters source too.
Re: Editing Birt xls prototype emitter [message #553756 is a reply to message #553749] Wed, 18 August 2010 17:34 Go to previous messageGo to next message
Janusz Paszynski is currently offline Janusz Paszynski
Messages: 8
Registered: August 2010
Location: Warsaw, Poland
Junior Member

Well, I used export->JAR File to export. Before that I added MANIFEST-MF as src folder for export and while exporting I've choosen manifest file from this folder.

I can send it to you. The only changes in source I made are AutoFitHeight and skiping writing height above MS Excel row default height (15.0).
Re: Editing Birt xls prototype emitter [message #553763 is a reply to message #553756] Wed, 18 August 2010 18:13 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Try the export wizard on the first tab of the manifest editor. Double
click on the plugin.xml to open the editor.

On 8/18/2010 1:34 PM, Janusz Paszynski wrote:
> Well, I used export->JAR File to export. Before that I added MANIFEST-MF
> as src folder for export and while exporting I've choosen manifest file
> from this folder.
>
> I can send it to you. The only changes in source I made are
> AutoFitHeight and skiping writing height above MS Excel row default
> height (15.0).
Re: Editing Birt xls prototype emitter [message #553856 is a reply to message #553763] Thu, 19 August 2010 08:21 Go to previous messageGo to next message
Janusz Paszynski is currently offline Janusz Paszynski
Messages: 8
Registered: August 2010
Location: Warsaw, Poland
Junior Member

At begining I was using export from context menu, but first of all I was using source package (jar) from Birt Framework. Now I downloaded source from CSV and I can use export wizard. The only problem is I am getting error while export:

18. ERROR in org.eclipse.birt.report.engine.emitter.prototype.excel\src\org\eclipse\birt\report\engine\emitter\excel\ExcelUtil.java (at line 949)
	else if ( temp == '¤' )
	                  ^^^^
Invalid character constant


I have no idea what to do with that. It is a normal UTF8 character in UTF8 coded file. Unfortunatly I've found no way to build with this error.

[Updated on: Thu, 19 August 2010 08:22]

Report message to a moderator

Re: Editing Birt xls prototype emitter [message #553989 is a reply to message #553856] Thu, 19 August 2010 15:03 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Can you try replacing the if with:

else if ( temp == '\u00A4' )

Jason


On 8/19/2010 4:21 AM, Janusz Paszynski wrote:
> At begining I was using Ecport from context menu, but first of all I was
> using source jar package (jar). Now I downloaded source from CSV and I
> can use export wizard. The only problem is I am getting error while export:
>
>
> 18. ERROR in
> org.eclipse.birt.report.engine.emitter.prototype.excel\src\o rg\eclipse\birt\report\engine\emitter\excel\ExcelUtil.java
> (at line 949)
> else if ( temp == '¤' )
> ^^^^
> Invalid character constant
>
>
> I have no idea what to do with that. It is a normal UTF8 character in
> UTF8 coded file. Unfortunatly I've found no way to build with this error.
Re: Editing Birt xls prototype emitter [message #554010 is a reply to message #553989] Thu, 19 August 2010 16:37 Go to previous message
Janusz Paszynski is currently offline Janusz Paszynski
Messages: 8
Registered: August 2010
Location: Warsaw, Poland
Junior Member

Thanks alot, it works. So now I can start working on it. I think some things need to be done outside emitter unfortunatly like antidiagonal border support.

Oh, little of-topic: anyone know where to send my source and built plugin after my changes? I think some of them might be usefull like antidiagonal lines support (already done).

[Updated on: Thu, 19 August 2010 17:12]

Report message to a moderator

Previous Topic:java.sql.Statement has been closed strangely when inner joining 2 datasets
Next Topic:Is it possible to bold a word in the text box of the PDF report
Goto Forum:
  


Current Time: Thu Oct 23 03:07:53 GMT 2014

Powered by FUDForum. Page generated in 0.03543 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software