Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <poi-user@jakarta.apache.org>
Received-SPF: pass (hermes.apache.org: local policy)
content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Reading value from formula cell
Date: Thu, 13 Jan 2005 09:48:52 -0500
Message-ID: 
 <6BCB72ACFE6B1644AE91E59B39E2FF5D07E9A034@mlnyb707mb.amrs.win.ml.com>
Thread-Topic: Reading value from formula cell
Thread-Index: AcT5WEUE/EXI+dhfRiq3FGA7U5zoqQAJfGyg
From: "Kashikar, Yogita (SSD Technology) " <Yogita_Kashikar@ml.com>
To: "POI Users List" <poi-user@jakarta.apache.org>,
	<karl-heinz.zengerle@sawag.com>

No macros are processed when closing the excel file. Any other pointers =
???

Thanks,
Yogita.

-----Original Message-----
From: KHZ (SAW) [mailto:karl-heinz.zengerle@sawag.com]=20
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=FCngliche Nachricht-----
Von: Kashikar, Yogita (SSD Technology) [mailto:Yogita_Kashikar@ml.com]=20
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)=20
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:tnelson@starpoint.com]=20
Sent: Wednesday, January 12, 2005 3:17 PM
To: POI Users List
Subject: Re: Reading value from formula cell


Quoting Yogita <yogita_kashikar@ml.com>:

> Hi,
>=20
> I am facing difficulties while reading formula cell values with POI
version=20
> 2.5.
>=20
> I have created formula cell as follows:
> 			cell.setCellType(HSSFCell.CELL_TYPE_FORMULA);
> 			cell.setCellFormula("SUM(D8..F8)");
>=20
> And I am reading it as follow:
>    double formulaCellValue =3D row.getCell((short)
7).getNumericCellValue();
>=20
> When read this way(using getNumericCellValue()), I am always getting
the
> value=20
> of 0.0.=20
>=20
> Any quick help in this regard would be highly appriciated.
>=20

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: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/