Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.7K 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
- 326 Dynamics CRM
- 110 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 994 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Excel buffer - cell width AND multiline
awarn
Member Posts: 261
Hi,
I have added two fields to the Excel Buffer table, Multiline and Cell Width. But it seems I cannot use both of these at the same time. In the excel buffer table I have this code:
IF "Cell Width" <> 0 THEN
XlWrkSht.Range(xlColID + xlRowID).Columns.ColumnWidth := "Cell Width";
XlWrkSht.Range(xlColID + xlRowID).WrapText := Multiline;
The problem is that when the Multiline is true, a caption 'Customer Name' prints in Excel as:
Custome
r Name
And if I set the column width to 68 (in the code, by setting the Cell Value field), then the cell width is ignored - and Excel prints the entire 'Customer Name' caption on one line, and the width is the width of the entire text (106 pixels).
Am I doing something wrong? It seems like the Column Width field is not working. The goal is to see in excel
Customer
Name
and to have the column slightly wider than the 'Customer' text.
-a
I have added two fields to the Excel Buffer table, Multiline and Cell Width. But it seems I cannot use both of these at the same time. In the excel buffer table I have this code:
IF "Cell Width" <> 0 THEN
XlWrkSht.Range(xlColID + xlRowID).Columns.ColumnWidth := "Cell Width";
XlWrkSht.Range(xlColID + xlRowID).WrapText := Multiline;
The problem is that when the Multiline is true, a caption 'Customer Name' prints in Excel as:
Custome
r Name
And if I set the column width to 68 (in the code, by setting the Cell Value field), then the cell width is ignored - and Excel prints the entire 'Customer Name' caption on one line, and the width is the width of the entire text (106 pixels).
Am I doing something wrong? It seems like the Column Width field is not working. The goal is to see in excel
Customer
Name
and to have the column slightly wider than the 'Customer' text.
-a
0