poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 44449] New: - [patch] Incorrect SharedFormulaRecord chosen when 'shared record' flag abnormally set.
Date Tue, 19 Feb 2008 05:31:45 GMT
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: dev@poi.apache.org
        ReportedBy: josh@gildedtree.com


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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message