I want to add row in excel by java POI and I try with both shiftRows() function and createRow() function
both function can add row in excel but below chart position is remain and not move
I also like to move (shift down) the position of chart
I use poi version 3.9
Can anyone give me the advice or idea to move the position of that chart image
As the fact, the data range of chart also not changed. I need not only to move the position of charts but also need to increase the data range of chart
thanks!!
解决方案
The shifting of the drawing anchors which determine the chart positions is possible. The method void insertRowsShiftShapes(Sheet sheet, int startRow, int n)