Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 295 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Send to Excel - XML format
Tbi
Member Posts: 33
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:
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.
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.
0
Comments
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
To start, then, I would look at codeunit 403.