Bug 18922 - #REF in formulas modifying an existing workbook
Summary: #REF in formulas modifying an existing workbook
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 2.0-dev
Hardware: PC All
: P3 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2003-04-10 22:25 UTC by John C. Tan
Modified: 2005-03-20 17:06 UTC (History)
0 users

Sample workbook with formula problem (14.00 KB, application/octet-stream)
2003-04-10 22:34 UTC, John C. Tan

Note You need to log in before you can comment on or make changes to this bug.
Description John C. Tan 2003-04-10 22:25:08 UTC
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.
Comment 1 John C. Tan 2003-04-10 22:34:30 UTC
Created attachment 5783 [details]
Sample workbook with formula problem
Comment 2 Danny Mui 2003-04-10 22:37:47 UTC
That's next on my todo list.  How do you downfill in Excel (Im not a user, just
a dealer)?

Comment 3 John C. Tan 2003-04-10 22:47:13 UTC
You can select the cell or row with the formula and then move the cursor to the 
lower right corner.  When the cursor changes to a thin black plus sign, you can 
drag it into the following rows.
Comment 4 Danny Mui 2003-05-08 00:12:35 UTC
Committed fix for this issue 05/07/2003