[Bug]: Microsoft Excel input causes exception when getting fields from header row of ODS file

[hansva]

Apache Hop version?

2.4

Java version?

11

Operating system

Windows

What happened?

Migration: https://issues.apache.org/jira/browse/HOP-3028

Use provided DateTest.ods file

Start Hop Gui
With a single step "Microsoft Excel input" added to a new Transformation, add the DateTest.ods file.
Click on Fields tab.
Click on "Get fields from header row..." button.
Notice it hangs with long spinner, and console output
But file works fine with LibreOffice for example, see screenshot attached.
E:\Downloads\apache-hop-client-0.70-incubating\hop>echo off
===[Environment Settings - hop-gui.bat]===================================

Java identified as "E:\Java\openjdk-13.0.1_windows-x64_bin\jdk-13.0.1\bin\java"

HOP_OPTIONS=-Xmx2048m -DHOP_PLATFORM_OS=Windows -DHOP_PLATFORM_RUNTIME=GUI -DHOP_AUTO_CREATE_CONFIG=Y

Command to start Hop will be:
"E:\Java\openjdk-13.0.1_windows-x64_bin\jdk-13.0.1\bin\java" -classpath lib*;libswt\win64* -Djava.library.path=lib -Xmx2048m -DHOP_PLATFORM_OS=Windows -DHOP_PLATFORM_RUNTIME=GUI -DHOP_AUTO_CREATE_CONFIG=Y org.apache.hop.ui.hopgui.HopGui

===[Starting Hop]=========================================================
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by org.apache.hop.core.plugins.HopURLClassLoader (file:/E:/Downloads/apache-hop-client-0.70-incubating/hop/lib/hop-core-0.70.jar) to field java.net.URLClassLoader.ucp
WARNING: Please consider reporting this to the maintainers of org.apache.hop.core.plugins.HopURLClassLoader
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
2021/07/03 14:05:40 - Hop - Projects enabled
2021/07/03 14:05:40 - Hop - Enabling project : 'default'
Jul 03, 2021 2:16:34 PM org.odftoolkit.odfdom.pkg.OdfXMLFactory newOdfAttribute
INFO: None-ODF attribute created for calcext:value-type
Jul 03, 2021 2:16:34 PM org.odftoolkit.odfdom.pkg.OdfXMLFactory newOdfAttribute
INFO: None-ODF attribute created for calcext:value-type
Jul 03, 2021 2:16:34 PM org.odftoolkit.odfdom.pkg.OdfXMLFactory newOdfAttribute
INFO: None-ODF attribute created for calcext:value-type
Jul 03, 2021 2:16:34 PM org.odftoolkit.odfdom.pkg.OdfXMLFactory newOdfAttribute
INFO: None-ODF attribute created for calcext:value-type
Jul 03, 2021 2:16:34 PM org.odftoolkit.odfdom.pkg.OdfXMLFactory newOdfAttribute
INFO: None-ODF attribute created for calcext:value-type
Jul 03, 2021 2:16:34 PM org.odftoolkit.odfdom.pkg.OdfXMLFactory newOdfAttribute
INFO: None-ODF attribute created for calcext:value-type

DateTest.ods

Issue Priority

Priority: 3

Issue Component

Component: Transforms

[hansva]

.take-issue