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: [email protected] For additional commands, e-mail: [email protected]
