Eclipse Community Forums: BIRT » Editing Birt xls prototype emitter

Home » Archived » 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 09:44

Eclipse User

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 09:56] by Moderator

Re: Editing Birt xls prototype emitter [message #553749 is a reply to message #553685]

Wed, 18 August 2010 12:21

Eclipse User

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 13:34

Eclipse User

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 14:13

Eclipse User

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 04:21

Eclipse User

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 04:22] by Moderator

Re: Editing Birt xls prototype emitter [message #553989 is a reply to message #553856]

Thu, 19 August 2010 11:03

Eclipse User

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 12:37

Eclipse User

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 13:12] by 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:

-=] Back to Top [=-

Current Time: Wed Jul 23 11:53:01 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter