Dynamics NAV 5.0 and Style Sheet issues, issue with ‘/’ character in customer(vendor) name

When running forms like Customer (Vendor) Ledger Entries and Apply Customer(Vendor) Ledger Entries, and selecting: send-to Excel, the following error occurs  if customer (vendor) name contains character ‘/’:

Problems came up in the following areas during load:

Workbook setting ….

To correct this issue, open the style sheet file in notepad, default file is NavisionFormToExcel, placed in Stylesheet folder of the Client folder. Browse to the following section and replace the marked line :  

 <xsl:template match=”Control[@type=’TableBox’]”>
  <Worksheet xmlns=”urn:schemas-microsoft-com:office:spreadsheet”>
   <xsl:attribute name=”ss:Name”>
    <xsl:variable name=”TableBoxCaption”>
           <xsl:value-of select=”//Object/@caption”/>    <!– replace this line !–>
    </xsl:variable>

with 

     <xsl:value-of select=”translate(//Object/@caption,’\/:*?>|’,”)”/>

Then browse to the following section and replace the section:

 <xsl:template match=”Control[@type=’Frame’]”>
  <Worksheet xmlns=”urn:schemas-microsoft-com:office:spreadsheet”>
   <xsl:attribute name=”ss:Name”>
    <xsl:value-of select=”@caption”/>    <!–changed line!–>
    <xsl:if test=”@caption = ””>
     <xsl:variable name=”TableBoxCaption”>
      <xsl:value-of select=”//Object/@caption”/>    <!–changed line!–>
     </xsl:variable>

with:

 <xsl:template match=”Control[@type=’Frame’]”>
  <Worksheet xmlns=”urn:schemas-microsoft-com:office:spreadsheet”>
   <xsl:attribute name=”ss:Name”>
    <xsl:value-of select=”translate(@caption,’\/:*?>|’,”)”/>  <!–changed line!–>
    <xsl:if test=”@caption = ””>
     <xsl:variable name=”TableBoxCaption”>
      <xsl:value-of select=”translate(//Object/@caption,’\/:*?>|’,”)”/> <!–changed line!–>
     </xsl:variable>

Jasminka Vukovic

Microsoft Dynamics NO