basic questions.. sorry! 1. Do you SAVE the file in Excel before closing.
2. Are you sure you're opening the SAVED file, and not the ORIGINAL file? Regards - Avik On Thu, 2005-01-13 at 09:48 -0500, Kashikar, Yogita (SSD Technology) wrote: > No macros are processed when closing the excel file. Any other pointers ??? > > Thanks, > Yogita. > > -----Original Message----- > From: KHZ (SAW) [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 13, 2005 5:11 AM > To: 'POI Users List' > Subject: AW: Reading value from formula cell > > > Hi Yogita. > > Can you deny that any macros are processed when closing the Excel file? > > Regards, Karl-Heinz. > > > -----Urspr�ngliche Nachricht----- > Von: Kashikar, Yogita (SSD Technology) [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 12. Januar 2005 23:53 > An: POI Users List > Betreff: RE: Reading value from formula cell > > I understand that POI doesn't evaluate the formula and Excel does it. > This is what I am doing: > > -I am creating a spreadsheet. > -Writing a formula cell. > -Saving the file to disk > - then opening it manually. I can see the correct results in the formula > cell. I close it. > - then I open the same file in java program using poi > - read the formula cell using getNumericCellValue > It returns me the value 0.0. > Should it not retun me the calculated value ? > Is it a bug in POI ? > Is there any alternate solution to do this ? > > We are sort of stuck on this. Would appriciate any quick response. > > Thanks, > Yogita. > > > > > -----Original Message----- > From: Kashikar, Yogita (SSD Technology) > Sent: Wednesday, January 12, 2005 3:23 PM > To: POI Users List > Subject: RE: Reading value from formula cell > > > Hi Tony, > > Thanks for your reply. > I am creating the spread sheet and creating a cell as stated in previous > message. > As a second step( after creating the spread sheet and saving in excel > file) I am opening the excel file and re-reading the formula cell. This > read is always returning me 0.0. > What could be the problem with this ? > Is teher any alternate way to read value from formula cell. > > Thanks, > Yogita. > > > -----Original Message----- > From: Tony Nelson [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 12, 2005 3:17 PM > To: POI Users List > Subject: Re: Reading value from formula cell > > > Quoting Yogita <[EMAIL PROTECTED]>: > > > Hi, > > > > I am facing difficulties while reading formula cell values with POI > version > > 2.5. > > > > I have created formula cell as follows: > > cell.setCellType(HSSFCell.CELL_TYPE_FORMULA); > > cell.setCellFormula("SUM(D8..F8)"); > > > > And I am reading it as follow: > > double formulaCellValue = row.getCell((short) > 7).getNumericCellValue(); > > > > When read this way(using getNumericCellValue()), I am always getting > the > > value > > of 0.0. > > > > Any quick help in this regard would be highly appriciated. > > > > POI does not evaluate formulas. Excel does that. > > POI simply puts the forumla in the cell. In order to get a value, you > would > have to create the spreadsheet, open it in excel, and then re-read it > with > POI. > > This was discussed in detail less than two weeks ago on the list. > Please read > the archives. > > > > This email message from Starpoint Solutions LLC is for the sole use of > the intended recipient(s) and may contain confidential and privileged > information. Any unauthorized review, use, disclosure or distribution > is prohibited. If you are not the intended recipient, please contact > the sender by reply email and destroy all copies of the original > message. Opinions, conclusions and other information in this message > that do not relate to the official business of Starpoint Solutions shall > be understood as neither given nor endorsed by it. > -------------------------------------------------------- > > If you are not an intended recipient of this e-mail, please notify the > sender, delete it and do not read, act upon, print, disclose, copy, > retain or redistribute it. Click here for important additional terms > relating to this e-mail. http://www.ml.com/email_terms/ > -------------------------------------------------------- > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > Mailing List: http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > Mailing List: http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > Mailing List: http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > Mailing List: http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ > -- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
