Bug 65306 - shiftRows remove row contains shared formula master cause corrupt file
Summary: shiftRows remove row contains shared formula master cause corrupt file
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 5.0.0-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-05-14 14:17 UTC by chunlinyao
Modified: 2021-10-10 09:25 UTC (History)
0 users



Attachments
origin file (9.29 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2021-05-14 14:17 UTC, chunlinyao
Details
Test program (648 bytes, text/plain)
2021-05-14 14:17 UTC, chunlinyao
Details
the result file contains error. (7.45 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2021-05-14 14:18 UTC, chunlinyao
Details

Note You need to log in before you can comment on or make changes to this bug.
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