Eclipse Community Forums: BIRT » How to set default font and size type

Home » Archived » BIRT » How to set default font and size type(How to set default font and size type)

How to set default font and size type [message #780340]

Tue, 17 January 2012 11:18

Eclipse User

Greetings,

I have existing birt reports that when I generate the excel output files (HTML) via the birt engine I don't get a default font and size type. The reason I ask is based upon the system font default (in this case windows) I can get different display results in xcel from system to system.

So how do I set a default font type and size in the report (outside of each field).

If you need more details please ask, I've included a sample output file which I hope helps.

Thank-you in advance for your help!
Mike W.

Attachment: BIRT_TEST_FILE_2.xls
(Size: 36.23KB, Downloaded 323 times)

Re: How to set default font and size type [message #780420 is a reply to message #780340]

Tue, 17 January 2012 13:59

Eclipse User

Have you tried changing the default pre-defined styles in the style editor?

Jason

On 1/17/2012 11:18 AM, michael wirzbicki wrote:
> Greetings,
>
> I have existing birt reports that when I generate the excel output files (HTML) via the birt engine I don't get a default font and size type. The reason I ask is based upon the system font default (in this case windows) I can get different display results in xcel from system to system.
>
> So how do I set a default font type and size in the report (outside of each field).
>
> If you need more details please ask, I've included a sample output file which I hope helps.
>
> Thank-you in advance for your help!
> Mike W.
>

Re: How to set default font and size type [message #780658 is a reply to message #780420]

Wed, 18 January 2012 17:11

Eclipse User

Which predefine style controls the creation of the HTML tag of <STYLES> and <DEFAULT> for xcell generated output?

The reason being we're using another tool that needs to get the font style and size being used so it can pass the proper column width to our app. Without it they assume a default font style and size and calculate column width which is incorrect base upon the report design files.

Thank-you in advance for your help!

Re: How to set default font and size type [message #780877 is a reply to message #780658]

Thu, 19 January 2012 13:51

Eclipse User

Michael

Look in the outline view and click on the styles node. Double click on
the report style and change the font to what you want.

Jason

On 1/18/2012 5:11 PM, michael wirzbicki wrote:
> Which predefine style controls the creation of the HTML tag of <STYLES>
> and <DEFAULT> for xcell generated output?
>
> The reason being we're using another tool that needs to get the font
> style and size being used so it can pass the proper column width to our
> app. Without it they assume a default font style and size and calculate
> column width which is incorrect base upon the report design files.
>
> Thank-you in advance for your help!
>

Re: How to set default font and size type [message #780891 is a reply to message #780658]

Thu, 19 January 2012 14:55

Eclipse User

Question: the file output for xcel generated by calling BIRT Engine (2.3.1) contains XML output(xcell 2003). We put an ".xls" extension on the output name so when someone opens it xcell reads and formats the columns correctly (28.95). I pass the same unaltered file to "the tool" to get column width it returns (37.43).

Now I take and save this file in xcel (2007) to .xls format pass it to "the tool" and it now returns (28.95) as column width (what I want). The tool owners state that since the XML output does not have a default font and size "the tool" assumes a default of "Ariel 10" as the bases for column width calculation.

o - Is there a way to set this in BIRT 2.3.1?

o - Does this change in BIRT 3.7?

I've tried to apply styles to the report but it has not effect.

Thank-you in advance for your help!

Mike W.

Re: How to set default font and size type [message #780893 is a reply to message #780891]

Thu, 19 January 2012 15:04

Eclipse User

Mike,

Can you try this with 3.7? Be sure to set the report style font.

Jason

On 1/19/2012 2:55 PM, michael wirzbicki wrote:
> Question: the file output for xcel generated by calling BIRT Engine
> (2.3.1) contains XML output(xcell 2003). We put an ".xls" extension on
> the output name so when someone opens it xcell reads and formats the
> columns correctly (28.95). I pass the same unaltered file to "the tool"
> to get column width it returns (37.43).
>
> Now I take and save this file in xcel (2007) to .xls format pass it to
> "the tool" and it now returns (28.95) as column width (what I want). The
> tool owners state that since the XML output does not have a default font
> and size "the tool" assumes a default of "Ariel 10" as the bases for
> column width calculation.
> o - Is there a way to set this in BIRT 2.3.1?
> o - Does this change in BIRT 3.7?
>
> I've tried to apply styles to the report but it has not effect.
>
> Thank-you in advance for your help!
>
> Mike W.

Previous Topic:	Get report progression from engine API
Next Topic:	Tutorial on using BIRT in RCP application

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Jul 24 18:01:42 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter