Hello,
I have an issue with apache poi
When i do
XSSFSheet sheet = workbook.getSheet("sheetName");
sheet.shiftRows(startRow,endRow,number ,true ,true);
That shift the row in the current sheet and update all formula in other
sheet where he type is shared, i think the issue is on the mehode
XSSFRowColShifter.updateRowFormulas because the formula is updated without
checking if the shared formula with the same sheet or not.
Please could you check wih me ?
Thanks and regards.
Le mer. 5 oct. 2022 à 16:21, Ben ali Zeineb <benalii.zei...@gmail.com> a
écrit :
> Hello,
>
>
> I have an issue with apache poi
>
> When i do
>
> XSSFSheet sheet = workbook.getSheet("sheetName");
>
> sheet.shiftRows(startRow,endRow,number ,true ,true);
>
>
> That shift the row in the current sheet and update all formula in other
> sheet where he type is shared, i think the issue is on the mehode
> XSSFRowColShifter.updateRowFormulas because the formula is updated without
> checking if the shared formula with the same sheet or not.
>
> Please could you check wih me ?
>
>
> Thanks and regards.
>
>
>
>
