Hi Davinder. Try it with first fetching the string value and checking for 0. I think the fetching the numeric value returns 0 and not NaN.
I'ld expect that booleans are 0/1. Regards, Karl-Heinz. -----Urspr�ngliche Nachricht----- Von: Davinder Kohli [mailto:[EMAIL PROTECTED] Gesendet: Montag, 19. Juli 2004 16:28 An: POI Users List Betreff: Re: AW: formula return type Thank you Karl. That's exactly what I am doing. I wanted to go a step further and read in the contents of a cell containing a logical formula. 1. When reading it as a string I get "", it would be nice if I could read it as getBooleanCellValue(). 2. I also wanted to determine if the cell (containing a formula which returns numeric value) is of type date. double cellValue = theCell.getNumericCellValue(); if (Double.isNaN(cellValue)){ // string value String strCell = theCell.getStringCellValue(); } else { // numeric .... } --- "KHZ (SAW)" <[EMAIL PROTECTED]> wrote: > Hi Davinder. > > Actually you can query it as a numeric or a string > value. If you've > chosen the wrong type the result is "" or 0. > Unfortunately you don't see > the type. You just can look for the most reasonable > result. > > Regards, Karl-Heinz. > > > -----Urspr�ngliche Nachricht----- > Von: Davinder Kohli [mailto:[EMAIL PROTECTED] > Gesendet: Freitag, 16. Juli 2004 22:36 > An: POI Users List > Betreff: formula return type > > Hi, > How do I determine the return type of a formula? Is > there an API provided to do this or do I need to > checkout the formula and then determine its return > type. > > Thanks, > Davinder > > > > __________________________________ > Do you Yahoo!? > Yahoo! Mail - 50x more storage than other providers! > http://promotions.yahoo.com/new_mail > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > > __________________________________ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
