Transformation syntax

[ole_geismar2]

I am parsing at table named "header" to the transformation containing all the header information to my list which is built as XML.

Among these tablefields are these two:

• "TILGANG" - the heading-text that is to be inserted in each column
• "RGB_BACK" - the background-colour-code in RGB format, like "#FFFFFF".

I made a loop where I successfuly insert the header-text, using "value ref" on "tilgang" into the XML-string, but where the colour code (Interior) is fixed:

<tt:loop ref=".header" name="H">
 <Cell ss:StyleID="Hstock">
   <Interior ss:Color="#007A37"/>
   <Data     ss:Type="String"> <tt:value ref="$H.tilgang"/></Data>
 </Cell>
</tt:loop>

But when I try to insert the colour code "rgb_back" in a similar way; I get a syntax error.

<tt:loop ref=".header" name="H">
 <Cell ss:StyleID="Hstock">
   <Interior ss:Color=<tt:value ref="$H.rgb_back"/>/>
   <Data     ss:Type="String"> <tt:value ref="$H.tilgang"/></Data>
 </Cell>
</tt:loop>

Obviously, there is something wrong with the syntax in the "Interior" line, but what?

[Sandra_Rossi]

   <Interior>
     <tt:attribute name="ss:Color" value-ref="$H.rgb_back"/>
   </Interior>

[ole_geismar2]

Thank you Sandra, That was the push I needed.