Hi, I think I found a bug related with method Workbook.cloneSheet(int sheetNum). When I cloned original sheet(sheetA) with chart(chartA) in cloned sheet(sheetB) in chart(chartB) I have reference to original sheet(sheetA) but not to new(sheetB) . That doesn't works as expected and I think new chart(chartB) in the new sheet(sheetB) should have reference to fields from new(sheetB). I tried change references manual by CTNumRef.setF(String var1) and CTStrRef.setF(String var1) but when I did that I change reference also in original(chartA). That is only with cloned chart(chartB). I think they can be related with something together. Conclusion: I want to cloned chart(chartB) has reference to new cloned sheet (sheetB) not to original. Thx
Created attachment 36996 [details] Test case
Comment on attachment 36996 [details] Test case Sorry, this was for another ticket, no idea how it got attached here...
I am facing almost the same issue, except the fact, that i can't even open the File anymore with Excel (2016). It gets corrupted and can't be open, and not even be automatically repaired by Excel. I have also a Template sheet, including a chart. If i try to clone that template (and rename the clone), and save the file, the file is corrupt. If i repeat the same process after just deleting the chart, everything works. How can i contribute or help?
Hi, Could you repeat your experiment with the version I am trying to build on https://github.com/apache/poi/pull/227 and share your example file? Thanks!
Sadly i can't setup POI locally. It won't build. If you provide me somehow the jars (or help me to setup POI), i would be happy to test it! gunter.henning@gmx.de
When successful, the build https://ci-builds.apache.org/job/POI/job/POI-DSL-1.16/195/ will contain references to artifacts which you could download. You can find guidance to setup your development environment on https://poi.apache.org/devel/index.html You can also ask specific questions about building and testing through the mailing lists at https://poi.apache.org/help/index.html
Related change: r1886605