Return-Path: Delivered-To: apmail-jakarta-poi-user-archive@www.apache.org Received: (qmail 64225 invoked from network); 10 Jan 2005 15:18:11 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 10 Jan 2005 15:18:11 -0000 Received: (qmail 84892 invoked by uid 500); 10 Jan 2005 15:18:11 -0000 Delivered-To: apmail-jakarta-poi-user-archive@jakarta.apache.org Received: (qmail 84409 invoked by uid 500); 10 Jan 2005 15:18:09 -0000 Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "POI Users List" Reply-To: "POI Users List" Delivered-To: mailing list poi-user@jakarta.apache.org Received: (qmail 84396 invoked by uid 99); 10 Jan 2005 15:18:09 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from apollo.sawag.com (HELO slox.sawag.com) (62.138.38.84) by apache.org (qpsmtpd/0.28) with ESMTP; Mon, 10 Jan 2005 07:18:08 -0800 Received: from apollo (localhost [127.0.0.1]) by apollo (Postfix) with SMTP id DB77FEFD15 for ; Mon, 10 Jan 2005 16:16:49 +0100 (CET) Received: by slox.sawag.com (Postfix, from userid 65534) id C12E6EFD1D; Mon, 10 Jan 2005 16:16:49 +0100 (CET) Received: from karlheinzmobil (thor.sawag.com [62.138.17.46]) by slox.sawag.com (Postfix) with ESMTP id 002E6EFBE2 for ; Mon, 10 Jan 2005 16:16:48 +0100 (CET) Reply-To: From: "KHZ (SAW)" To: "'POI Users List'" Subject: AW: newline in an excel cell Date: Mon, 10 Jan 2005 16:18:02 +0100 Organization: SAW Message-ID: <003301c4f727$936b1430$9500000a@karlheinzmobil> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 In-Reply-To: Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on apollo.sawag.com X-Spam-Level: X-Spam-Status: No, hits=-104.7 required=5.0 tests=AWL,BAYES_00, USER_IN_WHITELIST autolearn=ham version=2.63 X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Hi Oliver. Last March there was the topic "POI line feed/Carriage Return Problem" where a lot was discussed about this. Look there. I don't remember the result ad hoc but I hope this is a good pointer. Regards, Karl-Heinz. -----Urspr=FCngliche Nachricht----- Von: news [mailto:news@sea.gmane.org] Im Auftrag von Oliver Hirschi Gesendet: Montag, 10. Januar 2005 15:36 An: poi-user@jakarta.apache.org Betreff: newline in an excel cell Hi, I have a problem with newlines in a excel-cell. the excel is generates with apache POI HSSF. I tried several things: 1. cell.setCellValue("First Line\nSecondLine"); 2. cell.setCellValue("First Line\rSecondLine"); 3. cell.setCellValue("First Line\r\nSecondLine"); If I take variant 1, after opening the genearted xls with excel, the newlines are shown as squares. After double-clicking onto the cell, the newlines are okay. How can I make correct newlines with poi, that are shown correct by opening the file with excel? Thanks! --=20 Oliver Hirschi http://www.FamilyHirschi.ch --------------------------------------------------------------------- To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ --------------------------------------------------------------------- To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/