Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K 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
- 280 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
Options
Footer text font size is distorted when exported to Excel
engsiong75
Member Posts: 143
I am working on a report in NAV 2013 R2. The report prints correctly in pdf as well as on the printer.
The users still need the report to print to Excel and they are doing so from the Print > Microsoft Excel button.
The information in the report is exported correctly to Excel except the Page Footer. It is rendered to Excel Footer with a size font of 81 (Too large).
I have done on some research and according to this link "http://msdn.microsoft.com/en-us/library/dd255234.aspx";
there are some limitation regarding the Page footer when rendered in Excel:
1) The page footer in the report will be rendered as the Excel footer.
2) Only 256 characters will be render in the Excel footer.
3) Only text boxes will be rendered.
I can live with the limitations. However, I am at a loss to explain why the Excel footer has a font size of 81. The worst part of the story is that there is report with a similar page footer that is rendering correctly in Excel. There is no difference in the font size used. There is a little different in the text printed.
Has anyone encountered this issue before? Does anyone have any suggestion?
The users still need the report to print to Excel and they are doing so from the Print > Microsoft Excel button.
The information in the report is exported correctly to Excel except the Page Footer. It is rendered to Excel Footer with a size font of 81 (Too large).
I have done on some research and according to this link "http://msdn.microsoft.com/en-us/library/dd255234.aspx";
there are some limitation regarding the Page footer when rendered in Excel:
1) The page footer in the report will be rendered as the Excel footer.
2) Only 256 characters will be render in the Excel footer.
3) Only text boxes will be rendered.
I can live with the limitations. However, I am at a loss to explain why the Excel footer has a font size of 81. The worst part of the story is that there is report with a similar page footer that is rendering correctly in Excel. There is no difference in the font size used. There is a little different in the text printed.
Has anyone encountered this issue before? Does anyone have any suggestion?
0