Unprintable Characters! Help!

HelpMePleaseHelpMePlease Member Posts: 6
Good day fellow NAV Developers.

I am currently struggling on an Excel Export, I have setup a Report to PrintToExcel via ExcelBuffer.
It generates the report in excel no problem. The problem is there are characters that are unbalancing my excel spreadsheet.

I have attached 2 pictures below.

1). One is a snip of the NAV data (Bering in mind that there are tons of these entries).

2). The other is a snip of Excel.

Would really appreciate if anyone could either help with code to eliminate these blocks in NAV or alternatively Excel help.

PS: I did Google around for solutions. None found just yet. Help!

Answers

  • Luc_VanDyckLuc_VanDyck Member, Moderator, Administrator Posts: 3,633
    This download can be useful: Remove Excel CR+LF Errors
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
Sign In or Register to comment.