I tried your approach, reading it as string(getStringCellValue) first. "" was returned. When I read it as numeric, NaN is returned.
The formula stored is AND(A1,B1). Regards --- "KHZ (SAW)" <[EMAIL PROTECTED]> wrote: > 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] > > __________________________________ Do you Yahoo!? Vote for the stars of Yahoo!'s next ad campaign! http://advision.webevents.yahoo.com/yahoo/votelifeengine/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
