Mailing-List: contact user-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <user@poi.apache.org>
Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Message-ID: <22181073.post@talk.nabble.com>
Date: Tue, 24 Feb 2009 07:02:18 -0800 (PST)
From: MSB <markbrdsly@tiscali.co.uk>
To: user@poi.apache.org
Subject: Re: Formula value contains a link - not reading properly
In-Reply-To: <22165667.post@talk.nabble.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
References: <22165667.post@talk.nabble.com>


The first thing that springs to mind could be character encodings? Secondly=
,
it could be that you are encoutering problems with forbidden characters in
file or folder names - I know that the [ and ] characters are disallowed in
Windows for example - though why this would cause what you are seeing I do
not know. Finally, have you tried calling the getStringCellValue() method
just to see what that returns? I know that you are dealing with a formula
cell but it would be interesting to see what the outcome is.

Aside from that, I am stumped, sorry.


brianireland wrote:
>=20
> Reading a cell formula value that includes a link to another excel file,
> very common=20
> for most of the excel files I work with, causes unusual returned string.=
=20
>=20
> e.g. Excel cell contains the following formula:=20
> =3D'C:\[poiTest.xls]HSSF Test'!$A$6
>=20
> Read the formula value using POI 3.5 beta, print it to Eclipse console,
> get:=20
> '[=02poiTest.xls]HSSF Test'!$A$6
>=20
> The C:\[ appears to be replaced with a square bracket and a little square
> (dont know what it is).=20
>=20
> Code used is:=20
> =09=09=09=09=09=09=09=09=09=09
> String formulaString =3D cell.getCellFormula();
> System.out.println ("String value: " + formulaString);
>=20
> Any help appreciated.=20
>=20
> Brian
>=20

--=20
View this message in context: http://www.nabble.com/Formula-value-contains-=
a-link---not-reading-properly-tp22165667p22181073.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