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 2004/10/12 06:22:30 UTC

DO NOT REPLY [Bug 31661] New: - HSSFCell.getCellFormula() fails with references to external workbooks

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=31661>.
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=31661

HSSFCell.getCellFormula() fails with references to external workbooks

           Summary: HSSFCell.getCellFormula() fails with references to
                    external workbooks
           Product: POI
           Version: 2.5
          Platform: All
               URL: http://www.mozilla.org
        OS/Version: All
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: matteg@saanich.ca


<html>
<head></head>
<body>
<P>
<p>Description:  This program reads an Excel 2003 spreadsheet that references
 another spreadsheet from cell K12 of sheet Account Number Master.
 This example illustrates two errors in the Jakarta POI 2.5.1 package:<ol>
 <li>The <code>HSSFCell.getCellFormula()</code> returns the name of this cell's
 sheet not the external workbook and sheet name of the referenced cell in the
 external workbook.  No workaround is available.</li>
 <li>The <code>HHSFRow.getPhysicalNumberOfCells()</code> is too small by one
 when a cell referencing another workbook is in the row.  The workaround is
 to not rely on the method and instead iterate over all 256 cells (0-255)
 ignoring nulls.</li></ol>
 In an Excel 2003 workbook <code>IT2005short.xls</code> at sheet
 <code>Account Number Master</code> at
 cell K12 is the formula <br>
 <code>
 =<b>+'C:\d\myPrograms\jbproject\POI1\[GM Budget.xls]8085.4450'</b>!$B$2
 </code><br>
 but the formula returned by HSSFCell.getFormulaString() is <br>
 <code><b>+Account Number Master</b>!$B$2</code>.
 </p>
<P>
</body>
</html>

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org