Bug 54206

Summary: ValueRecordsAggregate.updateFormulasAfterRowShift doesn't update shared formulas
Product: POI Reporter: Rui Baptista <rui.baptista.ml>
Component: HSSFAssignee: POI Developers List <dev>
Severity: normal    
Priority: P2    
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: All   
Attachments: original workbook
rows shifted, v3.8-20120326
rows shifted, patched code
java test code
tested patch

Description Rui Baptista 2012-11-26 01:03:39 UTC

Comment 1 Rui Baptista 2012-11-26 01:58:26 UTC
Created attachment 29635 [details]
original workbook
Comment 2 Rui Baptista 2012-11-26 01:59:44 UTC
Created attachment 29636 [details]
rows shifted, v3.8-20120326
Comment 3 Rui Baptista 2012-11-26 02:01:18 UTC
Created attachment 29637 [details]
rows shifted, patched code
Comment 4 Rui Baptista 2012-11-26 02:03:28 UTC
Created attachment 29638 [details]
java test code
Comment 5 Rui Baptista 2012-11-26 02:11:42 UTC
Created attachment 29639 [details]
tested patch
Comment 6 Rui Baptista 2012-11-26 02:19:39 UTC
Probably the tested patch converts all shared formulas to unshared (if adjusted), the shared formula should be adjusted instead.
Comment 7 Yegor Kozlov 2012-12-04 12:45:19 UTC
Thanks for the patch, applied in r1416917, junit added.