Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Conditional format in OBI Publisher Template Builder for Word

674483Jan 10 2009 — edited Jun 9 2010
Hi,

I'm creating a template in MSWord's Publisher. I inserted a table and I tried to add conditional formatting to some of the cells. Nothing special: just standard red color when the value is below 0.
In several places I've seen that I should go to the cell and do 'Insert>Conditional Format'. Unfortunately I get the following message then:
The conditional format is not inside a table and can therefore not be applied to a table row
I tried to google it, but I didn't find anything.

So I tried to do it with explicit xsl code. In the User's Guide I found an example and after my adjustments it looks like this:
<?if:_-__ROUND__FACTS_SUMMARY_V_._ACTUAL_COST_PREV_MON___0__<0?>
<xsl:attribute xdofo:ctx="block" name="background-color">red</xsl:attribute><?end if?>
<?_-__ROUND__FACTS_SUMMARY_V_._ACTUAL_COST_PREV_MON___0__?>
I put the above xsl code in 'Properties>Advenced' for a table cell.
And when I try to preview it as HTML I get the error:

Caused by: oracle.xdo.parser.v2.XSLException: <Line 45, Column 100>: XML-22047: (Error) Invalid instantiation of 'Attribute' in 'Element' context.
at oracle.xdo.parser.v2.XSLStylesheet.flushErrors(XSLStylesheet.java:1534)
...

I exported my XSL-FO Style Sheet and here you have the lines 41-48:
<fo:flow flow-name="region-body">
<fo:block xdofo:line-spacing="multiple:13.8pt" orphans="2" widows="2" linefeed-treatment="preserve" start-indent="5.4pt" text-align="start" padding-bottom="10.0pt" end-indent="5.4pt" padding-top="0.0pt" height="0.0pt" font-size="11.0pt" font-family="Calibri"/>
<fo:block xdofo:line-spacing="multiple:13.8pt" orphans="2" widows="2" linefeed-treatment="preserve" text-align="start" padding-bottom="0.25pt" end-indent="5.4pt" padding-top="0.25pt">
<fo:table start-indent="0.0pt" style-id="ts16" style-name="Table Grid" xdofo:table-summary="Template Table 1" xdofo:row-header-count="0">
<xsl:variable name="_XDOFOPOS2" select="number(1)"/>
<xsl:variable name="_XDOFOTOTAL" select="number(1)"/>
<fo:table-column column-width="45.5pt"/>
<fo:table-column column-width="57.2pt"/>

I can't see here anything related to my piece of code.

Do you have any suggestions what do I do wrong?
And, what's more important, what should I do, to make this conditional formatting run?

I'm using Template Builder v. 10.1.3.4.

I'm new to BI and not an expert in XSL, so please forgive me if the info in my post is incomplete. Let me know about it and I'll try to fill the gaps.

Thanks in advance.
Cheers,
WhatTheHell
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 7 2010
Added on Jan 10 2009
4 comments
8,322 views