I’ve had a problem with the LibreOffice Calc print preview function for a while. The problem is not showing the selected sheet(s) and I’ve always assumed it was more a problem with me than with the software. I finally got annoyed enough with my work around for the problem that I decided to search for an answer. The answer I found was 2½ years old making me feel even dumber for not looking sooner. So if you can’t get some sheets to show in print preview simply go to the sheets that do show and delete the defined print ranges (Format -> Print Ranges -> Remove). When you think about it this is the proper behavior, setting a print range tells Calc to not print anything else in the spreadsheet.