poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Blake Watson <blake.wat...@pnmac.com>
Subject Re: Cell type as returned by formula?
Date Thu, 06 Nov 2014 17:51:16 GMT
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/>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message