Looking at the code, I think there are some bugs in getBooleanValue in HSSFCell. It doesn't handle formulas. Also, with getStringValue, i'm not sure you can differentiate between actual empty result, or "bad type".
Essentially this looks like a hack, primarily becoz it depends on functionality that cant be guaranteed to work after any bugfix submitted by any contributor. If you want this functionality, you'll have to write a more foolproof way into HSSFCell, and submit it in. Otherwise, you may be able to implement this in your code, but it'll be very brittle. Just my 2c.. not gospel :) Regards - Avik On Mon, 2004-07-19 at 20:52, Davinder Kohli wrote: > 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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
