[I] [Bug]: Excel File input unable to read calculated cell (hop)

["kenvang (via GitHub)" <gi...@apache.org>]

kenvang opened a new issue, #3669:
URL: https://github.com/apache/hop/issues/3669

   ### 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](https://github.com/apache/hop/files/14401641/Bug.Excel.File.input.unable.to.read.calculated.cell.zip)
   
   
   ### Issue Priority
   
   Priority: 2
   
   ### Issue Component
   
   Component: Transforms


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] [Bug]: Excel File input unable to read calculated cell (hop)

["kenvang (via GitHub)" <gi...@apache.org>]

kenvang closed issue #3669: [Bug]: Excel File input unable to read calculated cell
URL: https://github.com/apache/hop/issues/3669


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org