How to set different page size for different sheets in one document in calc?

I want to set each sheet with different page size

For each variation of the page style like orientation, paper size, margins, header/footer settings you need to define a named PageStyle in the Stylist: >Styles>Manage Styles>>Page Styles (Ctrl+F11, then respective icon).
There you can derive new styles from existing ones (but without heritage).
To assign one of your styles to a sheet, and by that to all the pages printed with contents from that sheet, you only need to doubleclick the stylename in the Stylist while the sheet is active.
Pages made from the same sheet you cannot print with different page styles.

Thank you, it’s working fine

The site expects you in this case to accept the answer by clicking the checkmark in the gray circle left of your question. It then will also be shown (in green) if the question matches a search by a different user.
(Read the tooltip shown when the mouse hovers the checkmark.)