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 2003/04/11 00:25:09 UTC

DO NOT REPLY [Bug 18922] New: - #REF in formulas modifying an existing workbook

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=18922>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=18922

#REF in formulas modifying an existing workbook

           Summary: #REF in formulas modifying an existing workbook
           Product: POI
           Version: 2.0-dev
          Platform: PC
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: jtan@discoverymining.com


If you downfill a formula into more than 9 rows in an existing workbook and 
save it, the formulas will contain #REF!.  This also occurs if you downfill a 
row containing a formula to more than 6 rows.  I used the BiffViewer and the 
length of the recsize and expression length does not seem to be correct when 
the error occurs.  They are off by 6 bytes.  This causes the formula record to 
be interpreted into a ExpPtg instead of a MultiplyPtg.  I can provide example 
excel files if needed.