Send to Excel - XML format

Tbi
Tbi Member Posts: 33
edited 2009-04-12 in NAV/Navision Classic Client
Hi.

I have a problem with the Send to Excel function. I am not able to format the output to Excel the way I want. It seems that I am missing the datatype in the XML object that is sent to LaunchApp in Application Launch Management. When I saves the XML file (by using the Debug option in Style Sheet Setup) it does not contain any datatype of the values. Eks: 
<Row>
      <Control type="TextBox" value="31.12.07" width="1640" id="2" name="Posting Date"/>
      ...
</Row>

Then I am not able to format for example dates and texts in different ways.
Does anyone have the same problem, and is it possible to edit the XML that is sent to LaunchApp in Application Launch Management?

-Tbi.

Comments

  • martinc
    martinc Member Posts: 1
    Hi,

    we are having the same problem on NAV 5.0 SP1. The XML is missing the "subtype" property which should be "number" or "Decimal" for numbers as I found out in various blog-posts and the like. Therefore all our dates and numbers are formatted as text.

    Anybody got an idea what we could do about this?

    Best regards,
    Martin
  • canadian_bacon
    canadian_bacon Member Posts: 91
    I think there may be a hotfix for this...but it may not solve your problems.

    To start, then, I would look at codeunit 403.

Categories