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 blake.watson@pnmac.com
 designates 64.18.2.169 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <alpine.DEB.2.02.1411060004000.8962@urchin.earth.li>
References: 
 <CAFGkfm0ona6_S-6SS0W-g_DA4V=A-xANFzvKiD_rob4xgw6j8g@mail.gmail.com>
	<alpine.DEB.2.02.1411060004000.8962@urchin.earth.li>
Date: Thu, 6 Nov 2014 09:51:16 -0800
Message-ID: 
 <CAFGkfm0a0sq4jekdo04BKmGV_amjhcyqpepsE2Tz--RVKX5UPw@mail.gmail.com>
Subject: Re: Cell type as returned by formula?
From: Blake Watson <blake.watson@pnmac.com>
To: POI Users List <user@poi.apache.org>
Content-Type: multipart/alternative; boundary=001a11346a70d717030507345749

--001a11346a70d717030507345749
Content-Type: text/plain; charset=UTF-8

Thanks!

On Wed, Nov 5, 2014 at 4:05 PM, Nick Burch <apache@gagravarr.org> wrote:

> On Wed, 5 Nov 2014, Blake Watson wrote:
>
>> Is there a way to ascertain what data type a formula will return? If you
>> invoke getCellType, you just get "formula".
>>
>
> If you need to be certain, you'll need to evaluate it, and check the result
>
> If "what Excel last calculated this to be" is good enough, try
> https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/Cell.html#
> getCachedFormulaResultType%28%29
>
> Nick
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>


-- 

*Blake Watson*

*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.watson@pnmac.com <melanie.petrosyan@pnmac.com>
www.PennyMacUSA.com <http://www.pennymacusa.com/>

--001a11346a70d717030507345749--