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
- 298 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
Excel Buffer and Excel Language Format
einsTeIn.NET
Member Posts: 1,050
Hi guys,
I've got a problem with Excel Buffer and Excel Language Format. I've got an Excel Spreadsheet and I want to import it in NAV Classic Client by Excel Buffer. When my computer's language is set to German a cell that contains a date in Excel is displayed in the standard format of Germany. The same for English (US) and Dutch, even if you use the same Excel file. I assume that the value is stored in some kind of internal format and is only displayed in the country specific format at runtime. From my point of view that would be ok. But when I import the file into Excel Buffer in English and in Dutch the field "Cell Value as Text" contains the value like it is displayed in Excel whereas in German the value of "Cell Value as Text" is formatted in another way.
E.g.
I've got a problem with Excel Buffer and Excel Language Format. I've got an Excel Spreadsheet and I want to import it in NAV Classic Client by Excel Buffer. When my computer's language is set to German a cell that contains a date in Excel is displayed in the standard format of Germany. The same for English (US) and Dutch, even if you use the same Excel file. I assume that the value is stored in some kind of internal format and is only displayed in the country specific format at runtime. From my point of view that would be ok. But when I import the file into Excel Buffer in English and in Dutch the field "Cell Value as Text" contains the value like it is displayed in Excel whereas in German the value of "Cell Value as Text" is formatted in another way.
E.g.
-
English
- Excel: 7/31/2011
- Excel Buffer: 7/31/2011
-
Dutch
- Excel: 31-7-2011
- Excel Buffer: 31-7-2011
-
German
- Excel: 31.07.2011
- Excel Buffer: 31072011
"Money is likewise the greatest chance and the greatest scourge of mankind."
0