Bug 63228

Summary: Method copyCellFrom (org.apache.poi.xssf.usermodel.XSSFCell) doesn't update formula reference
Product: POI Reporter: Nikoloz Gochiashvili <nick>
Component: XSSFAssignee: POI Developers List <dev>
Status: NEW ---    
Severity: normal CC: kakhaberi
Priority: P3    
Version: 3.17-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   

Description Nikoloz Gochiashvili 2019-03-04 10:28:40 UTC
When i copy formula with reference to other cell, the new formula has old reference. 

I am using org.apache.poi.xssf.usermodel.XSSFCell copyCellFrom method, with copyCellFormula=true.


B5 = B2+1  after copy to C5 = B2+1 instead of C5 = C2+1
Comment 1 FINA 2019-03-06 04:57:59 UTC
There is a lot of cases when you may need such feature when for instance you are summing 3 items on column B ( i.e B1=B10+B11+B12) and after copying cell from B1 to C1 you expect formula C1=C10+C11+C12, but instead of that you see same formula as it was in B1   ( C1= B10+B11+B12 which is wrong). 

Any idea how and/or when to correct it?   
Or maybe someone knows the workaround ?

Thank you in advance for any response or advise.