https://bz.apache.org/bugzilla/show_bug.cgi?id=59707
--- Comment #8 from rbi...@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-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
