Return-Path: X-Original-To: apmail-poi-user-archive@www.apache.org Delivered-To: apmail-poi-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 0A7414707 for ; Tue, 5 Jul 2011 14:09:33 +0000 (UTC) Received: (qmail 1569 invoked by uid 500); 5 Jul 2011 14:09:32 -0000 Delivered-To: apmail-poi-user-archive@poi.apache.org Received: (qmail 1532 invoked by uid 500); 5 Jul 2011 14:09:32 -0000 Mailing-List: contact user-help@poi.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "POI Users List" Delivered-To: mailing list user@poi.apache.org Received: (qmail 1524 invoked by uid 99); 5 Jul 2011 14:09:31 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Jul 2011 14:09:31 +0000 X-ASF-Spam-Status: No, hits=-2.3 required=5.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of nick.burch@alfresco.com designates 207.126.144.129 as permitted sender) Received: from [207.126.144.129] (HELO eu1sys200aog110.obsmtp.com) (207.126.144.129) by apache.org (qpsmtpd/0.29) with SMTP; Tue, 05 Jul 2011 14:09:23 +0000 Received: from zimbra.alfresco.com ([88.151.129.3]) by eu1sys200aob110.postini.com ([207.126.147.11]) with SMTP ID DSNKThMa/WA3TW/1Oq9fk38SYTHm7CwoB/a/@postini.com; Tue, 05 Jul 2011 14:09:02 UTC Received: from localhost (localhost.localdomain [127.0.0.1]) by zimbra.alfresco.com (Postfix) with ESMTP id 449D828C36C for ; Tue, 5 Jul 2011 15:08:44 +0100 (BST) X-Virus-Scanned: amavisd-new at unx-d-manc4.tc.ifeltd.com Received: from zimbra.alfresco.com ([127.0.0.1]) by localhost (zimbra.alfresco.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 8-n+BgkCsSzf for ; Tue, 5 Jul 2011 15:08:44 +0100 (BST) Received: from urchin.earth.li (urchin.earth.li [212.13.204.73]) (Authenticated sender: nick.burch@alfresco.com) by zimbra.alfresco.com (Postfix) with ESMTP id 1CAF428C36B for ; Tue, 5 Jul 2011 15:08:44 +0100 (BST) Date: Tue, 5 Jul 2011 15:08:43 +0100 (BST) From: Nick Burch X-X-Sender: nick@urchin.earth.li To: POI Users List Subject: Re: Setting the cell type to "text" for an entire column (.xls) In-Reply-To: <20110705135711.132790@gmx.net> Message-ID: References: <20110705090421.132790@gmx.net> <20110705135711.132790@gmx.net> User-Agent: Alpine 2.00 (DEB 1167 2008-08-23) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed On Tue, 5 Jul 2011, cl_for_mailing@gmx.net wrote: > Ideally, I would like to call something like: > > sheet.setDefaultColumnCellType(Cell.CELL_TYPE_STRING); Can you try setting the type on a column in excel, and seeing what gets written to the file for that? (Unzip the .xlsx file and compare the xml between a file with and without the setting). If it isn't done with a style, then I don't personally know how it'd be done, but luckily we can use excel as an oracle for the file format :) Nick --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscribe@poi.apache.org For additional commands, e-mail: user-help@poi.apache.org