https://bz.apache.org/bugzilla/show_bug.cgi?id=59707
--- Comment #8 from rbidet@ribics.fr ---
(In reply to Mark B from comment #5)
> The \n sequence is an escape sequence that is interpreted to mean a new line
> when it - the escape sequence - a[pears in a Java string. The example in the
> Quick Guide uses Java to create the sheet/row/cell and populate it. I
> suspect this is not what you are doing, rather you are reading from an
> existing file and attempting to modify it.
>
> Am I correct in assuming that you have a test file that you have created
> using Excel? Further, that this file contains a cell into which you have
> written the string? If that is correct, then you never will see a new line.
> To create a new line in a cell using Excel itself then you need to press and
> hold down the Alt key and then press the enter key.
In addition, my test file wasn't created with Excel but via the POI library :
XSSFWorkbook wb = new XSSFWorkbook();
XSSFSheet sheet = wb.createSheet(sheetName);
So it's a brand new one, and i'm trying to create a cell (via the POI library),
and to populate this cell with the content of a plain text file.
It works great, except for the lines that contains \n
The cell.setCellValue(fileLine); write the \n instead of creating a new line.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
|