Bug 65306

Summary: shiftRows remove row contains shared formula master cause corrupt file
Product: POI Reporter: chunlinyao
Component: XSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P2    
Version: 5.0.0-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   
Attachments: origin file
Test program
the result file contains error.

Description chunlinyao 2021-05-14 14:17:15 UTC
Created attachment 37859 [details]
origin file

When remove row contains master shared formula.
It now make another row the master. so excel report file contains corrupt shared formulas.

I attached the test file to reproduce this bug.
Comment 1 chunlinyao 2021-05-14 14:17:48 UTC
Created attachment 37860 [details]
Test program
Comment 2 chunlinyao 2021-05-14 14:18:21 UTC
Created attachment 37861 [details]
the result file contains error.
Comment 3 PJ Fanning 2021-10-10 06:40:16 UTC
trying r1894089
Comment 4 PJ Fanning 2021-10-10 09:25:13 UTC
the change will appear in POI 5.1.0