I have a program that sends more than 100 characters into a 40 character Excel field.
In Excel you can format the cell to be word Wrap and the 100 characters will wrap into 3 lines. In a Progress routine I can do the same.
However when you are using Excel directly if you use <alt> enter it will dictate where the line break is.
This is line one <alt> enter
This is Line two <alt> enter
This is Line three
I can't seem to figure out how I can send that sequence in a program. You can send CHR(10) etc but how do you send what you can type to the field?
Is this impossible or can it be done?
In Excel you can format the cell to be word Wrap and the 100 characters will wrap into 3 lines. In a Progress routine I can do the same.
However when you are using Excel directly if you use <alt> enter it will dictate where the line break is.
This is line one <alt> enter
This is Line two <alt> enter
This is Line three
I can't seem to figure out how I can send that sequence in a program. You can send CHR(10) etc but how do you send what you can type to the field?
Is this impossible or can it be done?