[FINERACT-1283] Cannot get a NUMERIC value from a STRING formula cell

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.4.0
• Component/s: Migration Scripts
• Assignee: Unassigned
• Reporter: Michael Vorburger
• Created: 04/Jan/21 10:25
• Updated: 04/Jan/21 10:26

Description

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

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)

Issue Links

• blocks: FINERACT-932 Parent Issue for Error Logs seeing during "normal" usage (e.g. on fineract.dev)