Nav developer's blog
Translate This Page
Translate this page
Compare and Merge
Browse by Tags
Nav developer's blog
Tagged Content List
Dynamics NAV, customizing style sheets for export to MS Excel
A while a go we posted a blog decribing how to make some basic customizations to style sheets used for export to Excel. http://blogs.msdn.com/nav_developer/archive/2009/02/18/customizing-style-sheets-for-ms-excel.aspx This is an update to that blog. You can download updated sample objects from...
22 Apr 2009
Customizing style sheets for MS Excel
As of version 5.0, Dynamics NAV introduced the option to export forms to MS Office (Word or Excel). Data presented on the form are exported in an xml, formatted using style sheets then sent to Word/Excel/Other programs A Style Sheet tool for Dynamics NAV has later been released to help partners create...
18 Feb 2009
Dynamics NAV 2009 and MS Office Integration, send-to Excel and Word
This blog describes changes in office integration feature, send-to Excel and Word, when using RTC client in NAV 2009. Send-to menu option on RTC client is typically located in menu, under Actions - Send to option. Shortcuts for this functionality is added, but unlike version 5.0, only send -to Word...
16 Dec 2008
Dynamics NAV and export to Excel: Export dates as true excel dates
When running Send-to Excel functionality and exporting data to MS Excel using style sheets, all data exported form NAV is formatted as either numbers or strings. That also includes dates, that are exported as strings and not formatted as true dates in excel. As of update 1 for NAV 5.0 SP1, data.xml...
16 Dec 2008
Dynamics NAV 5.0 SP1 and export to Excel
A number of issues previously reported when running with Dynamics NAV 5.0 and using send-to Excel functionality, are now corrected. These issues include (among others): decimals exported as text, Item/Customer numbers exported as decimals, dates exported as decimals. To implement correction, update...
11 Nov 2008
Dynamics NAV 5.0 and Style Sheet issues, decimals exported as text
When using Send-to Excel option from NAV, decimals are exported as texts if Digit grouping symbol (Control Panel - Regional and Language Options) is a ' ' (whitespace). NAV uses ANSI 160 code character for space, which is not a space in ascii code table (normally used by windows applications). Consequently...
2 Jul 2008
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...
21 May 2008
Dynamics NAV 5.0 and style sheet issues, tab captions with local characters
Form tab captions that contain country specific characters (for example, Å in Swedish) will be displayed differently in MS Word/Excel, when using local language version of MS Office. For example, if running Nav 5.0 SE version and Customer card the first tab on the card (General) will be displayed as...
23 Apr 2008
Dynamics NAV 5.0 and Style Sheet issues
This post is starting of a summary of style sheet issues reported in Dynamics NAV 5.0 when using send-to Excel/Word functionality, and attempt to provide workaround suggestions for as many of these issues as possible. Most issues are related to regional settings and use of decimal separator and or...
22 Apr 2008
Page 1 of 1 (9 items)
© 2015 Microsoft Corporation.
Privacy & Cookies