cancel
Showing results for 
Search instead for 
Did you mean: 

Formula in Excel cell - XLSX Upload - A Unified Approach fails

Former Member
0 Kudos

Hello experts

I have successfully implemented the XLSX Upload - A Unified Approach written by Benu Mariantony ( link: https://scn.sap.com/docs/DOC-33578)

Unfortunately if I put in the excel file a formula in a cell  ( like = U10 /10 ), then I get a distorted data uploaded.

Below picturs shows, that the formula and the value is available in the xml file. But somehow the XLSX upload -how to doesn't manage properly. My suggestion?

Have someone and idea, how to correct or where to start to solve this 'feature'

Best regards and thanks a lot for your ideas and help

Christian

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

There is no solution and it is a limit of the unified approach.

Benu Mariantony  confirmed, that the solution is not build to handle formula in the Excel cell.

Thanks to Benu to give me the answer

Best regards