Please raise a bug in bugzilla. POI is a volunteer project and I am currently busy and don't have a lot of time to devote to unpaid work.
On Tue, 13 May 2025 at 15:41, Dan S <[email protected]> wrote: > > PJ, > I am trying to use the copyRows as you suggested but I am hitting some > exceptions regarding formulas even though my data has no formulas. I took a > unit test of mine in which I was testing the bug I reported in > https://bz.apache.org/bugzilla/show_bug.cgi?id=69583 and refitted it with an > HSSFWorkbook along with my code which creates a new Workbook from each Sheet > of an existing Workbook. The unit code test is included as an attachment. The > stacktrace I get is: > > [main] WARN org.apache.poi.POIDocument - DocumentSummaryInformation property > set came back as null > [main] WARN org.apache.poi.POIDocument - SummaryInformation property set came > back as null > > java.lang.IllegalStateException: Cannot get a FORMULA value from a STRING > formula cell > > at org.apache.poi.hssf.usermodel.HSSFCell.typeMismatch(HSSFCell.java:648) > at org.apache.poi.hssf.usermodel.HSSFCell.getCellFormula(HSSFCell.java:640) > at > org.apache.poi.hssf.usermodel.helpers.HSSFRowColShifter.updateRowFormulas(HSSFRowColShifter.java:74) > at > org.apache.poi.hssf.usermodel.helpers.HSSFRowShifter.updateRowFormulas(HSSFRowShifter.java:71) > at org.apache.poi.hssf.usermodel.HSSFRow.copyRowFrom(HSSFRow.java:853) > at > org.apache.nifi.excel.TestHSSFRowCopyRowFrom.test(TestHSSFRowCopyRowFrom.java:74) > at java.base/java.lang.reflect.Method.invoke(Method.java:580) > at java.base/java.util.ArrayList.forEach(ArrayList.java:1596) > at java.base/java.util.ArrayList.forEach(ArrayList.java:1596) > > > > On Mon, May 12, 2025 at 6:32 PM Dan S <[email protected]> wrote: >> >> PJ, >> Thank you! That is very helpful and aligns very well with the XSSFSheet >> copyRows method in regards to use of CellCopyPolicy and CellCopyContext. >> >> On Mon, May 12, 2025 at 5:49 PM PJ Fanning <[email protected]> wrote: >>> >>> There is copyRowFrom in HSSFRow. >>> >>> https://poi.apache.org/apidocs/dev/org/apache/poi/hssf/usermodel/HSSFRow.html#copyRowFrom-org.apache.poi.ss.usermodel.Row-org.apache.poi.ss.usermodel.CellCopyPolicy-org.apache.poi.ss.usermodel.CellCopyContext- >>> >>> On Mon, 12 May 2025 at 21:54, Dan S <[email protected]> wrote: >>> > >>> > XSSFSheet has a copyRows method which allows for copying the contents of >>> > one XSSFSheet to another one. I do not see an equivalent method for an >>> > HSSFSheet. I see from this post >>> > <https://lists.apache.org/[email protected]:dfr=2020-1-1|dto=2025-5-12:HSSFSheet%20copy> >>> > a solution which allows copying for HSSFSheet and XSSFSheet. I just want >>> > to >>> > make sure if that is a recommended way for HSSF and if not has there been >>> > any change to POI that provides methods for this? >>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: [email protected] >>> For additional commands, e-mail: [email protected] >>> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
