Spreadsheet : XLSX with data validation not working properly after import

[ydelattre]

Do you want to request a feature or report a bug? bug What is the current behavior? After import of the XLSX attached, the table with data validation and cascading dropdown is not working properly. I need to validate the INDIRECT function from data validation panel to make the cascading dropdown works properly.

If the current behavior is a bug, please provide the steps to reproduce and if possible a minimal demo of the problem.

What is the expected behavior? Choice made from the first dropdown column id should update correctly the dropdown from the column prenom

Did this work in previous versions of DocumentServer? No

DocumentServer version: 7.0.1.37

Operating System: Docker

Browser version: Firefox 99.0.

XLSX file :

test_menu_cascade.xlsx

[alinasafonova]

Hello, @ydelattre

This is known issue - 56293 in our private issue tracker. Thank you for report.

[alinasafonova]

This problem is fixed in https://github.com/ONLYOFFICE/sdkjs/commit/92882ae8d1dbc4dc6d7e8743c2c9fd7a67750054

It will be released as v7.2.0

[ShockwaveNN]

DocumentServer v7.2 is released. This issue should be fixed

Feel free to comment or reopen it if you got further questions