I have a multi line field on a form which is then saved to a cell. Text that contains a tab character (for example "ABC" <tab> "DEF" is displayed properly in the form field but, when the cell is printed to a PDF printer, the "C" and the "D" overlap. does anyone know what may be causing this?
Thanks, Joe
I am guessing here, but I'll put my lunch money on that the so-called tab character isn't really a tab (ASCII 7) but a line feed (ASCII 10). What the printer wants is both a carriage return (ASCII 13) and line feed (ASCII 10). Welcome to the world of teletype machines.
If that is the case, You may have to "convert" the text =Substitute(CellRef,Char (10),Char(10)&CHAR(13)) or you could highlight the range and use CTRL-H with the same substitutions. It will not appear any different to Excel, but it may make a difference to the PDF Printer.
The question is why are you sending it to a PDF printer when Excel 2013 allows you to save the sheet(s) as PDF.
This piece of code converts a string to its ASCII equivalent characters so you can see what is really there.
Please Login or Register to view this content.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks