So I switched to 3.5Beta4 which now contains the formulaevaluator class but now HSSFCell.getColumnIndex and getRowIndex have been removed. I am having trouble figuring out where to get the cells column/row numbers from the HSSFCell instance. Hopefully that is still possible as I have numerous functions passing around cells that need to retrieve their locational data.
Thanks for any and all help, it's much appreciated. Cheers, Zach Davis Associate IT Programmer Analyst R.L. Polk Southfield Office -----Original Message----- From: Davis, Zach [mailto:[email protected]] Sent: Wednesday, January 14, 2009 10:48 AM To: POI Users List Subject: RE: Formulas Has this been removed or changed? Using 3.2FINAL I see no FormulaEvaluator class and HSSFWorkbook.getCreationHelper() does not exist on the workbook object. Cheers, Zach Davis Associate IT Programmer Analyst R.L. Polk Southfield Office -----Original Message----- From: Nick Burch [mailto:[email protected]] Sent: Monday, January 12, 2009 4:33 PM To: POI Users List Subject: Re: Formulas On Mon, 12 Jan 2009, Davis, Zach wrote: > Is there any basic class to feed a HSSFCell containing a formula that > would return the displayed value of the formula like Excel would? I'd suggest a read of http://poi.apache.org/spreadsheet/eval.html , as I think it covers all of what you're after Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] ***************************************************************** This message has originated from R. L. Polk & Co., 26955 Northwestern Highway, Southfield, MI 48033. R. L. Polk & Co. sends various types of email communications. If this email message concerns the potential licensing of a Polk product or service, and you do not wish to receive further emails regarding Polk products, forward this email to [email protected] with the word "remove" in the subject line. The email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error, please delete this message and notify the Polk System Administrator at [email protected]. ***************************************************************** --------------------------------------------------------------------- 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]
