Re: Feedback help/faq.html
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 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.
>
>
>
>
Re: Feedback help/faq.html
Hi,
I don't think anyone can help much if you don't provide an xlsx and the code
you use to manipulate the xlsx - a reproducible example. This avoids having
everyone guess what can be going wrong.
Also, it would be useful if you spell out what version of POI you are using and
if you using a version older than v5.2.3, my first response will be to ask you
to upgrade.
Email is probably not the best way to deal with this. Could you create an issue
at https://bz.apache.org/bugzilla
Regards,
PJ
On Wednesday 5 October 2022 at 18:16:42 IST, Ben ali Zeineb
wrote:
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.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
Re: Feedback help/faq.html
Thanks Robert - I updated that page.
On Thursday 27 January 2022, 18:35:21 GMT+1, Halter Robert
wrote:
Hello,
on our Page
https://poi.apache.org/help/faq.html
the Line
res = classloader.getResource("org/apache/poi/POIXMLDocument.class");
should be
res = classloader.getResource("org/apache/poi/ooxml/POIXMLDocument.class");
using version 5.2.0
see https://poi.apache.org/apidocs/dev/org/apache/poi/ooxml/POIXMLDocument.html
My current Problem:
if (cell.getCellType() == CellType.NUMERIC) {
è Method not found.
Greetings
Robert Halter
Test Automation Engineer
_
Adcubum AG
Zürcherstrasse 464
CH-9015 St. Gallen
Zentrale +41 58 411 66 66
robert.hal...@adcubum.com
www.adcubum.com
