If you’re encountering the “WPS Spreadsheets encountered an error while trying to export to PDF” message when exporting a file in WPS Office, the solution is simple:
sudo apt install libtiff6
sudo ln -s /usr/lib/x86_64-linux-gnu/libtiff.so.6 /usr/lib/x86_64-linux-gnu/libtiff.so.5