Hello,
When trying to copy data from a form to anExcel Sheet in NAV 2009 R2, when there are special characacter like Quotes (") or / in description column, there is change in line in the Excel.
Previous versions was not having this issue. Has someone encountered this issue and knows about a fix for this.
P.S Text to column in excel does not work
Thannks a lot for your help,
Rgds,
*This post is locked for comments
Hello,
Thanks for yor answer.
The Excel icon work well and it understands speicla character but as Excel icon export does not support matric exports, We were proceeding with usual copy/paste
Actually user on classic client was pressing on enter key (CR/LR character being inserted thus causing change in line) on description field. I found a countersolution bu running a code unit to remove tab mand CR/LR characters in description fields. We are going to try that and see if it works.
Thanks again,
Rgds
hi,
you can find some hotfixes about special characters here (but only about RTC & pages i think)
www.waldo.be/.../nav-2009-2009-r2
Test
i made some test (only on native database) with NAV 209 R2 build 32012 -> copy\past from tables\forms with special characters and export to excel using click on excel icon works correctly
(you can try this scenario on Cronus Database) > try after on SQL Server Cronus database
i think that you can have SQL Server configuration problems or NAV database configuration (character substitution setted on database property)
let me know.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (