
December 14th, 2001, 03:01 AM
|
|
Junior Member
|
|
Join Date: Mar 2001
Location: Augsburg, Germany
Posts: 0
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
How to get linefeeds into Excel cells?
Hi,
in one of my programs I write out a string into the Windows clipboard for pasting it into an Excel sheet afterwards. In some cases I want Excel to display a linefeed within a single cell. Manually this is done by pressing Alt and Return.
By watching the hex code of an Excel cell containing a linefeed, I found that the content of the cell ist represented by the text in double quotes and \u000a as linefeed ("text1\u000atext2").
The problem is, that if I use \n in my java strings, I surely get the linefeed within the cell but there' s also a visible square at the end of the line. By using a hex editor once again, I found that there is - hanky panky - a \u000a AND a \u000d where there should only be a \u000a.
Can anybody help me with this problem?
Thanx
Felbi
|