Michael Vorburger created FINERACT-1283:
-------------------------------------------
Summary: 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
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.3.4#803005)
