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 5C2218E40 for ; Wed, 10 Aug 2011 07:36:43 +0000 (UTC) Received: (qmail 51795 invoked by uid 500); 10 Aug 2011 07:36:41 -0000 Delivered-To: apmail-poi-user-archive@poi.apache.org Received: (qmail 49208 invoked by uid 500); 10 Aug 2011 07:36:30 -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 49180 invoked by uid 99); 10 Aug 2011 07:36:27 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 Aug 2011 07:36:27 +0000 X-ASF-Spam-Status: No, hits=0.0 required=5.0 tests=LOTS_OF_MONEY,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [87.117.208.209] (HELO mx.smershnet.com) (87.117.208.209) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 Aug 2011 07:36:19 +0000 Received: from mx.hq.smershnet.com (leiter.hq.smershnet.com [81.174.13.193]) (using TLSv1 with cipher ADH-CAMELLIA256-SHA (256/256 bits)) (No client certificate requested) by mx.smershnet.com (Postfix) with ESMTPS id 53A6E1C9202D for ; Wed, 10 Aug 2011 08:35:58 +0100 (BST) Received: from [192.168.200.19] (unknown [192.168.200.19]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) by mx.hq.smershnet.com (Postfix) with ESMTPS id 6610B4D5A1 for ; Wed, 10 Aug 2011 09:35:35 +0200 (CEST) From: Phill Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Subject: Encoding issues with currency symbol in data format Date: Wed, 10 Aug 2011 09:35:57 +0200 Message-Id: <0F5BC54F-9A37-4C08-B6EA-3696669694F0@inversebit.com> To: user@poi.apache.org Mime-Version: 1.0 (Apple Message framework v1244.3) X-Mailer: Apple Mail (2.1244.3) In my XSSFWorkbook I'm trying to define a data format for British = pounds as follows: moneyCellStyle.setDataFormat(df.getFormat("=A3#,##0.00")); In my Excel document the numbers are formatted correctly and the pound = sign is present but it is prefixed by an '=C5' character. =20 e.g. =C5=A31,500.00 Do I need to explicitly need to set an encoding somewhere or should this = automatically be handled by POI?= --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscribe@poi.apache.org For additional commands, e-mail: user-help@poi.apache.org