VLOOKUP not working after exporting from ODS to PDF

Hi all!

I am having standard dropdown combobox populated from cell range.
Another cell is having VLOOKUP function based on selected value from the combobox.
This is working properly in ODS file.

Once it is exported to PDF, I am only able to see the values in dropdown list.
However values in another cell are not changing. They are same as when they were exported.

Is there any way how to make it working?


Of course it is not work in a PDF file. That has not any spreadsheet function. The PDF readers can not calculate or control anything.
The PDF is only an electronic print of the original document. Only the fillable form elements will work (you can fill it), but not the related calculations.