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=15223>. 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=15223 Formula REF# when drag-down-style formula Summary: Formula REF# when drag-down-style formula Product: POI Version: unspecified Platform: PC OS/Version: Windows NT/2K Status: UNCONFIRMED Severity: Blocker Priority: Other Component: HSSF AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] I'm using Excel XP on Windows 2000 with JDK 1.3.1 and POI 1.9.0 (I downloaded the dev-build to see if this would be resolved, I had the same problem with a build from this summer). When writing a series of formula cells in drag-down style e.g (Cell A2) =A1+1 (Cell A3) =A2+1 (Cell A4) =A3+1 and then reading the workbook in a java application and writing to a new output everything first generates fine, but... If I close Excel, open it again with the original document, edit a cell somewhere else in the sheet, save it and try to run my java again - all the formula cells in the generated book are represented by REF#. When using the drag-down (I don't know if that's the correct term for the mouse- dragging extrapolation of formulas) the problem appears immediately without involving restarts or other cells. Am I missing something? Grateful for all help I can get, Kristian Larsson -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
