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

           Summary: [patch] Incorrect SharedFormulaRecord chosen when
                    'shared record' flag abnormally set.
           Product: POI
           Version: 3.0-dev
          Platform: Other
        OS/Version: other
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: [email protected]
        ReportedBy: [EMAIL PROTECTED]


Excel sometimes saves FormulaRecords with the 'shared record' flag set, but 
with no corresponding SharedFormulaRecord.  The correct operation is to leave 
the FormulaRecord as-is.  POI was making a mistake of using 
SharedFormulaRecords that happen to match the row and column ranges, but come 
from subsequent sheets. (Excel does not define shared formulas across sheets).

The bug results in some cells apparently having formulas from the 
corresponding cell on another sheet. (!)

The solution was to make ValueRecordsAggregate.construct() only consider 
SharedFormulaRecords for the current sheet.

-- 
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to