[
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)
