You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2007/05/29 18:28:22 UTC
DO NOT REPLY [Bug 42541] New: - Problem with Formula cells.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=42541>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=42541
Summary: Problem with Formula cells.
Product: POI
Version: 3.0-dev
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: critical
Priority: P1
Component: HSSF
AssignedTo: poi-dev@jakarta.apache.org
ReportedBy: sandeep30469@hotmail.com
POI Version . poi-3.0-rc4-20070503.jar
Create a simple excel file . input a formula in C1 as =A1+B1
Copy the same formula into the corresponding cells for the C column by dragging
the C1 Cell. Excel will generate the formulas automatically for the cells.
Save the workbook and try opening it.
InputStream istream = new FileInputStream(filename);
POIFSFileSystem fs = new POIFSFileSystem(new BufferedInputStream(istream));
HSSFWorkbook wb= new HSSFWorkbook(fs,true);
FileOutputStream fileOut = new FileOutputStream("c:\\test.xls");
wb.write(fileOut);
fileOut.close();
istream.close();
All the cells where the formula is copied will show #value instead of the value.
This happens only in the current release(poi-3.0-rc4-20070503).
Could somebody please fix this or suggest some solution. This happens only for
those formula cells that have been copied.
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
DO NOT REPLY [Bug 42541] - Problem with Formula cells.
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=42541>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=42541
------- Additional Comments From sandeep30469@hotmail.com 2007-05-29 09:29 -------
Created an attachment (id=20285)
--> (http://issues.apache.org/bugzilla/attachment.cgi?id=20285&action=view)
Sample excel file to test
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
DO NOT REPLY [Bug 42541] - Problem with Formula cells.
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=42541>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=42541
------- Additional Comments From leprinco@yahoo.fr 2008-01-16 16:13 -------
Can't reproduce with latest version of POI and Excel 2000.
I used your attachment and created a new one with your disposition.
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org