Error "java.lang.NoSuchMethodError: 'org.apache.poi.ss.usermodel.CellType" during Import From Spreadsheet action in Windchill PDMLink

• Exception below is thrown in Method Server logs during Import From Spreadsheet

ERROR com.ptc.jca.mvc.controllers.ActionController User_Name - java.lang.reflect.InvocationTargetException java.lang.reflect.InvocationTargetException
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	...
Caused by: java.lang.NoSuchMethodError: 'org.apache.poi.ss.usermodel.CellType org.apache.poi.ss.usermodel.Cell.getCellType()'
	at com.ptc.windchill.ixb.importer.xls.XlsSheetParser.getCellValueAsString(XlsSheetParser.java:284)
	at com.ptc.windchill.ixb.importer.xls.XlsSheetParser.parseSheetType(XlsSheetParser.java:97)
	at com.ptc.windchill.ixb.importer.StandardImportService.getPreImportSheetValidatorHandler(StandardImportService.java:1534)
	at com.ptc.windchill.ixb.importer.StandardImportService.doPreviewOrImport(StandardImportService.java:858)
	at com.ptc.windchill.ixb.importer.StandardImportService.doPreview(StandardImportService.java:385)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
	at com.sun.proxy.$Proxy268.doPreview(Unknown Source)
	at com.ptc.windchill.ixb.importer.jca.processor.ImportFormProcessor.validateJob(ImportFormProcessor.java:441)
	at com.ptc.windchill.ixb.importer.jca.processor.ImportFormProcessor.postTransactionProcess(ImportFormProcessor.java:222)
	at com.ptc.core.components.forms.DefaultFormProcessorController.executePostTransactionProcess(DefaultFormProcessorController.java:711)
	at com.ptc.core.components.forms.DefaultFormProcessorController.performExecutePostTransactionProcess(DefaultFormProcessorController.java:361)
	at com.ptc.core.components.forms.DefaultFormProcessorController.execute(DefaultFormProcessorController.java:279)
	at com.ptc.core.components.forms.FormDispatcher.callControllerExecute(FormDispatcher.java:146)
	at com.ptc.core.components.forms.FormDispatcher.callFormProcessorController(FormDispatcher.java:116)
	at com.ptc.core.components.forms.FormDispatcher.execute(FormDispatcher.java:93)
	... 62 more

• Error "java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.Cell.getCellType()" when exporting QML report results to XLSX
  • Exception in Method Server logs:

    ERROR com.ptc.jca.mvc.controllers.ActionController User_Name - java.lang.reflect.InvocationTargetException
    java.lang.reflect.InvocationTargetException
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    	at java.lang.reflect.Method.invoke(Method.java:498)
    	...
    Caused by: java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.Cell.getCellType()Lorg/apache/poi/ss/usermodel/CellType;
    	at org.apache.poi.xssf.streaming.SheetDataWriter.writeCell(SheetDataWriter.java:258)
    	at org.apache.poi.xssf.streaming.SheetDataWriter.writeRow(SheetDataWriter.java:207)
    	at org.apache.poi.xssf.streaming.SXSSFSheet.flushOneRow(SXSSFSheet.java:1876)
    	at org.apache.poi.xssf.streaming.SXSSFSheet.flushRows(SXSSFSheet.java:1851)
    	at org.apache.poi.xssf.streaming.SXSSFSheet.flushRows(SXSSFSheet.java:1865)
    	at org.apache.poi.xssf.streaming.SXSSFWorkbook.flushSheets(SXSSFWorkbook.java:972)
    	at org.apache.poi.xssf.streaming.SXSSFWorkbook.write(SXSSFWorkbook.java:946)
    	at com.ptc.core.components.export.table.AbstractExportToXLS.close(AbstractExportToXLS.java:225)
    	at com.ptc.core.components.export.table.ExportToXLSX.close(ExportToXLSX.java:23)
    	at com.ptc.core.components.export.table.ExportListCommands.doExportOperation(ExportListCommands.java:135)
    	at com.ptc.core.components.export.table.ExportListCommands.doExport(ExportListCommands.java:100)
    	at com.ptc.core.components.export.table.ExportListCommands.export(ExportListCommands.java:86)
    	... 67 more

• Pop-up window with message "ATTENTION: DEFAULT" while exporting Importable Spreadsheet as XLSX or importing from Spreadsheet in XLSX format
  • Exception in Method Server logs: 

    Caused by: java.lang.NoSuchFieldError: DEFAULT 
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:161)
    at com.ptc.windchill.ixb.exporter.Xml2Xls.export2Xls(Xml2Xls.java:510)
    at com.ptc.windchill.ixb.exporter.forms.XlsExportFormProcessor.convertExportJarToXls(XlsExportFormProcessor.java:419)
    at com.ptc.windchill.ixb.exporter.forms.XlsExportFormProcessor.doOperation(XlsExportFormProcessor.java:216)