Sorry guys wrong subject - replied to old message :-) Tom Lister * [EMAIL PROTECTED] * 020 775 65014
-----Original Message----- From: Lister, Tom (AFM) [mailto:[EMAIL PROTECTED] Sent: 24 August 2004 11:59 To: 'POI Users List' Subject: RE: POI Classpath fiasco Hi I had a problem with certain formulas Formula translates as NO IDEA SHARED FORMULA EXP PTG and no value is returned. This seems to be related to cells we have that are numbers but formatted as strings. I saw some inconclusive messages in the archive Just wanted to post this hacky work around we used } else if (cell.getCellType() == HSSFCell.CELL_TYPE_FORMULA) { LOGGER.info("String formula found " + cell.getCellFormula()); cellValue = cell.getStringCellValue(); if (StringUtils.isStringEmpty(cellValue)) { LOGGER.info("String empty try numeric formula"); cellValue = String.valueOf(new Double(cell.getNumericCellValue()).longValue()); } } else { cellValue = null; } :-) Tom Lister * [EMAIL PROTECTED] * 020 775 65014 **************************************************************************** **************************************************************************** ********* Emails aren't always secure, and they may be intercepted or changed after they've been sent. Abbey doesn't accept liability if this happens. If you think someone may have interfered with this email, please get in touch with the sender another way. This message doesn't create or change any contract. Abbey doesn't accept responsibility for damage caused by any viruses contained in this email or its attachments. Emails may be monitored. If you've received this email by mistake, please let the sender know at once that it's gone to the wrong person and then destroy it without copying, using, or telling anyone about its contents. Abbey National Treasury Services plc Reg. No. 2338548, Cater Allen International Ltd Reg. No. 2572704, and Inscape Investments Limited Reg. No. 3839455 are registered in England and have their Registered Offices at: Abbey National House, 2 Triton Square, Regent's Place, London, NW1 3AN. Cater Allen International Ltd is a subsidiary of Abbey National Treasury Services plc. Abbey National Treasury Services plc and Cater Allen International Ltd are Members of The London Stock Exchange. Abbey National Asset Managers Ltd. Reg. No. 106669. Registered Office: Abbey National House, 301 St Vincent Street, Glasgow, G2 5HN. Registered in Scotland. Abbey National Asset Managers Ltd and Inscape Investments Limited are members of the Abbey Marketing Group and provide OEICS, PEPS, and ISAs. Abbey National Treasury Services plc, Cater Allen International Ltd, Inscape Investments Limited, and Abbey National Asset Managers Ltd are authorised and regulated by the Financial Services Authority. Abbey Financial Markets is the brand name for Abbey National Treasury Services plc. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] .sophos.3.84.08.24. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
