-
Notifications
You must be signed in to change notification settings - Fork 338
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
[Bug]: Excel File input unable to read calculated cell #3670
Comments
Hi @kenvang. First of all, because jdk 17 is not yet currently supported by Hop, can you please make a try with jdk 11? Thanks for your cooperation |
I checked last week, same behavior with java 11. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Apache Hop version?
2.7.0
Java version?
JDK-17
Operating system
Windows
What happened?
The Excel File Input transform when assigned an excel file and with the default parameters (the fields and field types the transform recommends), whenever the transform arrives at a specific row/field (look at example) the transform gives a HopCelValue exception: Cannot convert field "" from cell on sheet 1, row 68, column 5:, unsupported type Number formula with value: 34002.227. This same exception is also triggered when the troublesome fields are read as a string.
[Bug] Excel File input unable to read calculated cell.zip
Issue Priority
Priority: 2
Issue Component
Component: Transforms
The text was updated successfully, but these errors were encountered: