PrintInformation

From: "Yan, Charlene" <Charlene Yan thomsonlearning com>
To: <gnome-list gnome org>
Subject: PrintInformation
Date: Thu Jun 19 21:52:05 2003
All,

I'm trying to set the header, footer and print-orientation information.  Somehow, the result Excel spreadsheet does not take any of these.  Does anyone has this experience?  Here is my stylesheet:

<?xml version="1.0"?>

<!-- CVS $Id: page2xls.xsl,v 1.2 2003/05/07 04:57:13 vgritsenko Exp $ -->

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
                              xmlns:sql="http://apache.org/cocoon/SQL/2.0";
                             xmlns:gmr="http://www.gnome.org/gnumeric/v7"; >

  <xsl:param name="view-source"/>

  <xsl:template match="solution">
   <gmr:Workbook xmlns:gmr="http://www.gnome.org/gnumeric/v7";>
     <gmr:Attributes>
    <gmr:Attribute>
      <gmr:name>WorkbookView::show_horizontal_scrollbar</gmr:name>
      <gmr:type>4</gmr:type>
      <gmr:value>TRUE</gmr:value>
    </gmr:Attribute>
    <gmr:Attribute>
      <gmr:name>WorkbookView::show_vertical_scrollbar</gmr:name>
      <gmr:type>4</gmr:type>
      <gmr:value>TRUE</gmr:value>
    </gmr:Attribute>
    <gmr:Attribute>
      <gmr:name>WorkbookView::show_notebook_tabs</gmr:name>
      <gmr:type>4</gmr:type>
      <gmr:value>TRUE</gmr:value>
    </gmr:Attribute>
  </gmr:Attributes>
  
  <gmr:Summary>
    <gmr:Item>
      <gmr:name>application</gmr:name>
      <gmr:val-string>gnumeric</gmr:val-string>
    </gmr:Item>
    <gmr:Item>
      <gmr:name>author</gmr:name>
      <gmr:val-string>David Gilbert</gmr:val-string>
    </gmr:Item>
  </gmr:Summary>
  
  <gmr:SheetNameIndex>
    <gmr:SheetName>Sheet1</gmr:SheetName>
  </gmr:SheetNameIndex>
  
  <gmr:Names/>
  
  <gmr:Geometry Width="734" Height="422"/>
    <gmr:Sheets>
      <gmr:Sheet DisplayFormulas="false" HideZero="false" HideGrid="false"
HideColHeader="false" HideRowHeader="false" DisplayOutlines="true"
OutlineSymbolsBelow="true" OutlineSymbolsRight="true">
        <gmr:Name><xsl:value-of select="name"/></gmr:Name>
        <gmr:MaxCol>-1</gmr:MaxCol>
        <gmr:MaxRow>-1</gmr:MaxRow>
        <gmr:Zoom>1.000000</gmr:Zoom>
        <gmr:Names/>
        <gmr:PrintInformation>
          <gmr:Margins>
            <gmr:top Points="28.3" PrefUnit="cm"/>
            <gmr:bottom Points="28.3" PrefUnit="cm"/>
            <gmr:left Points="0" PrefUnit="cm"/>
            <gmr:right Points="0" PrefUnit="cm"/>
            <gmr:header Points="0" PrefUnit="cm"/>
            <gmr:footer Points="0" PrefUnit="cm"/>
          </gmr:Margins>
          <gmr:vcenter value="0"/>
          <gmr:hcenter value="0"/>
          <gmr:grid value="0"/>
          <gmr:even_if_only_styles value="0"/>
          <gmr:monochrome value="0"/>
          <gmr:draft value="0"/>
          <gmr:titles value="0"/>
          <gmr:repeat_top value=""/>
          <gmr:repeat_left value=""/>
          <gmr:order>r_then_d</gmr:order>
          <gmr:orientation>landscape</gmr:orientation>
          <gmr:Header Left="" Middle="Page &amp;[PAGE]"  Right=""/>
          <gmr:Footer Left="" Middle="Page &amp;[PAGE]" Right=""/>
          <gmr:paper>A4</gmr:paper>
        </gmr:PrintInformation>    
      <gmr:Styles>   
        <gmr:StyleRegion startRow="0" endRow="0" startCol="0" endCol="5">
          <gmr:Style HAlign="1" VAlign="4" WrapText="0" Orient="1" Shade="2" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="C0C0:C0C0:C0C0" PatternColor="C0C0:C0C0:C0C0" Format="General">
            <gmr:StyleBorder>
              <gmr:Top Style="5"/>
              <gmr:Bottom Style="0"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="0" endRow="0" startCol="0" endCol="0">
          <gmr:Style HAlign="1" VAlign="4" WrapText="0" Orient="1" Shade="2" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="C0C0:C0C0:C0C0" PatternColor="C0C0:C0C0:C0C0" Format="General">
            <gmr:StyleBorder>
              <gmr:Top Style="5"/>
              <gmr:Bottom Style="0"/>
              <gmr:Left Style="5"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="1" endRow="2" startCol="1" endCol="5">
          <gmr:Style HAlign="1" VAlign="4" WrapText="0" Orient="1" Shade="2" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="C0C0:C0C0:C0C0" PatternColor="C0C0:C0C0:C0C0" Format="General">
            <gmr:StyleBorder>
              <gmr:Top Style="0"/>
              <gmr:Bottom Style="0"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="3" endRow="3" startCol="1" endCol="15">
          <gmr:Style HAlign="1" VAlign="4" WrapText="0" Orient="1" Shade="2" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="C0C0:C0C0:C0C0" PatternColor="C0C0:C0C0:C0C0" Format="General">
            <gmr:StyleBorder>
              <gmr:Top Style="0"/>
              <gmr:Bottom Style="5"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="1" endRow="2" startCol="0" endCol="0">
          <gmr:Style HAlign="1" VAlign="4" WrapText="0" Orient="1" Shade="2" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="C0C0:C0C0:C0C0" PatternColor="C0C0:C0C0:C0C0" Format="General">
            <gmr:StyleBorder>
              <gmr:Top Style="0"/>
              <gmr:Bottom Style="0"/>
              <gmr:Left Style="5"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="0" endRow="0" startCol="0" endCol="0">
          <gmr:Style HAlign="1" VAlign="4" WrapText="0" Orient="1" Shade="2" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="C0C0:C0C0:C0C0" PatternColor="C0C0:C0C0:C0C0" Format="General">
            <gmr:StyleBorder>
              <gmr:Top Style="5"/>
              <gmr:Bottom Style="0"/>
              <gmr:Left Style="5"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="3" endRow="3" startCol="0" endCol="0">
          <gmr:Style HAlign="1" VAlign="4" WrapText="0" Orient="1" Shade="2" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="C0C0:C0C0:C0C0" PatternColor="C0C0:C0C0:C0C0" Format="General">
            <gmr:StyleBorder>
              <gmr:Top Style="0"/>
              <gmr:Bottom Style="5"/>
              <gmr:Left Style="5"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="0" endRow="0" startCol="6" endCol="6">
          <gmr:Style HAlign="8" VAlign="2" WrapText="0" Orient="1" Shade="2" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="C0C0:C0C0:C0C0" PatternColor="C0C0:C0C0:C0C0" Format="General">  
            <gmr:Font Unit="12" Bold="1" Italic="1" Underline="0" StrikeThrough="0">Times New Roman</gmr:Font>         
            <gmr:StyleBorder>
              <gmr:Top Style="5"/>
              <gmr:Bottom Style="0"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="1" endRow="2" startCol="6" endCol="6">
          <gmr:Style HAlign="8" VAlign="2" WrapText="0" Orient="1" Shade="2" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="C0C0:C0C0:C0C0" PatternColor="C0C0:C0C0:C0C0" Format="General">  
            <gmr:Font Unit="8" Bold="1" Italic="1" Underline="0" StrikeThrough="0">Times New Roman</gmr:Font>         
            <gmr:StyleBorder>
              <gmr:Top Style="0"/>
              <gmr:Bottom Style="0"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="0" endRow="0" startCol="7" endCol="15">
          <gmr:Style HAlign="8" VAlign="2" WrapText="0" Orient="1" Shade="2" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="C0C0:C0C0:C0C0" PatternColor="C0C0:C0C0:C0C0" Format="General">  
            <gmr:StyleBorder>
              <gmr:Top Style="5"/>
              <gmr:Bottom Style="0"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="1" endRow="2" startCol="7" endCol="15">
          <gmr:Style HAlign="8" VAlign="2" WrapText="0" Orient="1" Shade="2" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="C0C0:C0C0:C0C0" PatternColor="C0C0:C0C0:C0C0" Format="General">  
            <gmr:StyleBorder>
              <gmr:Top Style="0"/>
              <gmr:Bottom Style="0"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="0" endRow="0" startCol="16" endCol="16">
          <gmr:Style HAlign="4" VAlign="2" WrapText="0" Orient="1" Shade="2" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="C0C0:C0C0:C0C0" PatternColor="C0C0:C0C0:C0C0" Format="General">  
            <gmr:Font Unit="10" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Times New Roman</gmr:Font>
            <gmr:StyleBorder>
              <gmr:Top Style="5"/>
              <gmr:Bottom Style="0"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="1" endRow="2" startCol="16" endCol="16">
          <gmr:Style HAlign="4" VAlign="2" WrapText="0" Orient="1" Shade="2" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="C0C0:C0C0:C0C0" PatternColor="C0C0:C0C0:C0C0" Format="General">  
            <gmr:Font Unit="10" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Times New ROman</gmr:Font>
            <gmr:StyleBorder>
              <gmr:Top Style="0"/>
              <gmr:Bottom Style="0"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="3" endRow="3" startCol="16" endCol="16">
          <gmr:Style HAlign="4" VAlign="2" WrapText="0" Orient="1" Shade="2" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="C0C0:C0C0:C0C0" PatternColor="C0C0:C0C0:C0C0" Format="General">  
            <gmr:Font Unit="10" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Times New Roman</gmr:Font>
            <gmr:StyleBorder>
              <gmr:Top Style="0"/>
              <gmr:Bottom Style="5"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="0" endRow="0" startCol="17" endCol="17">
          <gmr:Style HAlign="4" VAlign="2" WrapText="0" Orient="1" Shade="2" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="C0C0:C0C0:C0C0" PatternColor="C0C0:C0C0:C0C0" Format="General">  
            <gmr:StyleBorder>
              <gmr:Top Style="5"/>
              <gmr:Bottom Style="0"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="5"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="3" endRow="3" startCol="17" endCol="17">
          <gmr:Style HAlign="4" VAlign="2" WrapText="0" Orient="1" Shade="2" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="C0C0:C0C0:C0C0" PatternColor="C0C0:C0C0:C0C0" Format="General">  
            <gmr:StyleBorder>
              <gmr:Top Style="0"/>
              <gmr:Bottom Style="5"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="5"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="1" endRow="2" startCol="17" endCol="17">
          <gmr:Style HAlign="4" VAlign="2" WrapText="0" Orient="1" Shade="2" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="C0C0:C0C0:C0C0" PatternColor="C0C0:C0C0:C0C0" Format="General">  
            <gmr:StyleBorder>
              <gmr:Top Style="0"/>
              <gmr:Bottom Style="0"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="5"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="4" endRow="4" startCol="1" endCol="16">
          <gmr:Style HAlign="4" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:StyleBorder>
              <gmr:Top Style="0"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="5" endRow="5" startCol="0" endCol="0">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:Font Unit="10" Bold="1" Italic="0" Underline="0" StrikeThrough="0">Times New Roman</gmr:Font>
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="1"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="5" endRow="5" startCol="17" endCol="17">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">              
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="0"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="1"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>        
        <gmr:StyleRegion startRow="6" endRow="17" startCol="0" endCol="1">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">              
            <gmr:Font Unit="10" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Times New Roman</gmr:Font>
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="1"/>
              <gmr:Right Style="1"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="6" endRow="17" startCol="2" endCol="3">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">              
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="6" endRow="17" startCol="4" endCol="4">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">              
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="1"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="5" endRow="5" startCol="6" endCol="6">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:Font Unit="10" Bold="1" Italic="0" Underline="0" StrikeThrough="0">Times New Roman</gmr:Font>
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="6" endRow="17" startCol="6" endCol="6">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:Font Unit="10" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Times New Roman</gmr:Font>
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="1"/>
              <gmr:Right Style="1"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="6" endRow="17" startCol="7" endCol="7">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="1"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="6" endRow="17" startCol="8" endCol="9">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="6" endRow="17" startCol="10" endCol="10">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="1"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="5" endRow="5" startCol="11" endCol="11">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:Font Unit="10" Bold="1" Italic="0" Underline="0" StrikeThrough="0">Times New Roman</gmr:Font>
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="6" endRow="10" startCol="11" endCol="11">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:Font Unit="10" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Times New Roman</gmr:Font>
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="1"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="6" endRow="10" startCol="12" endCol="13">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="6" endRow="10" startCol="14" endCol="14">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="1"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="6" endRow="10" startCol="15" endCol="15">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="1"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="6" endRow="10" startCol="16" endCol="16">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="6" endRow="10" startCol="17" endCol="17">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="1"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="11" endRow="11" startCol="11" endCol="11">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="0" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="0"/>
              <gmr:Left Style="1"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="12" endRow="12" startCol="11" endCol="11">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:Font Unit="10" Bold="1" Italic="0" Underline="0" StrikeThrough="0">Times New Roman</gmr:Font>
            <gmr:StyleBorder>
              <gmr:Top Style="0"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="1"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="13" endRow="13" startCol="11" endCol="11">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:Font Unit="10" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Times New Roman</gmr:Font>
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="1"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="13" endRow="13" startCol="12" endCol="12">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:Font Unit="10" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Times New Roman</gmr:Font>
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="1"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="13" endRow="13" startCol="13" endCol="13">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:Font Unit="10" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Times New Roman</gmr:Font>
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="1"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="13" endRow="13" startCol="14" endCol="14">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="13" endRow="13" startCol="15" endCol="15">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="1"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="13" endRow="13" startCol="16" endCol="16">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:Font Unit="10" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Times New Roman</gmr:Font>
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="1"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="13" endRow="13" startCol="17" endCol="17">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="1"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="15" endRow="15" startCol="11" endCol="11">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:Font Unit="10" Bold="1" Italic="0" Underline="0" StrikeThrough="0">Times New Roman</gmr:Font>
            <gmr:StyleBorder>
              <gmr:Top Style="0"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="1"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="16" endRow="16" startCol="11" endCol="11">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:Font Unit="10" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Times New Roman</gmr:Font>
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="1"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="16" endRow="16" startCol="12" endCol="12">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="1"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="16" endRow="16" startCol="13" endCol="13">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="1"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="16" endRow="16" startCol="14" endCol="14">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:Font Unit="10" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Times New Roman</gmr:Font>
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="16" endRow="16" startCol="15" endCol="16">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="16" endRow="16" startCol="17" endCol="17">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="1"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="17" endRow="17" startCol="11" endCol="11">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:Font Unit="10" Bold="0" Italic="0" Underline="0" StrikeThrough="0">Times New Roman</gmr:Font>
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="1"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="17" endRow="17" startCol="12" endCol="12">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="17" endRow="17" startCol="13" endCol="13">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="1"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="17" endRow="17" startCol="14" endCol="14">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="1"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="17" endRow="17" startCol="15" endCol="16">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="17" endRow="17" startCol="17" endCol="17">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:StyleBorder>
              <gmr:Top Style="1"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="1"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        <gmr:StyleRegion startRow="19" endRow="19" startCol="0" endCol="0">
          <gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" Locked="1"
                     Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="FFFF:FFFF:FFFF" Format="General">  
            <gmr:Font Unit="10" Bold="1" Italic="0" Underline="0" StrikeThrough="0">Times New Roman</gmr:Font>
            <gmr:StyleBorder>
              <gmr:Top Style="0"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="0"/>
              <gmr:Right Style="0"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
        
            
      </gmr:Styles>
      <gmr:Cols>
        <gmr:ColInfo No="0" Unit="52"/>
        <gmr:ColInfo No="1" Unit="42"/>
        <gmr:ColInfo No="2" Unit="45" Count="2"/>
        <gmr:ColInfo No="4" Unit="42"/>
        <gmr:ColInfo No="5" Unit="37"/>
        <gmr:ColInfo No="6" Unit="52"/>
        <gmr:ColInfo No="7" Unit="37"/>
        <gmr:ColInfo No="8" Unit="41"/>
        <gmr:ColInfo No="9" Unit="59"/>
        <gmr:ColInfo No="10" Unit="42"/>
        <gmr:ColInfo No="11" Unit="45"/>
        <gmr:ColInfo No="12" Unit="27"/>
        <gmr:ColInfo No="13" Unit="42"/>
        <gmr:ColInfo No="14" Unit="36"/>
        <gmr:ColInfo No="15" Unit="24"/>
        <gmr:ColInfo No="16" Unit="35"/>
        <gmr:ColInfo No="17" Unit="25"/>
      </gmr:Cols>
      <gmr:Rows>
        <gmr:RowInfo No="0" Unit="13.5"/>
        <gmr:RowInfo No="1" Unit="13.5"/>
        <gmr:RowInfo No="2" Unit="13.5"/>
        <gmr:RowInfo No="3" Unit="13.5"/>
        <gmr:RowInfo No="4" Unit="13.5"/>
        <gmr:RowInfo No="5" Unit="13.5"/>
        <gmr:RowInfo No="6" Unit="13.5"/>
        <gmr:RowInfo No="7" Unit="13.5"/>
      </gmr:Rows>
      <gmr:Cells>      
      <gmr:Cell Col="6l="14" Row="26" ValueType="60">
      Locat
     </gmr:Cell>
     <gmr:Cell Col="15" Row="26" ValueType="60">
      ion
     </gmr:Cell>
     <gmr:Cell Col="16" Row="26" ValueType="60">
      Price
     </gmr:Cell>   
     <gmr:Cell Col="3"  Row="31" ValueType="60">
      <xsl:attribute name="Row">
         <xsl:value-of select="32 + count(//buProdId)"/>
      </xsl:attribute>     
       IF XTREME INSTALLATION IS REQUIRED, CHECK THE REQUIRED, SHADED, FORMAT BOX ABOVE
     </gmr:Cell>
     <gmr:Cell Col="0"  Row="31" ValueType="60">
      <xsl:attribute name="Row">
         <xsl:value-of select="28 + count(//buProdId)"/>
      </xsl:attribute>     
       Comments
     </gmr:Cell>
     
     
     	  <xsl:apply-templates/>
      </gmr:Cells>      
      </gmr:Sheet>
     </gmr:Sheets>
    </gmr:Workbook>
  </xsl:template>

  <xsl:template match="content">
      
      <xsl:apply-templates/>
  </xsl:template>

  <xsl:template match="tlnCustomer">
     <gmr:Cell Col="1" Row="6" ValueType="60">
      <xsl:value-of select="name"/>
     </gmr:Cell>  
     <xsl:if test="buAccountId!=''">
      <gmr:Cell Col="1" Row="7" ValueType="60">
        <xsl:value-of select="buAccountId"/>
      </gmr:Cell>
     </xsl:if> 
     <xsl:apply-templates/>
  </xsl:template>
  
  <xsl:template match="tlnCustContacts">
       
     <xsl:apply-templates/>
  </xsl:template>

  <xsl:template match="custContact">
       
     <xsl:if test="contactTypeId='CLO'">
      <xsl:if test="officePhone!=''">
      <gmr:Cell Col="1" Row="15" ValueType="60">
        <xsl:value-of select="officePhone"/>
      </gmr:Cell>
      </xsl:if>
      <xsl:if test="fax!=''">
      <gmr:Cell Col="1" Row="16" ValueType="60">
        <xsl:value-of select="fax"/>
      </gmr:Cell>
      </xsl:if>
      <xsl:if test="email!=''">
      <gmr:Cell Col="1" Row="17" ValueType="60">
        <xsl:value-of select="email"/>
      </gmr:Cell>
      </xsl:if>
     </xsl:if> 

  </xsl:template>

  <xsl:template match="buProdId">          
     <gmr:Cell Col="0"  Row="27" ValueType="60">
      <xsl:variable name="rownumber"><xsl:number level="any" count="//buProdId"/></xsl:variable>
      <xsl:attribute name="Row">
         <xsl:value-of select="26 + $rownumber"/>
      </xsl:attribute>
       1
     </gmr:Cell>
     <gmr:Cell Col="1late>
  

</xsl:stylesheet>
[Date Prev][Date Next] [Thread Prev][Thread Next] [Thread Index] [Date Index] [Author Index]