E9.2 Problem importing data grid from an xlsx file with linked formula

[akkakm]

Hello EveryOne,
We have a problem importing grid data from xlsx file that containing a linked formula on an excel cell. The user get a web exception (exception occured in VTImportGrid.renderHTML4() java.lang.RuntimeException: Could not resolve external workbook name 'https://mycompany.sharepoint.com/si...G et XXX/Frais de gestion XXXX AG et XXX.xlsx'. The following workbook names are valid: ('')). This happened only on the new jde 9.2 TR 9.2.7.3, the same action in the old jde 9.0 TR 9.2.2.8.
I thought that may the system user can't access to sharepoint, so I asked the user to add it as admin with full right, I restart the HTML Services and re-test, I got the same error message.

Here is the steps:
1. Import Grid Data

2. Browse for file XLSX


3. Attach the XLSX file


4. After clicking on "OK", I get the exception error

N.B: I removed the company name only for security purposes

Thanks in advance for your help

 

[TFZ]

9.2.2.8 probably couldn't import Excel without ActiveX. 9.2.5.x and above can. This was previously a known issue to this "modern" HTML import for XLS files, not sure if it was fixed. You could copy paste to a new sheet without the formula as a work around.

 

[akkakm]

Thanks TFZ for your reply
Regards