You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@fineract.apache.org by "Eyad Sharkawy (Jira)" <ji...@apache.org> on 2026/10/21 21:03:00 UTC
[jira] [Comment Edited] (FINERACT-1283) Cannot get a NUMERIC value from a STRING formula cell
[ https://issues.apache.org/jira/browse/FINERACT-1283?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18129856#comment-18129856 ]
Eyad Sharkawy edited comment on FINERACT-1283 at 10/21/26 9:02 PM:
-------------------------------------------------------------------
I fixed this bug. I linked [PR#6714|https://github.com/apache/fineract/pull/6714] [ |https://github.com/apache/fineract/pull/6405]for review when the team has time.
was (Author: JIRAUSER314528):
I went ahead and implemented this feature. I have linked [PR#6714|https://github.com/apache/fineract/pull/6714] [ |https://github.com/apache/fineract/pull/6405]for review whenever the team has time!
> Cannot get a NUMERIC value from a STRING formula cell
> ------------------------------------------------------
>
> Key: FINERACT-1283
> URL: https://issues.apache.org/jira/browse/FINERACT-1283
> Project: Apache Fineract
> Issue Type: Bug
> Components: Migration Scripts
> Affects Versions: 1.4.0
> Reporter: Michael Vorburger
> Assignee: Eyad Sharkawy
> Priority: Major
> Fix For: 1.17.0
>
>
> See FINERACT-932 for general background, I just saw 1 of these in the Fineract.dev log, perhaps someone would like to improve the code to handle such cases more gracefully and let the end-user know with a more useful error message on the import, than this internal error which the end-users probably is not made aware of (note how it happens in an {{onApplicationEvent}}):
> {noformat}java.lang.IllegalStateException: Cannot get a NUMERIC value from a STRING formula cell
> at org.apache.poi.hssf.usermodel.HSSFCell.typeMismatch (HSSFCell.java:647)
> at org.apache.poi.hssf.usermodel.HSSFCell.checkFormulaCachedValueType (HSSFCell.java:652)
> at org.apache.poi.hssf.usermodel.HSSFCell.getNumericCellValue (HSSFCell.java:677)
> at org.apache.poi.hssf.usermodel.HSSFCell.getDateCellValue (HSSFCell.java:693)
> at org.apache.fineract.infrastructure.bulkimport.importhandler.ImportHandlerUtils.readAsDate (ImportHandlerUtils.java:148)
> at org.apache.fineract.infrastructure.bulkimport.importhandler.client.ClientPersonImportHandler.readClient (ClientPersonImportHandler.java:103)
> at org.apache.fineract.infrastructure.bulkimport.importhandler.client.ClientPersonImportHandler.readExcelFile (ClientPersonImportHandler.java:78)
> at org.apache.fineract.infrastructure.bulkimport.importhandler.client.ClientPersonImportHandler.process (ClientPersonImportHandler.java:67)
> at org.apache.fineract.infrastructure.bulkimport.service.BulkImportEventListener.onApplicationEvent (BulkImportEventListener.java:141)
> at org.apache.fineract.infrastructure.bulkimport.service.BulkImportEventListener.onApplicationEvent (BulkImportEventListener.java:49)
> at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener (SimpleApplicationEventMulticaster.java:172)
> at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener (SimpleApplicationEventMulticaster.java:165)
> at org.springframework.context.event.SimpleApplicationEventMulticaster.lambda$multicastEvent$0 (SimpleApplicationEventMulticaster.java:136)
> at java.lang.Thread.run (Thread.java:834){noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)