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 B70339DAC for ; Thu, 29 Mar 2012 15:51:28 +0000 (UTC) Received: (qmail 93232 invoked by uid 500); 29 Mar 2012 15:51:25 -0000 Delivered-To: apmail-poi-user-archive@poi.apache.org Received: (qmail 93185 invoked by uid 500); 29 Mar 2012 15:51:25 -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 92898 invoked by uid 99); 29 Mar 2012 15:51:25 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Mar 2012 15:51:25 +0000 X-ASF-Spam-Status: No, hits=2.3 required=5.0 tests=SPF_SOFTFAIL,URI_HEX X-Spam-Check-By: apache.org Received-SPF: softfail (nike.apache.org: transitioning domain of jeanbaptistetex@hotmail.fr does not designate 216.139.236.26 as permitted sender) Received: from [216.139.236.26] (HELO sam.nabble.com) (216.139.236.26) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Mar 2012 15:51:19 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1SDHco-0005A3-D2 for user@poi.apache.org; Thu, 29 Mar 2012 08:50:58 -0700 Date: Thu, 29 Mar 2012 08:50:58 -0700 (PDT) From: Jiybee To: user@poi.apache.org Message-ID: <1333036258395-5604224.post@n5.nabble.com> In-Reply-To: <1333035004775-5604154.post@n5.nabble.com> References: <1333023852785-5603614.post@n5.nabble.com> <1333035004775-5604154.post@n5.nabble.com> Subject: Re: Trouble with HyperLink to another cell in another wokbook MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Thank you for your help! I have tried to change the link by following your advice but I still have an error in Excel. Now the two brackets have been changed into %5b and %5d. the new setAddress : Jiybee wrote > > theLink.setAddress("[350_Commercial.xls]PCM_350!A1"); > and the result in the Excel file : Jiybee wrote > > %5b350_Commercial.xls%5dPCM_350!A1 > -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Trouble-with-HyperLink-to-another-cell-in-another-wokbook-tp5603614p5604224.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscribe@poi.apache.org For additional commands, e-mail: user-help@poi.apache.org