When exporting to Doc or Excel there is no colour coding of the box

[vs00500773]

When exporting to Doc or Excel there is no colour coding of the boxed to indicate the RAG and this works fine on PDF but not on these two formats.

 

Any help or pointer is greatly appreciated

 

[hozawa]

I just tested with Jaspersoft Studio and colors were exported to xlsx without any problem.

[vs00500773]

Thanks.  Here is the code and let me know if I miss something

</textField>
                <rectangle>
                    <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="580" y="130" width="270" height="60" backcolor="#22B14C" uuid="b2320466-d37d-4bf6-a971-3fca7cbfab87">
                        <property name="com.jaspersoft.studio.unit.width" value="pixel"/>
                        <printWhenExpression><![CDATA[(($F{STATUS_NAME}.matches( "Approved") && $F{HRDBOOKED}.intValue()!=0) ||
($F{STATUS_NAME}.matches("Approved" )  && $F{NTHRD}.intValue() != 0) ||
((!$F{STATUS_NAME}.matches("Approved" )) && $F{NTHRD}.intValue()!=0 && $F{HRDBOOKED}.intValue()==0))||
($F{NTHRD}.intValue()==0 && $F{HRDBOOKED}.intValue()==0)]]></printWhenExpression>
                    </reportElement>
                </rectangle>
                <rectangle>
                    <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="580" y="130" width="270" height="60" backcolor="#FF0000" uuid="c3dd3981-91e5-496a-aa2e-b737af54ca55">
                        <printWhenExpression><![CDATA[!$F{STATUS_NAME}.matches( "Approved" ) && $F{HRDBOOKED}.intValue()>=1]]></printWhenExpression>
                    </reportElement>
                </rectangle>
                <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                    <reportElement positionType="Float" stretchType="RelativeToTallestObject" x="580" y="130" width="270" height="60" uuid="5aaf2362-76d8-4e4d-9542-78fe145f92e9">
                        <property name="com.jaspersoft.studio.unit.width" value="pixel"/>
                    </reportElement>
                    <box>
                        <topPen lineWidth="1.0"/>
                        <leftPen lineWidth="1.0"/>
                        <bottomPen lineWidth="1.0"/>
                        <rightPen lineWidth="1.0"/>
                    </box>
                    <textElement textAlignment="Center" verticalAlignment="Middle">
                        <font fontName="Arial" isBold="true"/>
                    </textElement>
                    <textFieldExpression><![CDATA[$F{STATUS_NAME}]]></textFieldExpression>
                </textField>

 

Thanks

-Venkitta

[hozawa]

Just test out. You only have backcolor in the first and second rectangle. Deleted the printWhenExpression and the exported xlsx had a green rectangle.