Report Customization - Highlight cells in an Excel Report

Wednesday, December 23, 2015 9:45:37 PM
I would like to highlight certain cells in my Excel report with a background color.  I've tried the below structure - which works for HTML output... but not for reports in Excel 2007.
Does anyone know of a way to accomplish this report customization?  

FOR EXAMPLE...

<xsl:if test="MyXMLval='Good'">
<td style="background-color:green">
<xsl:value-of select="Passed" />
</td>
</xsl:if>

<xsl:if test="MyXMLval='Bad'">
<td style="background-color:red">
<xsl:value-of select="Failed" />
</td>
</xsl:if>
1 Replies
Tuesday, January 5, 2016 5:14:16 PM
Avatar
re: bkstigler on Wednesday, December 23, 2015 9:45:37 PM
Hi Brian

The Excel 2007 format is generated from the HTML and sent to Excel (unlike the 2003 format which converts to SpreadsheetML 2003 format XML), so it should pickup any supported HTML styles.

Please submit a help desk ticket if you need more direct support from Inflectra.

Regards
Adam
Statistics
  • Started: Wednesday, December 23, 2015 9:45:37 PM
  • Last Reply: Tuesday, January 5, 2016 5:14:16 PM
  • Replies: 1
  • Views: 236