There is an easy way to test this hypothesis of course; just perform the test for type in a specific order and ensure that the test for the blank/empty type precedes that for the numeric cell type; must admit though that I cannot see that this is the answer however.
Are the numeric cells you are dealing with genuinely empty? Indeed, is it possible to have an empty numeric cell on worksheet? Sill question maybe but I wonder what Excel does with empty numeric cells; does it have a placeholder value of some sort, a little like NaN? Have you used the BiffViewer utility to look at the contents of the sheet(s) in question? This may give you an indication of the way the API is processing 'empty' numeric cells. If I have the chance today - and I cannot promise anything, I will try to play with some code myself just to see what I can find out. It may be the case that the API needs to be modified so that it includes an isEmpty() method for example, defined at the Cell level and returning a boolean value that indicates whether or not the cell is empty; or to suit this specific case modify getNumericCellValue() to return a java.lang.Double then it would be possible to return NaN if the cell was empty. Yours Mark B yehogold wrote: > > But if the TYPE_NUMERIC cell is empty, won't it still be a TYPE_NUMERIC > cell? > > > VK123 wrote: >> >> You can use TYPE_BLANK to check if the cell is empty. >> >> Regards, >> >> Vijayakumar Gowdaman >> >> Group Technology & Operations (GTO) >> Global Markets >> Deutsche Bank >> off: 02075456250 >> Mob:07789773998 >> >> >> >> yehogold <[email protected]> >> 11/08/2009 19:35 >> Please respond to >> "POI Users List" <[email protected]> >> >> >> To >> [email protected] >> cc >> >> Subject >> The difference between a blank TYPE_NUMERIC cell and a TYPE_NUMERIC cell >> with 0. >> >> >> >> >> >> >> >> Hi. >> >> I'm trying to test if a specific cell is empty. For TYPE_STRING cells, I >> can get the cellStringValue and check it against an empty string. >> getNumericValue(), returns '0' when the cell is empty, making it >> impossible >> to differentiate between a truly empty TYPE_NUMERIC cell and one that >> contains '0'. >> >> How can a I check if a cell is truly empty? >> >> Thank you in advance for all your help. >> -- >> View this message in context: >> http://www.nabble.com/The-difference-between-a-blank-TYPE_NUMERIC-cell-and-a-TYPE_NUMERIC-cell-with-0.-tp24923291p24923291.html >> >> Sent from the POI - User mailing list archive at Nabble.com. >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [email protected] >> For additional commands, e-mail: [email protected] >> >> >> >> >> >> --- >> >> This e-mail may contain confidential and/or privileged information. If >> you are not the intended recipient (or have received this e-mail in >> error) please notify the sender immediately and delete this e-mail. Any >> unauthorized copying, disclosure or distribution of the material in this >> e-mail is strictly forbidden. >> >> Please refer to http://www.db.com/en/content/eu_disclosures.htm for >> additional EU corporate and regulatory disclosures. >> > > -- View this message in context: http://www.nabble.com/The-difference-between-a-blank-TYPE_NUMERIC-cell-and-a-TYPE_NUMERIC-cell-with-0.-tp24923291p24949447.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
