Setting column decimal format with Java Design API

Hi, I am trying to set the format of a numeric cell using the Design API to 2 decimal places to no avail. 
 
I have tried the method suggested by the following post : <a class='bbc_url' href='http://www.birt-exchange.org/org/forum/index.php/topic/20656-changing-column-decimal-format-with-the-de/page__s__4ad88e070f4394c84825b9e851fec20c'>Changing column decimal format with the DE</a> 
to no avail. 
 
My code looks like this: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
String colFormat="#0.00";
DataItemHandle dih =(DataItemHandle)cell.getContent().get(0);
NumberFormatValue nfs=new NumberFormatValue();
nfs.setPattern(colFormat);
dih.clearProperty(StyleHandle.NUMBER_FORMAT_PROP);
dih.setProperty( StyleHandle.NUMBER_FORMAT_PROP, nfs );
</pre>
but to no avail. It formats the string 1 only as "1.0" instead of "1.00" as I would expect. 
 
I took a look at what was in the report design file and the XML for the column looks like this: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
<cell id="341">
<property name="paddingBottom">0.1pt</property>
<data name="data_ratio" id="342">
<structure name="numberFormat">
<property name="pattern">#0.00</property>
</structure>
<property name="textAlign">center</property>
<property name="height">8pt</property>
<property name="width">24pt</property>
<property name="resultSetColumn">ratio</property>
</data>
</cell>
</pre>
Does anyone have any ideas? 
 
Thanks.

Find more posts tagged with

Comments

kclark

What version are you running? I did a copy paste of Jason's code and it worked as expected for me in 4.2.2 with a few environment changes. Have you tried changing colFormat = "#0.0000" to see what the results are?

femibyte

<blockquote class='ipsBlockquote' data-author="'kclark'" data-cid="115712" data-time="1365088960" data-date="04 April 2013 - 08:22 AM">
What version are you running? I did a copy paste of Jason's code and it worked as expected for me in 4.2.2 with a few environment changes. Have you tried changing colFormat = "#0.0000" to see what the results are? </blockquote>
I am running this in Eclipse Juno at the moment. It seems like I have 4.2.1. Should I upgrade to 4.2.2 then ?

femibyte

What environment changes did you make? I have checked and all my Birt plugins in Eclipse are version 4.2.2

kclark

I haven't made any env changes. I'm using Java 7, Windows 7 x64, I tested the code on 4.2.2 and 2.3. I also tested this on my Ubuntu VM. Can you attach your Java and the rptdesign?

femibyte

I have attached the java code that generates the .rptdesign as well as the .rptdesign file.

Thanks for your help.

femibyte

<blockquote class='ipsBlockquote' data-author="'kclark'" data-cid="115748" data-time="1365168384" data-date="05 April 2013 - 06:26 AM">
I haven't made any env changes. I'm using Java 7, Windows 7 x64, I tested the code on 4.2.2 and 2.3. I also tested this on my Ubuntu VM. Can you attach your Java and the rptdesign? </blockquote>
I've attached my rptdesign. Any suggestions/insights ?

femibyte

<blockquote class='ipsBlockquote' data-author="'femibyte'" data-cid="116174" data-time="1366637353" data-date="22 April 2013 - 06:29 AM">
I've attached my rptdesign. Any suggestions/insights ? </blockquote>
 
Can anybody help me with this issue ?