× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. JAVA400-L
  3. April 2014

Re: Possible issue writing to Excel and trying to get multiple lines in a cell

hi Chuck

I believe I tried that, too - will verify - with the same result.

Vern

On 4/29/2014 11:27 AM, CRPence wrote:
On 29-Apr-2014 10:56 -0500, Vernon Hamberg wrote:

<<SNIP>>

I have content in a cell that is best presented in multiple lines -
not rows, for good reasons. In Excel, this is done with the Alt-Enter
to get new lines.

In Excel, you can put a value in a cell that has CHAR(10) - NL -
between lines - this is how it is done.

On the i, I'm using x'15' for the NL.

So I insert NL between the values, as here -
KitchenNLService AreaNLExterior

This should display in the cell like this -

Kitchen
Service Area
Exterior

Instead, it looks like this -

KitchenService
AreaExterior

It seems the control character x'15' has been stripped - I want it
to convert to ASCII x'0A' <<SNIP>>

If the ASCII 0x0A is the desired effect, then the EBCDIC 0x25 would seem more appropriate; i.e. those are both LF (Line Feed), not either of NL (New Line) or NEL (Next Line).



As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.