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 (nike.apache.org: domain of ambutnaru@gmail.com designates
 209.85.219.225 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:user-agent:mime-version:to:subject:references
         :in-reply-to:content-type:content-transfer-encoding;
        b=NVnaSRFHFh6jp5WYKc0FCAC6D1W8Lf44pVKympXs/r2VeyS+k1L8KIrgdlUKyInf3N
         suA9R6NnNqoLI2UBbnXvUIG3ABoy/5LClDV8WyY8VbcHhO/EgRz9TE7h85QemiI9HINv
         8IMmbNQkoPfb/D4BsrrxSexgpjlzH3I+h1a50=
Message-ID: <4B155DE8.80505@gmail.com>
Date: Tue, 01 Dec 2009 19:18:16 +0100
From: Adrian Butnaru <ambutnaru@gmail.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
To: POI Users List <user@poi.apache.org>
Subject: Re: INDIRECT function
References: <4B141120.6080605@gmail.com>
	 <a644352c0911301047r14232492q5e2cc3c0ef0bc98a@mail.gmail.com>
	 <4B141A33.6000402@gmail.com>
	 <a644352c0911301138h7aafea04w5ff0f7c98b47459c@mail.gmail.com>
	 <4B1424E2.4030703@gmail.com>
	 <a644352c0911301856u3477a281n9f8c0fb06c87963b@mail.gmail.com>
	 <4B14D1DA.90907@gmail.com>
 <a644352c0912010027r725c0b4djb297a4dab42922b6@mail.gmail.com>
 <4B1555C0.1030403@gmail.com> <4B1559CF.7020500@dinom.ru>
In-Reply-To: <4B1559CF.7020500@dinom.ru>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Strange enough this is the output:

file:/C:/Program%20Files/Java/jdk1.6.0_03/jre/lib/ext/poi-3.5-beta4-20081128/

but this path is not existing!


Yegor Kozlov schreef:
> Execute the following code:
>
>         URL url = 
> HSSFWorkbook.class.getProtectionDomain().getCodeSource().getLocation();
>         System.out.println(url);
>
> it will print the path to the POI jar.
>
> nightly builds can be downloaded from 
> http://encore.torchbox.com/poi-svn-build/
>
> Yegor
>
>> Your prediction is good.
>>
>> This was the output:
>> Wrong result type - got 5errCode=-30
>> But how can I get rhe newest poi jar file?
>> I downloaded the one I am using
>>
>> POI-3.5-FINAL-20090928.jar
>>
>> from POI website.
>>
>>
>>
>>
>> Josh Micich schreef:
>>>> I am using POI-3.5-FINAL-20090928.jar.
>>>>     
>>> There's a high chance you're not.
>>>
>>> You can also dump the error code to help diagnose the problem.
>>> Change this line:
>>> System.err.println("Wrong result type - got " + cv.getCellType() + "
>>> errCode=" + cv.getErrorValue());
>>>
>>> I predict the error code will be -30.  Which will mean you are using a
>>> version of POI prior to 3.5-beta4
>>>
>>> If I am mistaken, another thing you can try is to put a breakpoint in
>>> Indirect.java:76, to confirm whether execution gets there.  You can
>>> also look around the variables in the stack frame which might help
>>> explain what is going wrong.
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
>>> For additional commands, e-mail: user-help@poi.apache.org
>>>
>>>
>>>   
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
>> For additional commands, e-mail: user-help@poi.apache.org
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org