title: Colour issue in generated xls file with JasperReports
body: <p>I am using Spring and iReport to generate jasper reports in excel format. All is working fine but I am having a single issue that the background colour of my reports in iReport is grey, but I am getting purplish hue in my generated Excel file.</p>
  
  <p>I am setting Create Custom Palette to true, still it is not having any effect.</p>
  
  <p>My Jrxml:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Charges Applicable" pageWidth="792" pageHeight="612" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="752" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" whenResourceMissingType="Empty" &gt;
      &lt;property name="net.sf.jasperreports.export.xls.white.page.background" value="false"/&gt;
      &lt;subDataset name="Table Dataset 1" &gt;
          &lt;parameter name="ContractId" class="java.lang.String"/&gt;
          &lt;parameter name="VersionNo" class="java.lang.String"/&gt;
          &lt;queryString&gt;
              &lt;![CDATA[SELECT S.TERM_COMMENTS FROM FCM_TX_TERMINATION_CHARGE_T S
      WHERE S.CONTRACT_ID=$P{ContractId} AND S.VERSION_NO=$P{VersionNo}]]&gt;
          &lt;/queryString&gt;
          &lt;field name="TERM_COMMENTS" class="java.lang.String"/&gt;
      &lt;/subDataset&gt;
      &lt;parameter name="ContractId" class="java.lang.String"/&gt;
      &lt;parameter name="VersionNo" class="java.lang.String"/&gt;
      &lt;queryString&gt;
          &lt;![CDATA[SELECT F.OFFSET_ABLE_AGAINST_SLA_FLAG SLA_PENALTY_APPLICABLE
       FROM FCM_TX_BASIC_CONTRACT_DTLS_T F
       WHERE F.CONTRACT_ID=$P{ContractId} AND F.VERSION_NO=$P{VersionNo}]]&gt;
      &lt;/queryString&gt;
      &lt;field name="SLA_PENALTY_APPLICABLE" class="java.lang.String"/&gt;
      &lt;summary&gt;
          &lt;band height="120" splitType="Stretch"&gt;
              &lt;crosstab&gt;
                  &lt;reportElement x="0" y="0" width="352" height="30" /&gt;
                  &lt;rowGroup name="SLA_PENALTY_APPLICABLE" width="200"&gt;
                      &lt;bucket class="java.lang.String"&gt;
                          &lt;bucketExpression&gt;&lt;![CDATA[$F{SLA_PENALTY_APPLICABLE}]]&gt;&lt;/bucketExpression&gt;
                      &lt;/bucket&gt;
                      &lt;crosstabRowHeader&gt;
                          &lt;cellContents backcolor="#F0F8FF" mode="Opaque"&gt;
                              &lt;textField&gt;
                                  &lt;reportElement positionType="Float" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="200" height="30" backcolor="#C9D9E7" /&gt;
                                  &lt;textElement textAlignment="Left" verticalAlignment="Middle"&gt;
                                      &lt;font fontName="Arial" size="8" isBold="true"/&gt;
                                  &lt;/textElement&gt;
                                  &lt;textFieldExpression&gt;&lt;![CDATA["Is SLA Penalty Applicable"]]&gt;&lt;/textFieldExpression&gt;
                              &lt;/textField&gt;
                          &lt;/cellContents&gt;
                      &lt;/crosstabRowHeader&gt;
                      &lt;crosstabTotalRowHeader&gt;
                          &lt;cellContents/&gt;
                      &lt;/crosstabTotalRowHeader&gt;
                  &lt;/rowGroup&gt;
                  &lt;columnGroup name="SLA_PENALTY_APPLICABLE1" height="0"&gt;
                      &lt;bucket class="java.lang.String"&gt;
                          &lt;bucketExpression&gt;&lt;![CDATA[$F{SLA_PENALTY_APPLICABLE}]]&gt;&lt;/bucketExpression&gt;
                      &lt;/bucket&gt;
                      &lt;crosstabColumnHeader&gt;
                          &lt;cellContents backcolor="#F0F8FF" mode="Opaque"&gt;
                              &lt;textField&gt;
                                  &lt;reportElement x="0" y="0" width="0" height="0" /&gt;
                                  &lt;textFieldExpression&gt;&lt;![CDATA[$V{SLA_PENALTY_APPLICABLE1}]]&gt;&lt;/textFieldExpression&gt;
                              &lt;/textField&gt;
                          &lt;/cellContents&gt;
                      &lt;/crosstabColumnHeader&gt;
                      &lt;crosstabTotalColumnHeader&gt;
                          &lt;cellContents/&gt;
                      &lt;/crosstabTotalColumnHeader&gt;
                  &lt;/columnGroup&gt;
                  &lt;measure name="SLA_PENALTY_APPLICABLEMeasure" class="java.lang.String"&gt;
                      &lt;measureExpression&gt;&lt;![CDATA[$F{SLA_PENALTY_APPLICABLE}]]&gt;&lt;/measureExpression&gt;
                  &lt;/measure&gt;
                  &lt;crosstabCell width="100" height="30"&gt;
                      &lt;cellContents&gt;
                          &lt;textField isBlankWhenNull="true"&gt;
                              &lt;reportElement x="0" y="0" width="100" height="30" /&gt;
                              &lt;textElement textAlignment="Left" verticalAlignment="Middle"&gt;
                                  &lt;font fontName="Arial" size="8"/&gt;
                              &lt;/textElement&gt;
                              &lt;textFieldExpression&gt;&lt;![CDATA[( $V{SLA_PENALTY_APPLICABLEMeasure}=="Y" ? "YES" : "NO" )]]&gt;&lt;/textFieldExpression&gt;
                          &lt;/textField&gt;
                      &lt;/cellContents&gt;
                  &lt;/crosstabCell&gt;
                  &lt;crosstabCell height="25" rowTotalGroup="SLA_PENALTY_APPLICABLE"&gt;
                      &lt;cellContents backcolor="#BFE1FF" mode="Opaque"&gt;
                          &lt;textField&gt;
                              &lt;reportElement x="0" y="0" width="50" height="25" /&gt;
                              &lt;textFieldExpression&gt;&lt;![CDATA[$V{SLA_PENALTY_APPLICABLEMeasure}]]&gt;&lt;/textFieldExpression&gt;
                          &lt;/textField&gt;
                      &lt;/cellContents&gt;
                  &lt;/crosstabCell&gt;
                  &lt;crosstabCell width="50" columnTotalGroup="SLA_PENALTY_APPLICABLE1"&gt;
                      &lt;cellContents backcolor="#BFE1FF" mode="Opaque"&gt;
                          &lt;textField&gt;
                              &lt;reportElement x="0" y="0" width="50" height="25" /&gt;
                              &lt;textFieldExpression&gt;&lt;![CDATA[$V{SLA_PENALTY_APPLICABLEMeasure}]]&gt;&lt;/textFieldExpression&gt;
                          &lt;/textField&gt;
                      &lt;/cellContents&gt;
                  &lt;/crosstabCell&gt;
                  &lt;crosstabCell rowTotalGroup="SLA_PENALTY_APPLICABLE" columnTotalGroup="SLA_PENALTY_APPLICABLE1"&gt;
                      &lt;cellContents backcolor="#BFE1FF" mode="Opaque"&gt;
                          &lt;textField&gt;
                              &lt;reportElement x="0" y="0" width="50" height="25" /&gt;
                              &lt;textFieldExpression&gt;&lt;![CDATA[$V{SLA_PENALTY_APPLICABLEMeasure}]]&gt;&lt;/textFieldExpression&gt;
                          &lt;/textField&gt;
                      &lt;/cellContents&gt;
                  &lt;/crosstabCell&gt;
              &lt;/crosstab&gt;
              &lt;componentElement&gt;
                  &lt;reportElement key="table" positionType="Float" x="0" y="60" width="180" height="60"/&gt;
                  &lt;jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd"&gt;
                      &lt;datasetRun subDataset="Table Dataset 1" &gt;
                          &lt;datasetParameter name="ContractId"&gt;
                              &lt;datasetParameterExpression&gt;&lt;![CDATA[$P{ContractId}]]&gt;&lt;/datasetParameterExpression&gt;
                          &lt;/datasetParameter&gt;
                          &lt;datasetParameter name="VersionNo"&gt;
                              &lt;datasetParameterExpression&gt;&lt;![CDATA[$P{VersionNo}]]&gt;&lt;/datasetParameterExpression&gt;
                          &lt;/datasetParameter&gt;
                          &lt;connectionExpression&gt;&lt;![CDATA[$P{REPORT_CONNECTION}]]&gt;&lt;/connectionExpression&gt;
                      &lt;/datasetRun&gt;
                      &lt;jr:column width="180" &gt;
                          &lt;jr:columnHeader height="30" rowSpan="1"&gt;
                              &lt;staticText&gt;
                                  &lt;reportElement positionType="Float" mode="Opaque" x="0" y="0" width="180" height="30" backcolor="#C9D9E7" /&gt;
                                  &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                                      &lt;font fontName="Arial" size="8" isBold="true"/&gt;
                                  &lt;/textElement&gt;
                                  &lt;text&gt;&lt;![CDATA[Comments]]&gt;&lt;/text&gt;
                              &lt;/staticText&gt;
                          &lt;/jr:columnHeader&gt;
                          &lt;jr:detailCell height="30" rowSpan="1"&gt;
                              &lt;textField isBlankWhenNull="true"&gt;
                                  &lt;reportElement positionType="Float" x="0" y="0" width="180" height="30" /&gt;
                                  &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                                      &lt;font fontName="Arial" size="8" isBold="false"/&gt;
                                  &lt;/textElement&gt;
                                  &lt;textFieldExpression&gt;&lt;![CDATA[$F{TERM_COMMENTS}]]&gt;&lt;/textFieldExpression&gt;
                              &lt;/textField&gt;
                          &lt;/jr:detailCell&gt;
                      &lt;/jr:column&gt;
                  &lt;/jr:table&gt;
              &lt;/componentElement&gt;
              &lt;staticText&gt;
                  &lt;reportElement mode="Opaque" x="0" y="40" width="180" height="20" backcolor="#C9D9E7"/&gt;
                  &lt;textElement&gt;
                      &lt;font fontName="Arial" isBold="true"/&gt;
                  &lt;/textElement&gt;
                  &lt;text&gt;&lt;![CDATA[Temination charges for convenience]]&gt;&lt;/text&gt;
              &lt;/staticText&gt;
          &lt;/band&gt;
      &lt;/summary&gt;
  &lt;/jasperReport&gt;
  </code></pre>